Submitted by DaveOverton on Sat, 06/04/2016 - 16:01 Pro Licensee
If I backup a MySQL DB this gets inserted into the first line of the backup file. The restore breaks when it sees this strange line. Both the manual "sql" backup and the complete virtualmin server backup do this.
"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."
Using Mysql 5.5.46
Status:
Active
Comments
Submitted by JamieCameron on Sat, 06/04/2016 - 17:53 Comment #1
That's an odd message, as Virtualmin should be already using the
--passwordflag to set the password.What does the file
/etc/webmin/mysql/versioncontain on your system?Submitted by DaveOverton on Wed, 06/08/2016 - 04:00 Pro Licensee Comment #2
/etc/webmin/mysql/version 5.5.46
This is the first few lines from the ".sql" file created:
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. -- MySQL dump 10.13 Distrib 5.5.46, for Linux (x86_64)
Submitted by JamieCameron on Thu, 06/09/2016 - 01:32 Comment #3
Do you have a
pass=line in your/root/.my.cnffile? If so, try removing that.Submitted by DaveOverton on Sun, 07/17/2016 - 19:37 Pro Licensee Comment #4
Yes, I had installed a .my.cnf for some experiment or another, and of course, it had "pass=". Of course, I promptly forgot that it was even there. Thanks!
Submitted by andreychek on Sun, 07/17/2016 - 23:03 Comment #5
Great, glad to hear that's working for you now!