phpMyAdmin Login Error: Mysqli_real_connect (): (28000/1045): Access denied for user ' root ' @ ' localhost ' (using Password:yes)
Environment: CentOS 7.3 + MariaDB 5.5
I am not determined to be a MySQL DBA, and I know less about MySQL and mariadb, and I don't find the real reason for this problem. Read some technical articles on the Internet, it claims to have found the real reason for this problem is not agree, simply follow the following methods to successfully solve the problem, the right to refer to it. Friends who aspire to be MySQL DBAs may wish to check the official code to find the real reason.
Workaround:
# Systemctl Stop Mariadb.service
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-uroot MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# Systemctl Start Mariadb.service
# mysql-uroot-p
Enter Password: <enter newpassword>
MySQL or MariaDB Error resolution code 1045