site - databases

i found out today that ISPConfig doesnt create databases anymore that are created from web-site-administration .. inside ISPConfig it looks ok .. but no databases are created .. deleting existing ones works .. but not for new ones ( no limits ) - i am still able to create via phpmyadmin aso.

ispconfig.log doesnt show me useful debug on this .. the only MYSQL-related lines that occour read:

I guess your mysql user that you specified during ISPConfig setup has not the permission to create databases.

Click to expand...

well .. that is root .. and i can delete already created ones out of ISPC but not create any anymore..

via phpmyadm (root as well ) it is possible to create them ..

so its not the mysqld-part ..

there should also be an error in the ispconfig.log - but there isnt :-(

update:

i delete the DBs "web11_db1 web11_db2" and created "web13_db1 web14_db1 and web15_db1" .. after a few hours ( not after 5 mins or so) i could see "some" of the new databases in the Filesystem and on phpmyadmin, but not all .. :-/ ,while in IDPConfig they all show up

.. and one of those databases even shows up as web14?db1 (on fs and phpmyadmin ) -> "?" instead of "_" in ispconfig its name ist ok (with "_" )

but even after removing this badnamed db , creating dbs out of ispconfig is still not possible

i just reinstalled ispconfig 2.2.2 from scratch and tried to track the problem down ..

i started to happen again , after i deleted a site-datebase , emptied the recycliebin and recreated the site-database .. it stopped creating databases.. deleting is possible , but my ispconfig never clears the mysql/user table after deleting a database/db-user pair ..

i can see t in my mysql.log that the mysql-user to access the database is being created ... also can find it in the database ..

i need feedback of the following sequence:
@mysql_query("CREATE DATABASE DEFAULT CHARACTER SET utf8 ".$new_db);

it just runs through my log without error ... but in fact the DB is NOT being created .. please help me in debugging ..