Sunday, April 28, 2013

Allow root remote access to MySql database in linux

Sunday, April 28, 2013 Posted by Unknown , , , , , ,
First install the database by entering:
sudo apt-get install mysql-server
After installing mysql database edit the file /etc/mysql/my.cnf:
change the line:
bind-address =
bind-address =

Now restart the mysql service:
sudo service mysql restart

Now login to the server:
mysql -u root -p mysql
Now enter the following:
grant all privileges on *.* to 'root'@'%' identified by '' with grant option;
flush privileges;

Now you are able to manage the database remotely by MySql Workbench.