Mysql error

[R3laX 0]

Hello,

I got the problem that i get this message from Navicat : 1130 - host ' MY IP ' is not allowed to connect to this mysql server. its Hamachi please help

 

 

~Sorry for bad english 

 

 

To fix the error : 

 

you just have to login in the cmd in mysql an just run this commands 

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' Enter drücken

IDENTIFIED BY 'your pw' WITH GRANT OPTION;

[Metin2 Dev 12288]

mysqladmin -u root -p yourpass

mysql -u root -p

Enter your pass

GRANT ALL PRIVILEGES ON *.* TO root@"%"

IDENTIFIED BY 'your_pass' WITH GRANT OPTION;

quit

 

check this

 

 

otherwise

run

ee /usr/local/etc/rc.d/mysql-server

 

change mysqluser="mysql" to  mysqluser="root"

 

[Toxic 11]

 

mysqladmin -u root -p yourpass

mysql -u root -p

Enter your pass

GRANT ALL PRIVILEGES ON *.* TO root@"%"

IDENTIFIED BY 'your_pass' WITH GRANT OPTION;

quit

 

check this

 

 

otherwise

run

ee /usr/local/etc/rc.d/mysql-server

 

change mysqluser="mysql" to  mysqluser="root"

 

 

Quote: Only if you have mysql.sock problem.

[flygun 356]

check if the port is open O.o

[Night 382]

check if the port is open O.o

 

hamchi doesnt need to open port in most of the cases

 

[flygun 356]

 

check if the port is open O.o

 

hamchi doesnt need to open port in most of the cases

 

 

 

yeah i know 

but the i think you need to open the port for the sql at least

cus my server is hamachi and i can't open sql without the port