dump failed! Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release.

7 posts / 0 new
Last post
#1 Tue, 10/29/2013 - 06:30
tcl@cunotech.dk

dump failed! Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release.

Hi,

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

Tue, 10/29/2013 - 10:43
andreychek

Howdy,

Do you have the file /root/my.cnf? And in it, do you see a pass= parameter?

If so, you may want to try changing that to the full password=.

-Eric

Tue, 10/29/2013 - 11:18
tcl@cunotech.dk

It seems to do the trick. But I haven't changed this file.

Ive only installed Ubuntu, and then Virtualmin?

Tue, 10/29/2013 - 14:53
andreychek

Howdy,

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.

-Eric

Thu, 08/21/2014 - 07:17
chgerwig

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

Regards, Christian

Thu, 08/21/2014 - 10:49
andreychek

Howdy,

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?

-Eric

Thu, 08/21/2014 - 18:07 (Reply to #6)
chgerwig

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.

Regards, Christian

Topic locked