mysql 5.5 strange bug

Question

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!

Answer 1

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