Access denied for user 'root'@'localhost'
Posted by: emad.suria (203.81.210.---)
Date: June 17, 2009 08:24AM

Hi there, I'm new to Open Source and wampserver.

I installed it successfully, entered phpmyadmin, no password asked.
I created a database and run the script to create the required schema.
from within that database I selected permissions tab and set the password for root.
After this when I I try to enter the phpmyadmin it gived the following error:
------------------------------------------------------------------
Error

MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
-------------------------------------------------------------------

I'm going nuts with this as whole phpmyadmin is inaccessible now.
My conversion to OS from MS technology is giving tough time just in the start. Plz ppl do something, don't let these setup issues scare newbies like me.

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost'
Posted by: showstopper (---.tstt.net.tt)
Date: June 17, 2009 08:37AM

no need to bash your head

Go to C:/wamp/apps/phpmyadmin3.1.3.1 now find the config.inc.php file find the line

$cfg['Servers'][$i]['auth_type'] = 'config';

and change it to

$cfg['Servers'][$i]['auth_type'] = 'cookie';

save the file now go to your the wamp icon
left click and navigate to php the php extensions look for the extension
php_mycrypt
wait for wamp to restart the go to phpmyadmin
enter your username and your password and thats its. Any problem you have add me to msn or yahoo
fortune.osei@hotmail.com or fortune.osei@yahoo.com

Fitcom - Technology and SEO with a side of awesome

Installing and Configuring a WAMP Server in Windows 7 & 8

Options: ReplyQuote
Re: Access denied for user 'root'@'localhost'
Posted by: yfastud (Moderator)
Date: June 17, 2009 02:13PM


Options: ReplyQuote


Sorry, only registered users may post in this forum.