Configuring MySQL on Aliyun

System environment: Ubuntu 16.04

1. First see if your server has MySQL installed

sudo grep MySQL

No reaction? No installation of course is not responding. If there is a reaction can be self-upper right corner of ...

2. Install MySQL

sudo Install mysql-serversudoinstall mysql-clientsudo  Install Libmysqlclient-dev

In the first line of command execution, you need to enter your MySQL password, not your Linux user's password ...

Test:

You can then test your MySQL with the code you used in step 1 to see if it's installed.

It's not the same ... This indicates that the installation is ready.

And then we need to set up remote access for MySQL

1. Log in to MySQL

Now that we have MySQL installed, let's log in to MySQL first.

2. After landing we need to set up a user that can be accessed.

GRANT all privileges on * * to ' test ' @'%'123456' with GRANT OPTION; FLUSH privileges;

User name: Test and Password: 123456

The line above is to create a user, and the following line commits

PS: Because the knowledge of MySQL is not too deep, do not understand the above code

3. We need to modify the MySQL configuration file

Vi

One line will be set, Bind-address = 127.0.0.1 is commented out with #. Then I'll be fine.

Test:

Software: Navicat for MySQL

Create a new link, connect the name casually, the hostname is your IP address, user name and password is the above you entered

This is the case of being able to link:

If the user name is wrong, this is the case ....

Reference:

[1] http://www.linuxidc.com/Linux/2017-01/139502.htm

[2] http://blog.csdn.net/u011531010/article/details/52314651

Configuring MySQL on Aliyun