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

This article is about how to install mysql on the server. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

How to install mysql on the server: first download and install xshell;, then enter the root password on the pop-up page, and use the [mysql-u root-p password] to enter the database; then enter the current folder to modify it; finally, exit and restart.

How to install mysql on the server:

First, the tool used: xshell (downloaded from the official website), the purpose is to use the linux system to operate your server. Just enter all kinds of commands, very fast.

Pretend that your server has installed the http reverse proxy server nginx, and install the mysql database in the server

Third, the focus begins. Here's how to install mysql step by step and set up a remote connection.

1. Apt-get install mysql-server mysql-client-y

2. On the pop-up page, enter the root password:

3. Repeat password

4. Command line mysql-u root-p password

5. Enter the database

6. Enter the current folder

7. Modify the current file under the current folder (enter this file: vim mysqld.cnf)

8. Enter the file to modify and find this line (keyboard controls the cursor), comment out (the comment method is to add a # in front of it), and save it (enter ": wq" directly)

9. Enter mysql on the command line

10. Enter: grant all on *. * to root@'%' identified by 'jgx13245' with grant option

11. Before entering: flush privileges

12. Exit quits. Restarting mysql (/ etc/init.d/mysql restart)

13. If any of the above buttons are wrong, enter: Q! (do not save exit, do it again)

14. Connect in the upper left corner of navicat, enter the IP of your server, and the connection will be successful.

Thank you for reading! About the method of installing mysql on the server to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see 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.