$ vi /etc/mysql/my.cnf
search bind_address..
comment bind_address..
$ sudo -s -H
$ ls -l /etc | grep my
$ ls -l /etc/mysql | grep my
$ /etc/init.d/mysql restart
$ mysql -u root -p
mysql > show grants;
Now you will see the following query:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B' WITH GRANT OPTION
Copy above query and paste it into terminal and replace 'localhost' by %.
mysql > flush privileges;
Cheers!
No comments:
Post a Comment