ansaurus

Question

Answer 1

+3 A:

use the -p option. (Tells mysql that you want to provide a password when logging in.)

$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
$ mysql -u root -p
Enter password:

If that doesn't work, try B.5.4.1. How to Reset the Root Password from the MySQL Reference Manual.

aioobe 2010-05-26 12:11:25

Thanks mate, I'm using:mysql -u root -pNo password set - just pressing enter but still not working.

WANNABE 2010-05-26 12:16:33

Try http://www.netadmintools.com/art90.html (including the section starting with "To reset a root password that you forgot") or http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

aioobe 2010-05-26 12:24:53

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html worked perfectly for me.Thanks alot mate.

WANNABE 2010-05-26 12:56:27

aioobe, incorporate the comment into your answer so I can upvote it :)

chrisbunney 2010-05-26 18:24:49

@chrisbunney, sure, that's actually a good idea. I will remember it for future comments too.

aioobe 2010-05-27 05:42:28

Answer 2

+1 A:

$ mysql -u root -p{you_password} {db_name}

just remove '{}' from the string.

mosg 2010-05-26 12:14:32

Not recommended as the password will be stored in clear text in the bash-history file.

aioobe 2010-05-26 12:22:07

@aioobe Yes, but on testing/debug period it's the easiest one... In my opinion, the best way, is to create my.cnf in the users dir, with password field inside... But, it's not a noob way as you can see :)

mosg 2010-05-26 12:26:13

ansaurus

tags:

views:

answers:

Beginner MYSQL Error - Access Denied

related questions