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

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