Tutorial on installing and configuring MySql5.7 in Alibaba Cloud ECS centos6.8

The default MySQL version under the Alibaba Cloud yum command is 5.17****. Before installing MySQL 5.7, uninstall the previous version, including clearing the previous database - check /var/lib/mysql, and clear the historical files after backing them up.

1. Find the appropriate rpm download from https://dev.mysql.com/downloads/repo/yum/

2. After the download is complete, execute the command " yum localinstall mysql-community-release-el6-5.noarch.rpm ";

3. After completion, execute the command " yum install mysql-community-server " and wait for the installation to complete;

4. Run the command " service mysqld start ". If the startup fails, it may be caused by the existence of a historical version. Find /var/lib/mysql and clear the data in it.

5. After startup, the database will be initialized and a temporary root login password will be generated (the previous versions all had empty passwords). grep "temporary password" /var/log/mysqld.log”

You can then use the temporary password to log in to the system mysql -u root -p dZut3)i&nUi< ;

6. After logging in, the permissions are limited. You must change the password first, otherwise the following prompt will appear

By default, MySQL 5.7 has requirements for password length and complexity. If it is only used for testing and development, it is completely unnecessary to set a password of '123456'. You can use the command " SHOW GLOBAL VARIABLES LIKE 'validate% ';" to view the current password setting related parameters. If it is simply used, you can add " validate_password=off " in the configuration file /etc/my.cnf to turn off " validate_password ".

7. Restart " service mysqld restart " and log in using password 123456.

The above is the tutorial on how to install and configure MySql5.7 under Alibaba Cloud ECS centos6.8. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!