Can't create database

[briandelshasta]

I've create a couple databases, both with the admin account and with client accounts. Now for some reason when I create a database in ISPConfig 3 is doesn't actually exist in mysql. ISPConfig does not seem to notice any problem and does display the database, but obviously no webapps can connect to the non-existent db.

Does anyone know where to begin troubleshooting this?

Thanks

[rootfive]

Database is created but it does not grant privileges to user. Use phpmyadmin to give privileges and it will be ok.

[briandelshasta]

Perhaps I wasn't clear. The database is not getting created. I've logged into the mysql cli and the database is not there.
I thinking some privs got messed up for the ispconfig user maybe, but I can't remember where to find those creds.

[rootfive]

I finished ispconfig3 this morning on CentOS5.4 and I have no problem creating database, the only problem is it does not grant rights.

[till]

I finished ispconfig3 this morning on CentOS5.4 and I have no problem creating database, the only problem is it does not grant rights.

Then you must have installed ispconfig with a wrong mysql user. When the installer aksks for a mysql user, you have to use the root user, otherweise ispconfig does not have the rights later to create new mysql users and databases.

[rootfive]

I installed with the right user. ISPConfig create the database and user. The only thing is it does not grant the permission to user for the created database. When I grant the user permission from myphpadmin it works fine. Otherwise joomla give me it cannot connect to database. I am not sure it is either bug or installation problem. I followed the procedure of perfect setup with ISPconfig 3 and centos5.4

Thanks

[till]

Which ispconfig version?

[rootfive]

ISPConfig 3.0.1.6 running on CentOS 5.4