Problem solved: /usr/local/bin/mysql_fix_privilege_tables2 Drew Jenkins <[EMAIL PROTECTED]> wrote: Hi; I rebuilt mysql and injected the database which had user "mysqluser" and a root user. Both got wiped out. It looks like the data is intact other than that. Look at this:
mysql> CREATE USER dev IDENTIFIED BY 'pass'; Query OK, 0 rows affected (0.04 sec) mysql> CREATE USER mysqluser IDENTIFIED BY 'pass'; ERROR 1396 (HY000): Operation CREATE USER failed for 'mysqluser'@'%' mysql> mysql> grant all on mrtablecloth.* to dev identified by 'pass'; Query OK, 0 rows affected (0.00 sec) mysql> Bye server312# mysql -udev -ppass ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password: YES) 2 mysql> use authdaemon; Database changed mysql> show tables; Empty set (0.02 sec) Is authdaemon the database that has the grant tables? What gives? How do I add users that I can use? TIA, Drew --------------------------------- The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. --------------------------------- Don't get soaked. Take a quick peek at the forecast with theYahoo! Search weather shortcut.
