MySQL ERROR

今天注定是个特殊的日子——想着没事，捣鼓一下数据库，结果敲个命令出个ERROR。眼瞅着脾气渐渐的就要上来了，转念一想，反正没事不如就写一天‘bug’玩玩，再把这些小玩意儿记录下来。辛辛苦苦码了一上午，中午吃个饭回来，发现电脑关机了.....

我天! 我还没想好文章标题......

 (不生气,这都是小事......)

---

目录

1、ERROR 1396 (HY000): Operation CREATE USER failed for 'model_one'@'%'

 

2、ERROR 1133 (42000): Can't find any matching row in the user table

3、ERROR 1046 (3D000): No database selected

---

 

创库、建用户、授权...一气呵成！ ok!

mysql> create database XX_MALL charset=utf8;
Query OK, 1 row affected (0.00 sec)

mysql> create user model_one identified by '123456';
Query OK, 0 rows affected (0.12 sec)

mysql> grant all on XX_MALL.* to 'model_one'@'%';
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)

额？我似乎该换个环境.....

删了吧....

切换虚拟环境，把刚刚的操作再完美的演绎一遍...

mysql> create database XX_MALL charset=utf8;
Query OK, 1 row affected (0.00 sec)

mysql> create user model_one identified by '123456';
ERROR 1396 (HY000): Operation CREATE USER failed for 'model_one'@'%'

哈！ 不出意外的报了错

1、ERROR 1396 (HY000): Operation CREATE USER failed for 'model_one'@'%'

 

1.1、回忆一下刚刚的操作，我似乎没有数据库授权.....

尝试着执行以下命令：

drop user 'model_one'@'%';

mysql> drop user 'model_one'@'%';
Query OK, 0 rows affected (0.00 sec)

没毛病！

1.2、接下来该给用户授权了

mysql> grant all on XX_MALL.* to 'model_one'@'%';
ERROR 1133 (42000): Can't find any matching row in the user table

嗯？....

2、ERROR 1133 (42000): Can't find any matching row in the user table

提示说在user 表中没有找到任何匹配的行==（人话：就是说没有权限表）

什么表不表的？ 事真多  open baidu CTRLC + CTRLV

哦？ 有圈内人士说需要flush 一下下

mysql> flush privileges
    -> ;
Query OK, 0 rows affected (0.00 sec)


mysql> grant all on XX_MALL.* to 'model_one'@'%';
ERROR 1133 (42000): Can't find any matching row in the user table

似乎不太合适....

难道我刚刚删的时候操作错了？

查看一下所有用户

mysql> select host,user,123456 from mysql.user
    -> ;
+-----------+------------------+--------+
| host      | user             | 123456 |
+-----------+------------------+--------+
| %         | it12345          | 123456 |
| %         | modle_one        | 123456 |
| localhost | debian-sys-maint | 123456 |
| localhost | mysql.sys        | 123456 |
| localhost | root             | 123456 |
+-----------+------------------+--------+
5 rows in set (0.00 sec)

删除用户it12345

mysql> delete from user where user='it12345' and host='%';
ERROR 1046 (3D000): No database selected

嗯？？？

3、ERROR 1046 (3D000): No database selected

写错了？

再来！

mysql> delete from user where user='it12345' and host='%';
ERROR 1046 (3D000): No database selected

........

我换！

mysql> delete from mysql.user where user='itcast' and host='%';
Query OK, 1 row affected (0.11 sec)

删除modle_one

mysql> delete from mysql.user where user='model_one' and host='%';
Query OK, 0 rows affected (0.00 sec)

ok!

查看所有用户

mysql> select host,user,123456 from mysql.user;
+-----------+------------------+--------+
| host      | user             | 123456 |
+-----------+------------------+--------+
| %         | modle_one        | 123456 |
| localhost | debian-sys-maint | 123456 |
| localhost | mysql.sys        | 123456 |
| localhost | root             | 123456 |
+-----------+------------------+--------+
4 rows in set (0.00 sec)

（嗯？震惊脸！！！）

flush

mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

mysql> select host,user,123456 from mysql.user;
+-----------+------------------+--------+
| host      | user             | 123456 |
+-----------+------------------+--------+
| %         | modle_one        | 123456 |
| localhost | debian-sys-maint | 123456 |
| localhost | mysql.sys        | 123456 |
| localhost | root             | 123456 |
+-----------+------------------+--------+
4 rows in set (0.00 sec)

..........

我再换行吧！

mysql> drop user 'modle_one'@'%';
Query OK, 0 rows affected (0.01 sec)

mysql> select host,user,123456 from mysql.user;
+-----------+------------------+--------+
| host      | user             | 123456 |
+-----------+------------------+--------+
| localhost | debian-sys-maint | 123456 |
| localhost | mysql.sys        | 123456 |
| localhost | root             | 123456 |
+-----------+------------------+--------+

perfect！

（时间花得有点多了，下次继续.....）