OT: getting started with mysql

[Duncan Lithgow]

I've got it installed and running but I can't seem to get it to do 
anything. I can't get access mysql as root to make some users and such. 
I just want to make a user with 'create insert edit' etc rights for 
testing on my local machine. Here's what I've got so far...

error: 'Access denied for user: 'root at localhost' (Using password: NO)'
[root at 3e6b36fa ~]# service mysqld start
Starting MySQL:                                            [  OK  ]
[root at 3e6b36fa ~]# mysql
ERROR 1045: Access denied for user: 'root at localhost' (Using password: NO)

So, what am I doing wrong?

Duncan