mysql: [Warning] Using a password on the command line interface can be insecure.解决方法

1.在使用mysql命令的时候，出现问题:

https://www.cndba.cn/hbhe0316/article/22635

https://www.cndba.cn/hbhe0316/article/22635 https://www.cndba.cn/hbhe0316/article/22635 https://www.cndba.cn/hbhe0316/article/22635 https://www.cndba.cn/hbhe0316/article/22635 https://www.cndba.cn/hbhe0316/article/22635

[root@mysql57 ~]# mysql -uroot -pwwwwww -S /mysql/mysql.sock -e "show processlist"
mysql: [Warning] Using a password on the command line interface can be insecure.
+----+------+-----------+------+---------+------+----------+------------------+
| Id | User | Host      | db   | Command | Time | State    | Info             |
+----+------+-----------+------+---------+------+----------+------------------+
| 19 | root | localhost | NULL | Query   |    0 | starting | show processlist |
+----+------+-----------+------+---------+------+----------+------------------+

2.使用如下命令https://www.cndba.cn/hbhe0316/article/22635

https://www.cndba.cn/hbhe0316/article/22635

https://www.cndba.cn/hbhe0316/article/22635 https://www.cndba.cn/hbhe0316/article/22635

[root@mysql57 ~]# mysql -uroot -pwwwwww -S /mysql/mysql.sock -e "show processlist" 2>/dev/null
+----+------+-----------+------+---------+------+----------+------------------+
| Id | User | Host      | db   | Command | Time | State    | Info             |
+----+------+-----------+------+---------+------+----------+------------------+
| 27 | root | localhost | NULL | Query   |    0 | starting | show processlist |
+----+------+-----------+------+---------+------+----------+------------------+

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL