1 /etc/init.d/mysql stop
2 3 4 vim /etc/my.cnf
ADD
 skip-grant-tables 
5 mysql -u root
6 use mysql;
7 update user set password=PASSWORD("mynewpassword") where User='root';
8 update user set plugin="mysql_native_password";

Similar Posts:

• Solve the problem of unknown column ‘password’ in ‘field list’ in MySQL
• [Solved] MYSQL Install and Login Error: Access denied for user ‘ODBC’@’localhost’ (using password: NO)
• [Solved] Access denied for user ‘ODBC’@’localhost’ (using password: NO)
• [Solved] MYSQL Error: this authentication plugin is not supported
• Linux Login MYSQL Error: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
• MYSQL Login Error: mysqladmin: connect to server at ‘localhost’ failed
• MySQLAccess denied for user ‘root’@’localhost’ [How to Solve]
• mysql ERROR 1044 (42000): Access denied for user ‘
• [Solved] MYSQL ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mys…
• Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449