Advertisement

07.18.2008 at 05:17PM PDT, ID: 23578547
[x]
Attachment Details

PHPMyAdmin Error #1045 - Access denied for user 'root'@'localhost' (using password: YES)

Asked by level9wizard in PHP Scripting Language, Web Languages/Standards, MySQL Server

I just installed mysql 5.0 and newest phpmyadmin and get:
PHPMyAdmin #1045 - Access denied for user 'root'@'localhost' (using password: YES)

From a command line i did mysql -u root -p and was prompted for password, i entered it and it accepted. so the root pass is fine..

in phpmyadmin i'm using
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['username'] = 'root';
$cfg['Servers'][$i]['password'] = 'mypass';

but phpmyadmin is giving the 1045 error.

I tried doing this:

mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
    ->                   WHERE User='root';
mysql> FLUSH PRIVILEGES;

and although it gave all 'OK' messages, i'm still not getting in thru phpmyadminStart Free Trial
[+][-]07.19.2008 at 12:31AM PDT, ID: 22041692

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PHP Scripting Language, Web Languages/Standards, MySQL Server
Sign Up Now!
Solution Provided By: cedlinx
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906