MySQL 'Enter password:' issue sad smiley
Posted by: invision2 (---.artistadesign.co.uk)
Date: February 02, 2009 02:22PM

Just installed WAMPServer.

PHP is running fine, but when I try to load the MySQL console I am greeted with 'Enter password:' - what's the password I've to use for this? I try 'root' and get a 1045 error, then the console closes - nice!


Thanks for any ideas,



Edited 1 time(s). Last edit at 02/02/2009 02:30PM by invision2.

Options: ReplyQuote
Re: MySQL 'Enter password:' issue sad smiley
Posted by: yfastud (Moderator)
Date: February 02, 2009 03:22PM

default is blank, but you can follow this to setup password
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: MySQL 'Enter password:' issue sad smiley
Posted by: invision2 (---.artistadesign.co.uk)
Date: February 02, 2009 04:01PM

Thanks for the speedy reply.

I get this when I first try to access phpmyadmin as per your tutorial:


Forbidden

You don't have permission to access /phpmyadmin/ on this server.

And when I look in my 'www' folder, there is no phpmyadmin. Did I mess up?

Options: ReplyQuote
Re: MySQL 'Enter password:' issue sad smiley
Posted by: invision2 (---.artistadesign.co.uk)
Date: February 02, 2009 05:52PM

OK, back again. Needed coffee smiling smiley

phpmyadmin is now working.

But how do I change my username/pass in my mysql?

Options: ReplyQuote
Re: MySQL 'Enter password:' issue sad smiley
Posted by: jesus (---.102-97.tampabay.res.rr.com)
Date: February 03, 2009 07:09PM

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
what is this
how do i make go way

Options: ReplyQuote
Re: MySQL 'Enter password:' issue sad smiley
Posted by: yfastud (Moderator)
Date: February 03, 2009 08:12PM


Options: ReplyQuote
Re: MySQL 'Enter password:' issue sad smiley
Posted by: ghz2541 (---.nycmny.east.verizon.net)
Date: July 17, 2013 12:07AM

I had the same problem. The Wamp Server tries to login as root@localhost, however the real username is actually admin for the version of Wamp server I have and also the phpmyadmin. So change your environmental variable path to include sql.exe and type sql.exe -u admin to login

Options: ReplyQuote


Sorry, only registered users may post in this forum.