Installing MySQL database on Linux server (detailed tutorial)

I don't say much nonsense , Go straight to the tutorial .

1. First, execute the following command , to update YUM Source .

rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

2. Execute the following command , install MySQL.

yum -y install mysql-community-server --nogpgcheck

3. Execute the following command , see MySQL Version number .

mysql -V

4. The results are as follows , Indicates that you have successfully installed MySQL.

5. Execute the following command , start-up MySQL service .

systemctl start mysqld

6. Execute the following command , Set up MySQL The service starts automatically .

systemctl enable mysqld

7. To configure MySQL Of root User password .

Execute the following command , see /var/log/mysqld.log file , obtain root User's initial password .

grep 'temporary password' /var/log/mysqld.log

8. The return result is as follows , You can see root User's initial password .

9. Execute the following command , Use root User login database .

mysql -uroot -p

10. The return result is as follows , Input root User's initial password .（ The password entered will not be displayed ）

11. Execute the following command , modify MySQL Of root User's initial password .

set global validate_password_policy=0; # Change the password security policy to low （ Only verify password length , At least 8 position ）. ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678';

12. Execute the following command , grant root User remote management rights .

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

1. Input exit Exit database .

2. 

   Execute the following command , Use root User login database .

3. mysql -uroot -p12345678 

    

4. Come here mysql Installation of is complete , The default installation directory is /var/lib/mysql This directory

5. You can also use    find / -name mysql  Use this command to view mysql Installation directory

6. 

7. Refer to Alibaba cloud lab documentation ：MySQL Database rapid deployment practice - Yunqi Laboratory - Online experiments - Go to the cloud and practice - Alicloud developer community - Alibaba cloud's official experimental platform - Alibaba cloud