MySQL Turn on remote access

Environmental Ubuntu-14.0 mysql-5.5

1. Modify the MySQL configuration file/etc/mysql/my.cnf, block out the following line of content

Bind-address = 127.0.0.1

2. Log in to MySQL and execute the command sequentially

Mysql-uroot-prootroot

GRANT all privileges on * * to ' root ' @ '% ' identified by ' password ' with GRANT OPTION;

Use MySQL;

UPDATE mysql.user SET password=password (' rootroot ') WHERE user= ' root '; The rootroot here is your old password.

FLUSH privileges;

3. Restart the service

If you have a firewall, turn off the appropriate firewall.

MySQL Turn on remote access