Thesql 5.5 strange bug

MySQL

I am trying to create a database in MySQL Server 5.5. The database is created, I know this as when I do 

SHOW DATABASES;

It shows me my database in the list of all databases from the commandline.

But when i go inside

C:\Program Files\MySQL\MySQL Server 5.5\data\

my database is not visible there. In fact with 

SHOW DATABASES;

it shows me 6 databases in the list but inside

C:\Program Files\MySQL\MySQL Server 5.5\data\

shows only two databases.

Its really strange error I m experiencing, the database is created but not actually created
feels like the commandline is cheating with me!

thanks for the help in advance!

Best Answer

Please check the my.cnf in the mysql installment folder.

like this:

datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

it will show you the right folder.

Related Question