Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
apoelaras123
Nivel 1

Nivel 1
Mesaje: 59
Membru din: 10 Aug 2019, 22:57
Regat: Chunjo
Aprecieri: 32  
Mulţumiri: 1  
Medalii

*Problemă/Întrebare: I can't connect to navicat-mysql
This error appear when i try to connect to navicat: http://prntscr.com/rwx3k6 i tried using ssh tunnel but the same error appear aswell: http://prntscr.com/rwx40v . NOTE* I CAN CONNECT TO MYSQL FROM PUTTY USING THE SAME PASSWORD AS I AM USING IN NAVICAT.
Thanks to anyone who will help.
Avatar utilizator
YoKe
Fost Helper

Fost Helper
Mesaje: 235
Membru din: 07 Ian 2015, 00:34
Regat: Chunjo
Aprecieri: 133  
Mulţumiri: 13  
 Contact:
Medalii

check if you have active addip function.
Nu raspund intrebarilor stupide in PM
Ai o problema contacteaza-ma, te ajut cand am timp .
Afișează semnătura
Avatar utilizator
apoelaras123
Nivel 1

Nivel 1
Mesaje: 59
Membru din: 10 Aug 2019, 22:57
Regat: Chunjo
Aprecieri: 32  
Mulţumiri: 1  
Medalii

YoKe scrie: ↑10 Apr 2020, 20:02 check if you have active addip function.
how?
Avatar utilizator
apoelaras123
Nivel 1

Nivel 1
Mesaje: 59
Membru din: 10 Aug 2019, 22:57
Regat: Chunjo
Aprecieri: 32  
Mulţumiri: 1  
Medalii

#SOLVED
Open up the file under 'etc/mysql/my.cnf'
Check for:

port (by default this is 'port = 3306')
bind-address (by default this is 'bind-address = 127.0.0.1'; if you want to open to all then just comment out this line. For my example, I'll say the actual server is on 10.1.1.7)
Now access the MySQL Database on your actual server (say your remote address is 123.123.123.123 at port 3306 as user 'root' and I want to change permissions on database 'dataentry'. Remember to change the IP Address, Port, and database name to your settings)

mysql -u root -p
Enter password: <enter password>
mysql>GRANT ALL ON *.* to root@'123.123.123.123' IDENTIFIED BY 'put-your-password';
mysql>FLUSH PRIVILEGES;
mysql>exit
Avatar utilizator
Ionuţ M.
Metin Master

Metin Master
Mesaje: 2680
Membru din: 28 Noi 2015, 22:02
Aprecieri: 170  
Mulţumiri: 12723  
  Rezolvări prob.: 2
Discord: Copiază ID
 Contact:
Medalii

Arhivat.
Imagine
Afișează semnătura
Închis

Înapoi la “Arhivă Probleme şi Întrebări”

  • Informaţie