1.mysql修改root密码
mysqladmin -uroot -p旧密码 password 新密码
2.mysql -uroot -p密码
use mysql
update user set password=PASSWORD('密码') where user="root";
flush privileges;
3.mysql查看当前连接数和状态
show full processlist;
show status;
4.查看mysql数据库用户
select user from user;