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]['usern
ame'] = 'root';
$cfg['Servers'][$i]['passw
ord'] = '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 phpmyadmin
Start Free Trial