setting up root account

[Noah Garrett Wallach]

Okay it appears my mysql database is simply screwed up.

I am attempting to rebuild the root account and privileges and now I
cant do anything.  How do I rebuild the root account with proper
privileges and the grant option.


I am thinking:

    mysql -u root
      use mysql;
      GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
      FLUSH PRIVILEGES;
      GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
      FLUSH PRIVILEGES;
      GRANT ALL PRIVILEGES ON *.* TO 'root'@'mypc' WITH GRANT OPTION;
      FLUSH PRIVILEGES;
      quit;


But here is what happens:
neckbridge 23:35:08 ~ $ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.30-Yahoo-SMP-log  (RHEL 32-bit)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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