Can't edit mail users?

5 posts / 0 new
Last post
#1 Tue, 12/11/2007 - 14:17
excalibur

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)

Tue, 12/11/2007 - 14:24
excalibur

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

Tue, 12/11/2007 - 15:22 (Reply to #2)
excalibur

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...

Tue, 12/11/2007 - 15:51 (Reply to #3)
excalibur

I keep troubleshooting things myself. LOL.

I think this thread can be considered resolved.

Thu, 12/13/2007 - 12:43 (Reply to #4)
Joe
Joe's picture

<div class='quote'>I keep troubleshooting things myself.</div>

That's good news. Because I have no idea what's going on in this thread. ;-)

--

Check out the forum guidelines!

Topic locked