Oops! deleted user table from mysql

[Rickead2000]

Hi,

I have a HUGE problem with mysql.

Basically, I have deleted the user table from the mysql database.

I have reinstalled mysql several times using rpm, but it doesnt recreate it.

How can i get a fresh copy of the users table without having to reinstalll linux!!

Cheers

[Rickead2000]

fixed.

just ran mysql_install_db.

However, the initial problem that made me mess up my user table is still present.

I type...

mysql> grant select, update, delete, insert
-> on testdb.*
-> to testuser identified by 'mypass';

This instead creates a user call testuser but with no priviledges, and does not require a password to logon.

In fact, if i try to run mysql -u testuser -p

and type in the password, it actually wont let me in!!!!

I suppose I could manually add the user privs to the user table, but why isnt it working??