MySQL password problem

[lezniak]

I just installed MySQL on my mac (OS X) and I'm trying to create a db with the following line command (and I get the following output too):

[Jeremys-Computer:~] lezniak% mysql -p forum
Enter password:
ERROR 1045: Access denied for user: 'lezniak@localhost' (Using password: YES)
[Jeremys-Computer:~] lezniak%

Which says that my password may be incorrect or what?


right after I installed MySQL, I put in:
/usr/local/mysql/bin/mysqladmin -u root password <MyPassword>

where <MyPassword> isn't what i put in, i put in my password.
does anyone know what perhaps what the problem is?

Thanks in advance

 

[sleipnir214]

You're not logged in as root. If you don't hand mysql a username when invoking the app, the client app assumes that you mean to use the name of the user as which you are logged in. In this case, it's using "lezniak" as the MySQL username.

If you issue:
mysql [red]-u root[/red] -p forum

And then give it a password when it asks for one, it will know you mean to use the MySQL username "root".

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Sensibilium]

It's also possible that the user account has become corrupt (happens to me a lot), I find that recreating the user usually fixes the problem.

Ahdkaw

http://www.sensibilium.com/