Mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

1

need help, please…

username & password are correct

2

mysql -e "ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘$mpass’;

Run it ounce…

Where $mpass is the root password

3

still the same as this

4

Hello @ngadimin,

Create a new user with all privileges and login in phpmyadmin as that user (in below example the new user is newroot and the password is some_password):

mysql -uroot
mysql> CREATE USER 'newroot'@'localhost' IDENTIFIED BY 'some_password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'newroot'@'localhost' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
1 Like
5

thank you very much for your help, it is very useful

1 Like