introduction screenshots faq forum blog modules components download
Please use the search function and/or read the FAQ first.

Go to Topic: PreviousNext
Go to: Message ListNew TopicSearchLog InPrint View

MySQL error 1045 <28000> : Access denied for user 'root'@'localhost' <using password YES>



Posted by: ahoupper
November 16, 2009 06:24AM
I just downloaded EasyPHP and it is running. I am on Windows XP. Have no personal firewall but am using a work laptop which I'm sure has various security measures. I did disable IIS as I had the inet error regarding port 80 so that is worked out. Is there a default password? Many thanks. Apologies for not being able to find quite the right answer on other postings.
Options: ReplyQuote
Posted by: Amour
November 16, 2009 08:25AM
Did you tried no password or "mysql" for root password ?
Options: ReplyQuote
Posted by: ahoupper
November 16, 2009 04:48PM
I just tried and same message, I changed the password in phpmyadmin/config.inc.php, based on what I'd seen in another post. I then stopped and started Apache/MySQL in case that was necessary.
I am getting this message when I try out a CMD line from an O'Reilly book. I changed my directory to C and then the full line is as follows: C:\"Program Files\EasyPHP5.3.0\mysql\bin\mysql" -u root.
This is supposed to show that things are working properly. Any other thoughts? I appreciate it.
Options: ReplyQuote
Posted by: Amour
November 16, 2009 07:18PM
If there is a root password, you must give it on command line : mysql -u root -p password
Options: ReplyQuote
Posted by: ahoupper
November 16, 2009 07:45PM
I added -p password after -u root, and I got the response to Enter password:
I tried putting in mysql, root, and password. Should it be the password listed in phpmyadmin/config.inc.php? Do I need to put an operator before or after the password? Keep getting the same 1045 error message.
Any ideas appreciated!
Options: ReplyQuote
Posted by: Amour
November 16, 2009 10:36PM
Yes, it must be the same password as phpMyAdmin ;)
Options: ReplyQuote
Posted by: ahoupper
November 16, 2009 11:22PM
I seem to be stuck then, because the password in phpmyadmin\config.inc.php is sql, and I tried putting SQL where the password is supposed to go.
Options: ReplyQuote
Posted by: ahoupper
November 17, 2009 05:53PM
I just needed to hit Enter when the password prompt appeared, without entering anything. Thanks so much Amour for the help - nice to know someone is around who might assist.
Options: ReplyQuote
Posted by: patrickoq
January 15, 2011 09:08PM
Thanks ahoupper for help in resolving the same problem :)
Options: ReplyQuote
Posted by: gannet
January 07, 2010 10:22AM
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: Y
ES)
Options: ReplyQuote


Go to: Message ListSearchLog In
Your Name: 
Your Email: 
Subject: 
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.