I just created a new mySQL database using the Dreamhost web interface. The Web interface shows the database and seems to be very happy with my new database listed under the two old ones I have created previously. However, when I go to phpMyAdmin, I do not see the new database listed at all. Also, I cannot see the database from the command line, and the database does not get listed when executing ‘show databases;’ from the mysql prompt.
The user exists and is assigned to the new database exactly the same as the old databases that I have verified that I can see and access. It seems to me that while it is listed as being created in the Dreamhost web page in fact it is not being created. I have tried to delete and create a new database with the same effect.
Any insight is appreciated.