Topic: Hosed my MYSQL

[Dan Williams]

Hi, I messed up and am not 100% clear on how to retrace my steps:
I was using PHPMyadmin, and selected "Users". Under "Grants" I selected the wrong table, and clicked "revoke priveleges" (I know, but it happened)
So I did a restore from tape and that did not solve the problem (but did show my tape backup works!)

Anyway from the command line I tried this:
Any suggestions on how to fix?

[root@nebula7653 root]# mysql --user=root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'columns_priv'
Didn't find any fields in table 'db'
Didn't find any fields in table 'func'
Didn't find any fields in table 'host'
Didn't find any fields in table 'tables_priv'
Didn't find any fields in table 'user'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 119 to server version: 3.23.41

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

mysql>

[Prezes]

did you try adding you priveleges again???

[Dan Williams]

Hi,
I do not know how to do that, and did not want to cause further problems.
Basically I was hoping to find an solution that someone else has tried, with instructions.
Thanks,
Dan