Disabling mysql unique option prefix pass warning

Database
1

Hi,

I’m always getting following warning message when I try to execute statement from shell with mysql -e "...." command:

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.

How can I make this messages to disappear?

2

It is related with password settings in your ~/.my.cnf file.

In past the keyword pass used in configuration files like that:

[client]
user=root
pass=xxxx

But now, you need to use keyword password, not just past. So, according to new format example configuration should be in the form of:

[client]
user=root
password=xxxx

After that all of the option prefix pass warning messages has gone away.

4

Thanks a lot, it just works.