Problem Creating New Databases

[ElJavielon]

I have a problem creating new databases. I use phpMyAdmin and when I create a database phpMyAdmin does not record any kind of error but when I run WinMySQLAdmin and I go to the databases tag for some strange reason it does not recognize the new database. Also when I try to install a forum under that database it says "Cannot connect to database" for the reason that MySQL does not recognize the new database that was created. How can i fix this problem?Please help me as soon as possible.

[akillez]

check your process list, it could be that each start up mysql, leaving the last with no databases if made in the first and vice versa...

[ElJavielon]

i dont understand can you please make it clearer? or just aim me at dramaking830 or at msn [e-mail] I would really appreciate your help. Thank you

[akillez]

Well, I'm on an XP machine and for developing mysql/php sites I use either phpdev or xampp. When I startup phpdev and create a table, it all works fine (same goes for xampp).
But if I startup both (or one doesn't shut down properly), it will also load mysql.exe twice.
Changes made in one mysql.exe are unknown to the other and thus unreadable by other software (phpMyAdmin, WinMySQLAdmin,...)

So possibly it's the same story in your case.

[ElJavielon]

ElJavielon wrote on 08-04-2004 06:21 PM:
I only have PHPMyAdmin, i only use this PHP program and this i got this problem, what can i do about please explain in easy terms because I'm kind of a rookie in this.

[delfa]

Make sure that a new folder is created under installation_directory_of_mysql/data/ with the name of the database

[ElJavielon]

never mind problem fixed 😃