mysql cannot create a user
 

i've been around irc two times for this and read the tutorial on mysql.com but i still can't find a solution to this...

i got everything working right on my slackware 9 box with apache, php and sql so i installed phpmyadmin and i accidently deleted all the users in phpmyadmin and now i can't access anything in mysql so i tried using the stuff in the mysql.com tutorial to create a user and i get this error:
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
when trying to do this:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost
-> IDENTIFIED BY 'the_password_i_want_to_set' WITH GRANT OPTION;
i'm begging people to help me now because i'm on the edge here and i've been trying to solve this for 3 days with no answers from either #mysql on freenode or #linuxhelp on undernet

try this ;)

1)create the db first (mybuddy)

2)Enter the command exactly as show below this will create a user called buddy_user with password mypass on the mybuddy database.

GRANT ALL PRIVILEGES ON mybuddy TO buddy_user@localhost IDENTIFIED BY 'mypass' with GRANT OPTION;




hope it helps