#1  
Old 25th February 2013, 18:24
georgen georgen is offline
Junior Member
 
Join Date: Feb 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ISPConfig mysql error...

Hi,

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.

Thanks inadvance.
Reply With Quote
Sponsored Links
  #2  
Old 25th February 2013, 19:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Quote:
I checked the password in config.inc.php and updated it.
Thats not related to the mysql root password. If you have a backup of that file then you should restore that to not break your system even more.

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

http://www.faqforge.com/linux/contro...root-password/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 25th February 2013, 20:03
georgen georgen is offline
Junior Member
 
Join Date: Feb 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by till View Post
Thats not related to the mysql root password. If you have a backup of that file then you should restore that to not break your system even more.

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

http://www.faqforge.com/linux/contro...root-password/
Thanks for the reply, I was typing quickly and didn't make it clear - it wasn't config.inc.php actually it was mysql_clientdb.conf and what I did update was my password to what was in the file.

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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Relay access denied when using SMTP to external recipients Kamran Shah Installation/Configuration 111 14th May 2014 18:10
Dual server with ISPConfig 3 but with errors alphaman36 Installation/Configuration 8 23rd August 2012 12:59
ISPCONFIG 3 Email Content Filter jariasca Installation/Configuration 11 2nd August 2012 12:27
Error compilation ISPConfig 2.2.34? severnet Installation/Configuration 5 20th December 2009 16:43
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 14:31


All times are GMT +2. The time now is 23:46.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.