Can't edit mail users?

SQL select user.user,user.password from user,db where db.user = user.user and (db.db = ‘voodootechnologies’ or db.db = ‘voodootechnologies’) failed : Table ‘mysql.user’ doesn’t exist

That error seems a bit weird to me…digging into MySQL shows that the database certainly doesn’t exist.

The only time I’ve tampered with the database was to merely change the root password (it was blank, which concerned me quite a bit!). Would this have swiped the user table?

mysql> show databases;
| Database |
| information_schema |
| mysql |
| voodooed |
| voodooland |
| voodootechnologies |
5 rows in set (0.00 sec)

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
| Tables_in_mysql |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| procs_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
12 rows in set (0.00 sec)

Might add - existing user emails still work.

EDIT: Scratch that - they’re dead now. Funny that, they were working a few hours ago. Connection was ‘refused’ says email server.<br><br>Post edited by: excalibur, at: 2007/12/11 14:26

Ok - worked out the cause and have reconstructed all default tables. Turns out a SQL script I’d run had inadvertedly deleted several default tables…and have executed ‘mysql_install_db’ to rebuild them.

Now…how to restore everything else…

I keep troubleshooting things myself. LOL.

I think this thread can be considered resolved.

I keep troubleshooting things myself.

That’s good news. Because I have no idea what’s going on in this thread. :wink: