Cloud server Centos7 builds MySQL database (learning record)

Nonsense at the beginning:

Before my student ID card expired, I quickly bought Tencent Cloud for three years. Why should I use Tencent’s products? Isn’t it because other people’s mini programs support it? Without further ado, let’s get to the point.

1. Download the yum source of MySQL

Centos7 does not have the yum source of MySQL. We download different versions of the source to install different versions of MySQL. You can choose to download it yourself. , or you can download it according to the command selected below.

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

2. Install the downloaded rpm file

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

3. Install Mysql with yum

yum install mysql-server

4 , try to log in to MySQL

mysql -uroot -proot

This place may report an error:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

This is a /var/lib/mysql permissions problem, modify the MySQL permissions to the current user

sudo chown -R xxx:xxx /var/lib/mysql

xxx is the current user name and group

Restart the MySQL service

service mysqld restart

5. Failed to log in to obtain the initial password

cat /var/log/mysqld.log | grep password

Among them A temporary password is generated for root@localhost: * localhost: What follows is the initial password.

mysql -uroot -p

Enter the password to log in

6. After successful login, change the initial password first

set global validate_password_policy=0;
set global validate_password_length=4;
alter user 'root'@'localhost' identified by 'root’;

7. In this way, the MySQL installation is complete!

Recommended: "mysql video tutorial"

The above is the detailed content of Cloud server Centos7 builds MySQL database (learning record). For more information, please follow other related articles on the PHP Chinese website!