Install mysql under ubuntu16.04 and enable remote access. ubuntu16.04mysql

Install mysql under ubuntu16.04 and enable remote access. ubuntu16.04mysql
I. Installation

Apt-get install mysql-server

2. Local Connection

The local connection is enabled for mysql by default.

Use mysql-uuser-p and enter the password to access

3. enable remote access 3.1 and create a user with the same permissions as the Administrator

Grant all privileges on *. * to 'user' @ '%' identified by 'Password' with grant option

3.2 update mysql Permissions

Flush privileges

3.3 modify the configuration file for remote access

Vim/etc/mysql. conf. d/mysqld. cnf

3.4 use "#" to comment out "bind-address = 127.0.0.1" 3.5. Restart the mysql service.

Service mysql restart

Then you can remotely access other clients.