Centos 7 install mysql error hy0007/4/2023 ![]() mysql> SET GLOBAL validatepasswordpolicyLOW OR mysql> SET GLOBAL validatepasswordpolicy0 You can thereafter confirm the password validation policy level. If you have any questions, please leave me a message and Xiaobian will reply you in time. To resolve the MySQL ERROR 1819 (HY000) error, set a lower password validation policy as shown. The above is a tutorial of offline installation of MySQL for centos7 introduced by Xiaobian. MySQL - uroot - P # enter new password to login Service mysqld start # start the MySQL service # Disabling symbolic-links is recommended to prevent assorted security risks Vim /etc/ my.cnf #Modify configuration file Service mysqld stop # stop the MySQL service and restore the MySQL configuration Query OK, 0 rows affected, 1 warning (0.00 sec) MySQL > flush privileges # update permissions Mysql> set password for = password('123456') ĮRROR 1290 (HY000): The MySQL server is running with the -skip-grant-tables option so it cannot execute this statement
0 Comments
Leave a Reply. |