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.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th March 2013, 14:05
compugraphix compugraphix is offline
Member
 
Join Date: Jul 2010
Posts: 39
Thanks: 6
Thanked 1 Time in 1 Post
Default Mysql backup doesn't work on 3.0.5.1 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
  #2  
Old 18th March 2013, 14:06
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

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)
  #3  
Old 18th March 2013, 14:10
compugraphix compugraphix is offline
Member
 
Join Date: Jul 2010
Posts: 39
Thanks: 6
Thanked 1 Time in 1 Post
 
Default

perfect, then i know what the problem is.

Great!

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
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
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 09:49.


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