mysql
1. 查看进程 show full processlist
2. 查看主数据库状态 show master status
主从复制参考网页: https://www.cnblogs.com/luckcs/articles/2543607.html
3. mysqladmin -uroot -padmin(原密码) password 123456 (更改密码)
flush privilege
4.mysqld --skip-grant-tables ----忘记密码情况下,跳过密码权限验证
5.创建mysql用户 create user 'username'@ip identified by '密码';
查看用户,use mysql;
select user,host from user;
6. 赋予权限 grant 权限1,权限2 on 数据库.* to username@ip
7. 回收权限 revoke 权限1,权限2 on 数据库.* from username@ip
8. 查看用户权限 show grants for username@ip \G
9. 删除用户 drop user username@ip
show character set;
show variables like '%char%'
show table status \G
show index from tablename \G