Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 18th March 2013, 14:05
compugraphix compugraphix is offline
Join Date: Jul 2010
Posts: 39
Thanks: 6
Thanked 1 Time in 1 Post
Default Mysql backup doesn't work on debian Squeeze/Sid

Mysql database backup for customers doesn't work on Debian Squeeze/Sid
in the cron log i get mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

in /usr/local/ispconfig/server/lib/mysql_clientdb.conf
the data is correct.

are there any special characters you may not have in mysql password?
if i do
-> mysql -h localhost -u root -p (enter)
-> enter password: (enter the password here)

all works

--> mysql -h localhost -u root -p(password)
i get the following error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

any suggestions?
Reply With Quote
Sponsored Links
Old 18th March 2013, 14:06
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

The mysql root password in that file may not contain any characters that can get interpretde by a shell script. So use only a-z, A-Z 0-9 and _ in the password.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
compugraphix (18th March 2013)
Old 18th March 2013, 14:10
compugraphix compugraphix is offline
Join Date: Jul 2010
Posts: 39
Thanks: 6
Thanked 1 Time in 1 Post

perfect, then i know what the problem is.


Command for those who wants to know to change the root password for mysql:
-> mysqladmin -u root -p'oldpassword' password newpass

Last edited by compugraphix; 18th March 2013 at 14:21.
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
Web, Email And MySQL Database Cluster (Mirror) On Debian 6 mccyberix HOWTO-Related Questions 4 16th May 2012 12:29
HELP : Debian Squeeze perfect setup crashes Apache and MySql randomly ircf Technical 2 27th February 2012 18:01
Master MySQL Data Base replication issue On Debian Squeeze Linox91 Installation/Configuration 1 12th January 2012 23:34
Add ons for ISPConfig 3 virtue Installation/Configuration 24 16th October 2009 18:30
e-mail problem!!! Debian 3.1 maroonworks Installation/Configuration 18 6th December 2005 15:42

All times are GMT +2. The time now is 15:48.

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