Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


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


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!

share|improve this question

migrated from Feb 5 '12 at 4:02

This question came from our site for professional and enthusiast programmers.

Are you running 32-bit MySQL on 64-bit Windows? Check "Program Files (x86)". – db2 May 28 '13 at 23:00

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.

share|improve this answer
Thanks Eric Already checked it, it shows the same path datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/" I noticed I have 3 different installations: Microsoft SQL Server; Xampp; MySQL Server 5.5; may be this has to do something with my bug, not sure – vats Feb 4 '12 at 11:40
ugh, I want to make this a comment >.< – jcolebrand May 28 '13 at 19:55
@jcolebrand Why can't you make it a comment (is it because it has an upvote) ??? – RolandoMySQLDBA May 28 '13 at 22:18
Because it doesn't have an associated user on our site. Gray ghost name. – jcolebrand May 28 '13 at 22:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.