R3laX 0 Posted July 9, 2014 Share Posted July 9, 2014 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; Link to comment Share on other sites More sharing options...
Bot Metin2 Dev 4884 Posted July 9, 2014 Bot Share Posted July 9, 2014 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" 1 Link to comment Share on other sites More sharing options...
Toxic 11 Posted July 10, 2014 Share Posted July 10, 2014 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. Link to comment Share on other sites More sharing options...
Former Staff flygun 304 Posted July 10, 2014 Former Staff Share Posted July 10, 2014 check if the port is open O.o Link to comment Share on other sites More sharing options...
Night 366 Posted July 10, 2014 Share Posted July 10, 2014 check if the port is open O.o hamchi doesnt need to open port in most of the cases Link to comment Share on other sites More sharing options...
Former Staff flygun 304 Posted July 10, 2014 Former Staff Share Posted July 10, 2014 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now