From the linux shell I can use the following command #mysql --u root -p ...it then prompts for thr root password..I enter the password and I am successfully into mysql..
However when I try to use phpMyAdmin with the same root password I receive this error....
1045 - Access denied for user 'root'@'localhost' (using password: NO).. SAme also now I cannot access my mambo driven website,,,
ANy help...?
suse linux 10.1
mysql 5.0.18
php 5.1.2
Mysql password problems
Moderator: General Moderators
- dibyendrah
- Forum Contributor
- Posts: 491
- Joined: Wed Oct 19, 2005 5:14 am
- Location: Nepal
- Contact:
Code: Select all
Access denied for user 'root'@'localhost' (using password: NOCode: Select all
$cfg['Servers'][$i]['password'] = 'YOUR_PASSWORD_HERE';Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'http';The complete configuration will be :
Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed