Tutorial on installing MySQL 5.7.28 on CentOS 6.2 (mysql notes)

1. Environmental Preparation

1.MySQL installation path: /usr/local

2. CentOS 6.2 Server (64 bit)

3. MySQL 5.7.28 Download (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.1 Unzip and rename to mysql

2.2 Create a data directory under the mysql directory

2.3 Create mysql user groups and users, and set user groups and users for the mysql directory

2.4 Initialize mysql

2.5 Start mysql service

2.6 Set the MySQL service to start automatically at boot

3.MySQL connection

4. Change password

Change the generated random password to root

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

For security reasons, by default, no machine other than the mysql host is allowed to access the mysql database service in Linux. Therefore, root needs to be reauthorized to facilitate remote access.

If Navicate still cannot connect to MySQL remotely at this time, please pay attention to the firewall problem. In an online environment, it is generally recommended to close the specified port, but not the firewall. To learn how to open a specified port, please refer to: Open a specified port in Linux

This example uses the MySQL default port 3306 for demonstration. Open the port by command vi /etc/sysconfig/iptables

6. Navicate remote login to MySQL

Test remote login to MySQL, the connection is successful.

If the following problems occur, please refer to:

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: Installing MySQL using binary source code results in failure to start the MySQL service using service mysqld start

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

Summarize

The above is the tutorial on how to install MySQL 5.7.28 on CentOS 6.2. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!