Need solution for error 1045

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
freshclearh2o
Forum Newbie
Posts: 9
Joined: Thu Aug 21, 2008 5:18 pm

Need solution for error 1045

Post by freshclearh2o »

Hello I'm a noob. I have scoured the internet for a solution for error '#1045 - Access denied for user 'root'@'localhost' (using password: NO)'; and can't seem to find a working solution in getting phpmyadmin to work w/ my windows vista notebook.
Please help or point to where I may request for a resolution. :dubious:

I downloaded wampServer 2.0c
copied & set config.inc.php file
as test set localhost, root, root for dbhost, dbuser, dbpass... every works gr8t (mysql accessible via mysql monitor, or via php) but phpmyadmin gives error above... ?
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Need solution for error 1045

Post by onion2k »

The root user that's been set up in MySQL has a password, but you're not defining it in your config file. You need to.
freshclearh2o
Forum Newbie
Posts: 9
Joined: Thu Aug 21, 2008 5:18 pm

Re: Need solution for error 1045

Post by freshclearh2o »

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';

thx for quick response. above represents a portion of my config.inc file saved in the www folder w/ the index.php...
i've chg password here, set it in mysql via command $ mysqladmin -u root password NEWPASSWORD...
$ mysqladmin -u root -p oldpassword newpass...
stopped wamp, restarted... put offline.. put online... result broken... :banghead:

i used the same procedure on my other notebook pc w/ win2k and all is good... mysql/5.0.51b /Apache/2.2.8 (Win32) PHP/5.2.6

phpmyadmin no work.. it broken.. any suggestions on assistance is appreciated
freshclearh2o
Forum Newbie
Posts: 9
Joined: Thu Aug 21, 2008 5:18 pm

Re: Need solution for error 1045

Post by freshclearh2o »

i figured it out... or maybe just solved my resolution in a different way...

--> issue phpmyadmin tool installation would not work even after changing the config.inc.php file...

--> resolution: downloaded a different installer. Apparently I'm a goof and tried to use Wamp on a Vista OS. Wamp is listed to only work w/ 2K, XP. I downloaded XAMPP which is compatible w/ 2K, XP and sometimes 'Vista'. All is well except the installation of MySQL with XAMPP does not include the MySQL console. But it does have phpmyadmin and I can run the queries through this tool.

If anyone can suggest a more viable free version of an all inclusive developer installation (PHP, MySQL, Apache, etc...) please reply.

thx for reading... :mrgreen:
Post Reply