Shulou(Shulou.com)06/01 Report--

Preface

Recently, I have encountered this demand in my work, and it is estimated that it took more than an hour to get this remote connection done well. A local computer, a cloud server, are all linux systems. Let's take a look at the detailed introduction:

Steps

1. Enable remote access on the server side

First enter the mysql database, and then enter the following two commands:

?

12grant all privileges on *. * to 'root'@'%' identified by' password';flush privileges

The first * is the database, which can be changed to a database name that is allowed to be accessed.

The second is the table name of the database, which means that arbitrary tables are allowed to be accessed

Root represents the user name used for remote login and can be customized

% means to allow any ip login. If you want to specify a specific IP, you can replace the%.

Password represents the password used when logging in remotely, and can be customized

Flush privileges;, this is to let the permissions take effect immediately.

2. Modify my.cnf configuration file

This is the configuration file for mysql. If you can't find the title article, you can type find / *-name my.cnf to find it.

Edit the file through vim, find the sentence bind-address = 127.0.0.1, then add a # comment in front of it, and save and exit

3. Restart the service

?

1service mysql restart

4. Connect remotely locally

At the terminal, enter:

?

1mysql-h server ip address-P 3306-u root-p

Then enter the password.

Root is the user name set at point 1, and the password is also the password set at point 1.

Some details.

Found a lot of articles on the Internet, said to open port 3306 to connect, but I opened but still could not connect, and then found some articles, said to change the my.cnf, that is, the second point above, change and then restart the server on it.

Just tried on another server, no port has been configured, through the above three steps, quickly connected.

So the second point is very important, basically everyone will configure that file when installing mysql, because the character set needs to be configured. So there must be that file, just use the find command to find it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.