Mysql new version (8+) login permission problem, solution

ERROR 1045 (28000): Access denied for user ‘wendongliang’@’localhost’ (using password: NO)

Solution:

// Enter the configuration filecd /usr/local/etc/my.cnf // vi /mysqld /mysqld Skip-grant-tables // Set the null password to nysQL > update userset authentication_string=' ' where user='root'; Mysql -h localhost -u root -p mysql -h localhost -u root -p mysql> alter user'root'@'localhost' IDENTIFIED BY '123456';Copy the code