Problems w/ Grant Tables
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.
Re: Problems w/ Grant Tables
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.