Mysql remote access

From thelinuxwiki

Revision as of 01:37, 27 July 2013 by Nighthawk (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

enabled some settings in /etc/mysql/my.cnf

@ mysql server prompt, ran..

GRANT ALL ON local.* TO root@'192.168.1.10' IDENTIFIED BY 'rootspassword';

for a whole network

GRANT ALL ON local.* TO root@'192.168.1.%' IDENTIFIED BY 'rootspassword';

Retrieved from "http://www.thelinuxwiki.com/index.php?title=Mysql_remote_access&oldid=463"

mysql