[xspriter]

I already had MySQL installed on my system (10.0.3 client) and went to try to actually use it today.

Well I can't log into it using the 'mysql' command, likely because I changed passwords and can no longer remember them...

I reinstalled MySQL using the package and instructions at http://www.entropy.ch/software/macosx/ and everything went fine until i ran 'mysql test' at which point I get a permission denied error:

ERROR 1045: Access denied for user: 'jstys@localhost' (Using password: NO)

I also can't get in using 'mysql -u root' which should work fine because by default the root user has no password...

Is there password file that I can delete to fix this, or is there a way to completely unistall everything so that a fresh install will be back to normal?

Thanks for any help, I'm fairly new to this.

[xspriter]

If anyone is interested, I fixed my own problem by deleting the following directory and then reinstalling the mysql package:

/usr/local/var/mysql

now everything works as expected.

[MadBrowser]

You can also start mySQL without the grant tables and then change your password manually. The procedure is detailed in the mySQL manual.