Access denied in MySQL.

Possibly a grant table error, help.

[GoYo]

Hi. I'm trying to get MySQL (4.0.20-standard for Mac OS X, if you want to know) to create a database for my IPB.
Somehow, I'm not able to do that, or any other activites. Even when using the root.
Example:

GYs-Server:/usr/local/mysql goyo$ mysqladmin -u root create ipb
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

...help, please.
I tried to put a password to the root account for MySQL, but I think it got messed up. (Tried this: usr/local/mysql/bin/mysqladmin -u root password <new root password>). I also tried to uninstall MySQL (using the script found here: [entropy.ch...]
...Any suggestions?

[blakmonk]

Well,

try stopping mysqld (killall mysqld) and starting it with the --skip-grant-tables option.

open another terminal window and go into mysql.
do the wollowing:

update mysql.user ser password=password('****') where user='root';

Make sure your password contains normal non accentuated or special characters... just in case you are using an unicode keyboard layout.

then close the mysqld --skip-grant-tables that you have running. and restart mysql normaly.

It should work for you.

BlakMonk

[GoYo]

Uhh... I think my mysql is screwed even more...

I killed mysqld, and now, I can't get back in.
I type in mysqld --skip-grant-tables, and I get:

040729 1:46:50 Warning: Can't create test file /usr/local/mysql-standard-4.0.20-apple-darwin7.3.0-powerpc/data/GYs-Server.lower-test
./mysqld: Can't change dir to '/usr/local/mysql-standard-4.0.20-apple-darwin7.3.0-powerpc/data/' (Errcode: 13)
040729 1:46:50 Aborting

040729 1:46:50 ./mysqld: Shutdown Complete

If I try mysql start, I get:

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Yup. It's official. MySQL hates me with a raging passion.