Allow users to connect remotly to MySQL

By | August 15, 2009

Sometimes, you want to allow users to connect remotly to your MySQL server, all you have to do is to run the following command

grant all privileges on *.* to ‘root’@’81.91.101.111’ identified by ‘password’ with GRANT OPTION;

This will grant all privileges to user root and will allow him to connect from 81.91.101.111

Cheers,

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.