Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: ksc133 on June 16, 2006, 04:23:06 PM

Title: backup to desktop fails after changing mysql root password
Post by: ksc133 on June 16, 2006, 04:23:06 PM

hi folks,

backup to desktop fails after changing mysql root password

error: Operation status report
Error occurred during pre-backup actions.

any ideas?

thanks and have a nice day

Title: backup to desktop fails after changing mysql root password
Post by: ksc133 on June 16, 2006, 04:29:22 PM

is it possible that the mysql dump script needs to edit the root password of mysql?

 :roll:

Title: backup to desktop fails after changing mysql root password
Post by: dsemuk on June 16, 2006, 06:30:18 PM

You shouldn't have any reason to change the MySQL root passwd.

Do a search for MySQL root password and you will see this has been covered many many times.

Any application which needs access to MySQL should have its own DB & User(s), with privileges set for that particular application.

Running an application as root is asking for trouble.

Dave

Title: backup to desktop fails after changing mysql root password
Post by: ksc133 on June 16, 2006, 06:35:42 PM

thanks

but the default root password for SME fresh installation is "blank"!

so can anyone advice me on how to edit the backup script to include my new password?

thanks and have a nice day.

Title: backup to desktop fails after changing mysql root password
Post by: CharlieBrady on June 16, 2006, 10:10:27 PM

Quote from: "ksc133"

but the default root password for SME fresh installation is "blank"!

No, that is *false*. The default root password for MySQL is a long random string. If you happened to be logged in as root, you do not need to type the password, because the 'mysql' client program reads it from /root/.my.cnf.

Title: backup to desktop fails after changing mysql root password
Post by: ksc133 on June 17, 2006, 03:32:35 AM

thanks for info.. pal

cheers!