Sharing about the installation tutorial of MySQL5.6.27 under Linux (picture)

This article mainly introduces in detail LinuxMySQL 5.6.27 Installation tutorial, which has certain reference value , Interested friends can refer to

The examples in this article share the installation tutorial of MySQL 5.6.27 under Linux for your reference. The specific content is as follows

1. Download address

2. Upload the compressed package to the server

3. Unzip

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 database

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

Modify the current directory owner to mysql User: execute the command

chown -R mysql:mysql ./

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

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

Modify 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 startup mysql service

8. Modify the root user password of mysql,

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

9. For 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.       

The above is the detailed content of Sharing about the installation tutorial of MySQL5.6.27 under Linux (picture). For more information, please follow other related articles on the PHP Chinese website!