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)