You are here

MySql permissions - fun fun fun

With thanks to Ramesh Nataranjan and his article here http://www.thegeekstuff.com/2010/08/allow-mysql-client-connection/, and also modding the bind-address in the my.cnf file, I can now connect.

$ mysql -u root -p
Enter password:

mysql> use mysql

mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';

mysql> FLUSH PRIVILEGES;