when doing backups these errors are showing up:
Dumping MySQL database kb_montage …
… dump failed! Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.
What to do?
This is running on a
Ubuntu Linux 12.04.2
Webmin version 1.631
Virtualmin version : 4.01 pro
Do you have the file
/root/my.cnf? And in it, do you see a
If so, you may want to try changing that to the full
It seems to do the trick. But I haven’t changed this file.
Ive only installed Ubuntu, and then Virtualmin?
That file isn’t used by Virtualmin… something else likely installed that on your system.
If you didn’t set it up manually, it’s possible that some other package that was installed onto your system had set that up.
You should be able to rename, or delete, that file if you aren’t using it though.
I have the same problem on Debian 7.6 - exact Debian 4.6.3-14 and I have no pass nor password in the my.cnf file which is stored in /etc/mysql
Maybe the pass parameter is user in the backup script and should be corrected?
I use Virtualmin 4.09GPL
Virtualmin’s backup script doesn’t pass in the “pass” parameter, and the issue you’re seeing doesn’t occur by default.
Do you happen to have a file named “.my.cnf” (note the “.” on the front) in your /root? If so, could you try renaming it and then re-attempting the backup?
I just found the .my.cnf file in the root folder. Changed pass to password and the backups works.
Thank you for your quick help.