Version Description: centos7, mysql5.7, not centos7, some commands may not be compatible
Install MySQL server
# Download and install mysql yum. wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10.noarch.rpm # Install MySQL server yum -y install mysql-community-server
Some configurations of mysql initialization installation
# Start MySQL server systemctl start mysqld.service # Check whether the startup is successful, i.e. whether there is 3306 port. netstat -tnlp | grep 3306 # Query the root password and log in to mysql grep "password" /var/log/mysqld.log mysql -uroot -p # The first operation requires resetting the password, which must be composed of case special characters mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password'; # Authorized remote access% means all hosts can access mysql> grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option; # Refresh permission information mysql> flush privileges;
Modify character set
vi /etc/my.cnf [client] default-character-set=utf8 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci # Restart mysql systemctl restart mysqld.service # Check whether the configuration is successful mysql> status; Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8
Configuration can use weak password
After mysql is upgraded to version 5.7, the password is strengthened.
- Modify the password field in mysql.user to authentication [string]
- Add password verification plug-in
# View current password rules mysql> show variables like 'validate_password%'; +--------------------------------------+--------+ | Variable_name | Value | +--------------------------------------+--------+ | validate_password_check_user_name | OFF | | validate_password_dictionary_file | | | validate_password_length | 8 | Minimum password length | validate_password_mixed_case_count | 1 | Number of mixed uppercase and lowercase passwords | validate_password_number_count | 1 | Number of password numbers | validate_password_policy | MEDIUM | Password check level | validate_password_special_char_count | 1 | Number of password special characters +--------------------------------------+--------+
There are two solutions, one is to change the authentication rules, the other is to directly uninstall the password authentication plug-in.
Uninstall password authentication plug-in
mysql> uninstall plugin validate_password;
Modify validation rules
mysql> set global validate_password_policy=0; mysql> set global validate_password_mixed_case_count=0; mysql> set global validate_password_number_count=3; mysql> set global validate_password_special_char_count=0; mysql> set global validate_password_length=3;
Modify mysql password
If you have logged in to mysql, you can change the password directly
# Method 1. Set the password of the current login user mysql> set password=password('newpassword'); # Method 2. Directly change the user table mysql> use mysql; mysql> update user set authentication_string=password('123abc') where user='root'; # Method 3. Change password mysql> alter user root@'localhost' identified by '123456';
If you do not log in to mysql, you can skip the permission check to change the password.
vi /etc/my.cnf [mysqld] skip-grant-tables # Then restart mysql. You don't need the root password to log in to MySQL. Then you can play whatever you like.
Generally speaking, the next step is over, but I may have downloaded a test version at that time. There is a 1045 error. It is estimated that the current version is not available. The solution is to skip the permission check and reset the password. Here is an operation method for novices.
1. Stop mysql service first, and then cmd to mysql bin directory 2. mysqld -nt --skip-grant-tables 3. Start mysql to execute mysqladmin - U root flush privileges password < password >
A little promotion
It's not easy to create. I hope to support my open source software and my gadgets. Welcome to gitee to click stars, fork, and mention bug s.
Excel general import and export, support excel formula Blog address: https://blog.csdn.net/sanri1993/article/details/100601578 gitee: https://gitee.com/sanri/sanri-excel-poi
Use template code, generate code from database, and some small tools often used in projects Blog address: https://blog.csdn.net/sanri1993/article/details/98664034 gitee: https://gitee.com/sanri/sanri-tools-maven