Difference between revisions of "Mysql remote access"
From thelinuxwiki
(Pushed from Themanclub.) |
|||
| Line 2: | Line 2: | ||
@ mysql server prompt, ran.. | @ mysql server prompt, ran.. | ||
| − | GRANT ALL ON local.* TO root@' | + | 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'; | ||
| + | |||
[[category:mysql]] | [[category:mysql]] | ||
Latest revision as of 01:37, 27 July 2013
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';
