Error 1130 in mysql

Question

when i am trying to log on mysql using my ip address i am getting error 1130 qht can i do for this

Answer 1

On your server run mysql from command line:

mysql -u root -p -h localhost -P 3306

Then run this command in mysql shell:

>use mysql
>GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'yourpassword';
>FLUSH PRIVILEGES;

Have a nice time.