MySQL常见命令

1.进入MySQL命令

• mysql直接回车：空账号空密码（一般不用）
• mysql -uroot -p 直接回车，输入密码后再回车

2.MySQL三句话
create database ruozedata;
grant all privileges on ruozedata.* to ruoze@‘localhost’ identified by ‘123456’;
flush privileges;
其中：localhost表示可访问的ip地址，还可以是：

• grant all privileges on ruozedata.* to ruoze@’%’ identified by ‘123456’;
  % 代表任意ip允许访问MySQL服务
• grant all privileges on ruozedata.* to ruoze@‘192.168.137.%’ identified by ‘123456’;
  192.168.137.% 代表192.168.137.1-192.168.137.255都可以访问

查看权限：
show grants for ruoze@’%’;
发现缺少权限 ，再次执行权限
grant all privileges on ruozedata.* to ruoze@’%’ identified by ‘123456’;

3.进程

• Linux：ps -ef 查看进程，kill -9 杀进程
• MySQL：
  未来在公司里，当mysql出现卡顿时，（查数据特别特别慢），首先要查看进程：

mysql> show processlist;
+----+-------+---------------------+-----------+---------+-------+-------+------------------+
| Id | User  | Host                | db        | Command | Time  | State | Info             |
+----+-------+---------------------+-----------+---------+-------+-------+------------------+
|  9 | root  | localhost           | mysql     | Query   |     0 | init  | show processlist |
| 29 | ruoze | 192.168.137.1:58779 | ruozedata | Sleep   | 19488 |       | NULL             |
| 30 | ruoze | 192.168.137.1:58780 | ruozedata | Sleep   | 19488 |       | NULL             |
+----+-------+---------------------+-----------+---------+-------+-------+------------------+
3 rows in set (0.00 sec)

必要时杀进程：kill id

mysql> kill 29;
Query OK, 0 rows affected (0.00 sec)

mysql> kill 30;
Query OK, 0 rows affected (0.00 sec)