Activities

November 2013
M T W T F S S
« Oct   Dec »
 123
45678910
11121314151617
18192021222324
252627282930  

Mysql dump warning : Using unique option prefix pass instead of password is deprecated

While you taking backup of Mysql version 5.5 , you would have get the following error

 [root@host1-merriman scripts]# /bin/sh  /home/installation/scripts/db_backup.sh
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.

Solution:

Open my.cnf file from the user profile folder ( ~/.my.cnf) and change the MySQL client connectivity option from “pass” to “password”

It should be like this

[root@host1-merriman scripts]# cat  ~/.my.cnf
[client]
user="root"
password="NU*NHA76bA"

A simple fix 🙂

1 comment to Mysql dump warning : Using unique option prefix pass instead of password is deprecated

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>