ISPConfig mysql error...
Straight to the point - I have development server where I use ispconfig to setup different test senarios while working on projects. Out of nowhere today I'm unable to create a database. Under Monitor>System-log for every job either creating or deleting a database I get: Unable to connect to the database.
After hours of searching the forums and finding the same solutions - reseting the root password of mysql and all - and successfully doing so, I still get the error.
I checked the password in config.inc.php and updated it. Restarted the system and all. Everything regarding reseting and ensuring the password was correct.
Until I tried to manually update ispconfig as a last resort - even there when it ask for the mysql root password and showing the right one, I still get: Unable to connect to mysql server Access denied for user 'root'@'localhost' (using password: YES)
It's driving me mad. I even went ahead and updated Ubuntu and tried again to update ispconfig. Nothing - same error.
The weirdest thing is that last week I setup an account and database with no problem and since then I had not updated ubuntu or ispconfig or changed anything.
I'd appreciate any help on this as I want to avoid reinstalling everything from scratch.
Reagrding your initial problem, if you lost your root access, then you can reset the mysql root password like it is described in the FAQ
I tried what you suggested and had done it earlier but it does not work.
The inserts and dumps to ispconfig database do happen. It's just mysql root access is non negotiable - it not working no matter what I do.
|All times are GMT +2. The time now is 17:02.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.