phpMyAdmin MySQL Access denied for user ' root ' @ ' localhost ' problem solving

Source: Internet
Author: User
Tags mysql in phpmyadmin

centos6.4 32-bit VPS installed LNMP, phpMyAdmin Unable to connect to the MySQL server, SSH command line after the Mysql-uroot-p command always appear to deny connection. The PHP program also rejects the connection. Tried to modify the phpMyAdmin config.inc.php file, tried to modify the my.cnf file, tried to modify the php.ini file, No. Even lnmp.org officials can not find a solution.

I found a lot of places on the internet and my head blew up. Finally found a solution.

Workaround Address: http://bbs.vpser.net/thread-1168-1-1.html

The solution is the first one. As follows: Also do not know why, anyway to get a bit better.

My system is ubuntu6.06, and recently installed MySQL in the MySQL tool, there are always error prompts:
# mysql-uroot-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)

Use the Web-based method to modify the root user's password:
# mysqladmin-uroot-p password ' newpassword '
Enter Password:
Mysqladmin:connect to server at ' localhost ' failed
Error: ' Access denied for user ' root ' @ ' localhost ' (using Password:yes) '

Now I finally found the solution, as follows (please test method Three first, thank you!) ):
Method One:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit

#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>

Mysql>

The above newpassword to be replaced by their own password.

phpMyAdmin MySQL Access denied for user ' root ' @ ' localhost ' problem solving

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.