Thread: MySQL Error
View Single Post
Old 14th February 2011, 22:19
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,001
Thanks: 840
Thanked 5,650 Times in 4,460 Posts

I'am not atlking about ispconfig users, I talk about mysql users. The ispconfig installer creates a mysql database user name ispconfig and I guess that you have overwritten this user by copying back the old mysql database. The problem that this causes now is that neither the ispconfig nor services like postfix, pure-ftpd or dovecot / courier can connect to mysql anymore.

Please open the file /usr/local/ispconfig/server/lib/, in this file you find a mysql password. This is the cleartext password of the mysql user. Copy this password (do not chnage it in that file!), then open the mysql database with the name "mysql", find the user table in that database, there you will find a user named "ispconfig". Change the password for that mysql user to the password that you found in the file. Select "password" as encryption method. And then reload or restart the mysql database.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from
Reply With Quote