Page 1 of 1

Need solution for error 1045

Posted: Fri Sep 05, 2008 3:22 am
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... ?

Re: Need solution for error 1045

Posted: Fri Sep 05, 2008 4:38 am
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.

Re: Need solution for error 1045

Posted: Fri Sep 05, 2008 11:20 am
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

Re: Need solution for error 1045

Posted: Mon Sep 08, 2008 4:36 am
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: