Detailed introduction to the entire process and precautions of installing MySql5.7.17 under the latest Linux system

This article is the latest versionlinuxUnder the systemInstallationmysql 5.7 The whole process of .17 and Notes are very good and have reference value. Friends who need it can refer to it

1. cd /usr/local/ ##Enter the local directory

2. cp /home/soft/MySQL-5.7.15-Linux-glibc2.5-x86_64.tar.gz /usr/local/

##Copy mysql compressed to the local directory

3. cd /usr/local/ ##Enter the local directory

4. tar -xzvf mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz

##Decompress the mysql compressed package

5, mv mysql-5.7.15-linux-glibc2.5-x86_64 mysql ##Rename the mysql directory

6, groupadd mysql ##Add A mysql group

7, useradd -r -g mysql mysql ##Add a user

8, chown -R mysql mysql/ ##Authorize the mysql directory to the mysql user

9. mkdir /home/mysql-data ##Create the mysql-data directory

10. chown -R mysql:mysql /home/mysql-data ##Authorize the mysql-data directory to the mysql group Mysql user

11, chgrp -R mysql /home/mysql-data ## The chgrp command can use the group name or group identifier to change the group to which a file or directory belongs (-R: Process all files in the specified directory and its subdirectories) The usage permission is super user

12. cd /usr/local/mysql ##Enter the mysql directory

13. cp support-files. /my-default.cnf ./my.cnf ##Copy the my-default.cnf file in the support-files directory to the my.cnf file in the current directory

14, vi /usr/local/mysql/ my.cnf ##Edit my.cnf file

basedir = /usr/local/mysql
##basedir is the path to mysql
datadir = /home/mysql-data
## datadir is the data package of mysql, which stores mysql's own package
port = 3306 ##mysql port
#server-id = 100
##Server ID

socket = /tmp /mysql.sock

15. cp -fr my.cnf /etc/my.cnf ##Copy the my.cnf file to the etc directory (replace it if it exists in the etc directory)

16. vi /etc/profile ##Edit the profile file in the etc directory

export PATH=/usr/local/mysql/bin:$PATH
##Add

# at the end of the profile file ##17. source /etc/profile ##Reload the profile file in the etc directory

18. cp -a ./support-files/mysql.server /etc/init.d/mysqld

##Copy

19../bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/home/mysql-data

##Initialization

Important:

You need to pay attention to recording the generated temporary password, as above: jgghKqQhZ8*e

Note:

If the error message after execution is ./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file:

No such file or directory

CentOS7.2 needs to install libaio, execute the following command to install it

[root@localhost mysql]# yum install libaio

Re-execute the initialization command after the installation is complete

20, [[[password]]]] ##Note the generated temporary password, such as: jgghKqQhZ8*e

21, /etc/init .d/mysqld start ##Start mysql

22、/etc/init.d/mysqld status ##View mysql status

23、bin/mysql -u root –p ##Log in mysql

24. Enter the temporary password ##The temporary password generated by mysql, such as: jgghKqQhZ8*e

25. set password=password('A123456'); ##Change password

26. grant all privileges on *.* to root@'%' identified by 'A123456';

##27. flush privileges;

##28. use mysql;

##29. select host,user from user;

##30. Remotely connect to the database, or restart.

The above is the detailed content of Detailed introduction to the entire process and precautions of installing MySql5.7.17 under the latest Linux system. For more information, please follow other related articles on the PHP Chinese website!