command line to mysql?
Posted by: quadmore (---.6-37-24.mc.videotron.ca)
Date: August 05, 2006 02:21PM

Hello,

Just installed the latest WAMP. I want to manually set up databases, change root password, etc. I'm used to doing command lines to mysql, but am getting:

E:\wamp\mysql\bin>mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N
O)

E:\wamp\mysql\bin>mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N
O)

Tried changing it in phpMyAdmin, now am getting: "phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection."

TIA

Options: ReplyQuote
Re: command line to mysql?
Posted by: CyberSpatium (67.170.181.---)
Date: August 05, 2006 02:41PM

follow the second post here
[forum.wampserver.com]

Options: ReplyQuote
Re: command line to mysql?
Posted by: quadmore (---.6-37-24.mc.videotron.ca)
Date: August 06, 2006 12:47AM

Thanks,

That fixed the problem completely. Thanks for the quick reply.

It's worth mentioning that the MySQL 5 command line is slightly different than previous versions:

mysql -u username -p databasename

and you are prompted seperately for a hidden password

Cheers!

Options: ReplyQuote
Re: command line to mysql?
Posted by: CyberSpatium (67.170.181.---)
Date: August 06, 2006 01:25AM

no problem, glad it worked.

Options: ReplyQuote


Sorry, only registered users may post in this forum.