Old 27th November 2010, 22:59
Youko Youko is offline
Junior Member
Join Date: Oct 2007
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default [Solved] Problem updating (MySQL issue)


When I try to update ISPCOnfig 3, I ge tthe following errors:

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in /tmp/ispconfig3_install/install/lib/mysql.lib.php on line 78

Fatal error: Cannot use string offset as an array in /tmp/ispconfig3_install/install/lib/update.lib.php on line 98
I am running the update command as root.

Now, I most likely know what the first error is.
My ISP had made the initial ISPConfig 3 installation.

Later, I updated my MySQL root password. However, according to
the upgrade guide, the updater should ask me the root password for
MySQL which it does not which leads me to think the info is stored in some
file, but I can't find it anywhere! Help would really be appreciated!

For the second error I have no clue.

Last edited by Youko; 28th November 2010 at 22:17.
Reply With Quote
Sponsored Links
Old 28th November 2010, 16:25
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,036
Thanks: 841
Thanked 5,656 Times in 4,464 Posts

The mysql root password has to be changed in the file /usr/local/ispconfig/server/lib/mysql-clientdb.conf when you change the root password of the mysql server. Otherwise ispconfig will not work properly anymore and is e.g. unable to create new databases.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following 2 Users Say Thank You to till For This Useful Post:
finn (27th February 2011), Youko (28th November 2010)
Old 28th November 2010, 22:16
Youko Youko is offline
Junior Member
Join Date: Oct 2007
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts

Thank you so much! This was driving me insane.
Reply With Quote
Old 24th December 2010, 16:09
mascoxx mascoxx is offline
Junior Member
Join Date: Sep 2007
Location: Austria
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to mascoxx Send a message via Skype™ to mascoxx


I've got the same issues, but the credentials are correct because I'm also able to login in manually!
In my environment are three machines. One of them is the master service which also provides the admin panel. The other both are web- and mailservers.
The master update was successful, but then I've tried to update the second one - with this error as described by Youko.

Till, do you have an idea what's going wrong?

Thanks and regards,
Reply With Quote


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
mysql ssl data replication problem certificate issue? isn Server Operation 5 30th July 2010 16:38
MySQL problem satimis Server Operation 5 25th June 2008 16:41
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
ISPConfig Mysql root password issue ?? Stuck at install Randall Hoffman Installation/Configuration 1 16th January 2007 21:53
Site with MySQL problem?! edge Server Operation 2 13th August 2006 20:57

All times are GMT +2. The time now is 11:27.

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