MySQL 5.6.27 Installation Tutorial under Linux

This article shares the installation tutorial of MySQL 5.6.27 under Linux for your reference. The specific contents are as follows

1. Download address

https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz

2. Upload the compressed package to the server

3. Decompression

tar -zxf mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz

4. Move the compressed package to the mysql folder

mp mysql-5.6.27-linux-glibc2.5-x86_64 /usr/local/mysql

5. Add mysql user group and mysql user

groupadd mysql and useradd -r -g mysql mysql

6. Install the database

Enter the mysql software directory: cd /usr/local/mysql

Change the owner of the current directory to the mysql user: execute the command chown -R mysql:mysql ./

Install the database: execute the command ./scripts/mysql_install_db --user=mysql

Change the owner of the current directory to the root user: execute the command chown -R root:root ./

Change the owner of the current data directory to the mysql user: execute the command chown -R mysql:mysql data

7. Start the MySQL service and add the boot startup MySQL service

8. Change the root user password of mysql.

./bin/mysqladmin -u root password 'password'

9. Remote authorization

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root WITH GRANT OPTION;

question:

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

No good solution has been found yet.

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.6 installation tutorials for various versions

MySQL 5.7 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.