Basic question...after installing mysql, I get access denied

[dcnguyen]

So I installed MySQL for Mac OS X 10.4.8 Client, using the latest installer. No problems doing so...however, when trying to login using mysql -u root...it says:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I'm new at MySQL, what commands am I supposed to run to set everything up. I've googled this error message and looked through other forums, but haven't found the (what I think) is the basic answer to this.

 

[mbrooks]

What happens when you just type

% mysql

M. Brooks

http://mbrooks.info

 

[dcnguyen]

It starts the MySQL monitor...however, I can't do anything like create databases:

mysql> create database dt
-> ;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'dt'

 

[dcnguyen]

I may have had a problem installing mysql earlier and so I recently reinstalled it, so maybe that's causing a problem? If so, what's the best way to completely uninstall mysql from mac os x? I was using the 5.0 package for Mac OS X intel:

http://mysql.he.net/Downloads/MySQL-5.0/mysql-standard-5.0.27-osx10.4-i686.dmg