Mysql remote access

From thelinuxwiki
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';