16/03/2019

Reset Password in MySQL | How to fix Access denied for user ‘root’@’localhost’

By Technical Digit

Set/Reset Password in MySQL

use mysql;
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpassword’);
OR
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘newpassword’;
OR
UPDATE mysql.user SET authentication_string = PASSWORD(‘newpassword’), password_expired = ‘N’ WHERE User = ‘koha_library’ AND Host = ‘localhost’;
flush privileges;

Mysql(Ubuntu): How to fix Access denied for user ‘root’@’localhost’

sudo mysql -u root

use mysql;

update user set plugin=’mysql_native_password’ where User=’root’;

flush privileges;

Koha auto_increment bug fix

Total Views: 1232