1.修改密码
use mysql;
update user set authentication_string=password('147258@.') where user='test';
flush privileges;
2.查看连接数信息
show processlist
update user set authentication_string=password('123456@#') where user='dev';
docker run -d -p 3306:3306 --privileged=true -v /home/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=22330 --name mysql ba7a93aae2a8
mysql -uroot -p123456@ -h192.168.2.48 wms -Dwms < 1.sql >> 2.txt
https://blog.csdn.net/belug/article/details/81081040/
mysql 加密方式修改
create user 'test'@'%' identif