Topic: backup to desktop fails after changing mysql root password

[ksc133]

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

[ksc133]

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

 

[dsemuk]

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

[ksc133]

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.

[CharlieBrady]

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.

[ksc133]

thanks for info.. pal

cheers!