Remote access to Ubuntu under MySQL problem

Tag: operation without span cal BSP title default DDR status

The problem of MySQL cannot be remotely accessed with IP address under Ubuntu

Method 1:

1.mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' root ';

　　

(%) Represents all IP

The 1th root indicates an account

The 2nd root indicates a password

2.mysql>flush privileges;

3. Stop and restart the MySQL service.

Stop command:

Service MySQL Stop

Start command:

Service MySQL Start

View Status:

Service MySQL Status

If the above operation is still inaccessible, then MySQL should not allow remote access.

To modify a configuration file:

sudo vim/etc/mysql/mysql.conf.d/mysqld.cnf

Comment out bind-address = 127.0.0.1 (that is, add # at the beginning of the line), as follows:

The code is as follows:

# Instead of skip-networking The default is now-listen only on # localhost which are more compatible and are not less secure. # bind-address          = 127.0.0.1

You can then restart the service to access it.

Remote access to Ubuntu under MySQL problem