Cannot Create New MySQL Databases

I have ISPConfig3 setup on an Ubuntu server and followed the excellent guide here. After initially setting up the server I was able to create some MySQL databases through ISPConfig. I could log into those MySQL databases through PHPMyAdmin. Now I cannot.

I create the database, user, and select the site through ISPConfig. No errors or anything. When I attempt to log into MySQL it basically gives me a error: #1045 Cannot log in to the MySQL server. I also cannot log into the database with the newly created MySQL username / password through at the terminal. mysql -u user -pPassword

I need to create some new databases for new sites. Any help or suggestions would be awesome. I've checked the logs and have not see anything.

 

When I log into the database as root through the termainl, then run select host, user, password from mysql.user; it does not show any of the users I've created.

What would prevent ISPConfig from creating users or databases?

Thanks

 

Make sure that your database details in /usr/local/ispconfig/interface/lib/config.inc.php are correct.

 

I just checked that and mysql_clientdb.conf and everything looks correct. Is there anything that should stand out in the conf files?

I was able to mysql -u root -pPassword based on the info in mysql_clientdb.conf.

Any other suggestions? Thanks

 

Tried: mysql -h localhost -u root -pPassword and it worked correctly.

In my Jobqueue i have a lot of insert / delete / update to web_database table. It seems these are all the database creations I have been trying to do but yet not going through.

 

ISPConfig System-Log does not show any issues.

I followed this thread: http://www.howtoforge.com/forums/showthread.php?t=45407 and it seems to be the same thing but I am not sure how to fix it.


select datalog_id from sys_datalog; returns 138 as the last result but

mysql> select updated from server; returns 137.

Not sure how to make it sync so I can create databases.

Thanks

 

Ran sudo apt-get upgrade
Downloaded and updated ISPConfig to 3.0.3.2

Currently in my JobQueue I have one thing pending.


select datalog_id, status from sys_datalog order by datalog_id;

Shows 138 items pending. Does it matter there are that many pending in there but only one item showing up in JobQueue?

select updated from server; returns 137.

I set the updated column to 138 and rebooted the server.

After reboot I tried to make a database but it failed.

Same issue. sys_datalog shows 139 items but updated column only shows 138.

Any suggestions?

Also the database I create show sup in web_database but nothing when listing actual databases in mysql nothing shows up.

Thanks

 

Ran the update script and it looks like it fixed everything.

I am all set.

Thanks for your help!