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

1. Environmental preparation

1.MySQL installation path: / usr/local

2.CentOS 6.2Server (64 bit)

Download 3.MySQL 5.7.28 (64bit)

Wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz

2.MySQL installation

2.1Unzip and rename to mysql

2.2 under the mysql directory, create a data directory

2.3 create user groups and users for mysql, and set user groups and users to the mysql directory

2.4 initialize mysql

2.5 start the mysql service

2.6. set the mysql service to boot automatically

3.MySQL connection

4. Modify the password

Change the generated random password to root

5. Set the remote login mysql (in this example, connect to MySQL remotely through Navicate)

For security under Linux, machines other than mysql are not allowed to access mysql database service by default, so it is necessary to re-authorize root to facilitate remote access.

If Navicate is still unable to connect to MySQL remotely at this time, pay attention to the firewall problem. It is generally recommended that designated ports be closed in online environments, but firewalls are not recommended. For more information on how to open designated ports, please refer to: Linux Open designated Ports

This example uses MySQL default port 3306 to demonstrate. Open the port with the command vi / etc/sysconfig/iptables

6. Navicate remote login MySQL

Test remote login MySQL, the connection is successful.

Please refer to the following problems:

1.ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords

Please refer to the link: https://www.jb51.net/article/174243.htm

2. ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/ tmp/mysql.sock'

Please refer to the link: https://www.jb51.net/article/174244.htm

3. The error message is mysqld: unrecognized service

Error condition: install MySQL with binary source code, so that the MySQL service cannot be started using service mysqld start

Please refer to the link: https://www.jb51.net/article/174244.htm

Summary

The above is the tutorial of CentOS 6.2installing MySQL 5.7.28 introduced by the editor to you. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.