Unique option prefix pass instead of password is deprecated

Here you can find tutorials and notes for server-side maintenance/configuration

Unique option prefix pass instead of password is deprecated

Postby lik » Fri Aug 09, 2013 5:23 pm

Noticed strange warning recently during the work with MySql:
Code: Select all
# mysqladmin pr
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.
+-------+------+-----------+----+---------+------+-------+------------------+
| Id    | User | Host      | db | Command | Time | State | Info             |
+-------+------+-----------+----+---------+------+-------+------------------+
| 41269 | root | localhost |    | Query   | 0    |       | show processlist |
+-------+------+-----------+----+---------+------+-------+------------------+

Code: Select all
# mysql -V
mysql  Ver 14.14 Distrib 5.5.33, for Linux (i686) using readline 5.1

This warning appears because of 'pass' option in .my.cnf file:
Code: Select all
# cat ~/.my.cnf
[client]
user = root
pass = Secure_passWord

To avoid warning message just replace 'pass' option with full option 'password':
Code: Select all
# cat ~/.my.cnf
[client]
user = root
password = Secure_passWord
lik
Founder
Founder
 
Posts: 497
Joined: Wed Dec 15, 2010 3:21 am

Return to Server Side Actions

 


  • Related topics
    Replies
    Views
    Last post
cron