"Access Denied" to MySql: #1045 Error
-
Well, I got it again, the dreaded “#1045 – Access denied for user ‘root’@’localhost’ (using password: YES).”
I’ve been reading posts for hours, tried everything I can think of short of using yfastud’s “reset” program or reinstalling WAMP, and I still can’t access my db through phpMyAdmin.
—————–My System:
Windows 7
WAMP 2.1
Wordpress 3.1.3
——————
History:
Site on localhost WAMP server working fine, no problems.
I create a NEW second database through phpMyAdmin for a second wordpress installation in WAMP root to play around with it.
I assign a password to the second database and make changes to the new config.php file.
Had problems with the new installation—I forget what.
Bailed out.
Deleted the second wordpress folder in WAMP root.
Deleted the second database in phyMyAdmin.
Made sure everything concerning the second installation that I could find was gone.
Then I tried to access the original database through phpMyAdmin.=============================================
I can’t get in: Error #1045 as stated above.
=============================================Looked at everything covered in the mounds of posts I viewed on the subject.
Don’t want to reinstall or “reset” WAMP unless absolutely necessary.
Would like to know how to track down this problem manually and fix it.So, password stuff and placement looks good.
Config.php looks good:
——————————
$cfg[‘Servers’][$i][‘verbose’] = ‘localhost’;
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = ‘my database password is here’;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = false; (tried true and false here)
——————————–wp-config.php looks good:
——————————–
define(‘DB_NAME’, ‘my database name is here’);/** MySQL database username */
define(‘DB_USER’, ‘root’);/** MySQL database password */
define(‘DB_PASSWORD’, ‘my database passsword is here’);/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);
——————————–Checked db.myd; user.myd; host.myd files.
Cleared cache.
Other stuff I can’t remember.From what I’ve read, this is probably a password setting or some other simple related setting problem that I can’t find.
Rather than use a “reset” or “reinstall” solution, I would much prefer to track down the setting and fix it myself so I would better understand how this particular mysql procedure—accessing mysql database with a password—works.
I would really like to manually “track down this demon” and slay it once and for all. It’s almost got to be as simple as a setting somewhere in a file.
Yfastud, or any of you brilliant gurus out there, if you’d be so kind as to help me out here, I’d certainly appreciate it.
Thanks
- The topic ‘"Access Denied" to MySql: #1045 Error’ is closed to new replies.