- 论坛徽章:
- 0
|
回复 2# chengchow
执行结果如下:- mysql> DROP USER 'levi'@'%';
- Query OK, 0 rows affected (0.00 sec)
- mysql> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
- mysql> GRANT ALL ON `wordpress`.* to 'levi'@'%' IDENTIFIED BY '>____<' WITH GRANT OPTION;
- Query OK, 0 rows affected (0.00 sec)
- mysql> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
- mysql> show grants for `levi`;
- +-----------------------------------------------------------------------------------------------------+
- | Grants for levi@% |
- +-----------------------------------------------------------------------------------------------------+
- | GRANT USAGE ON *.* TO 'levi'@'%' IDENTIFIED BY PASSWORD '>____<' |
- | GRANT ALL PRIVILEGES ON `wordpress`.* TO 'levi'@'%' WITH GRANT OPTION |
- +-----------------------------------------------------------------------------------------------------+
- 2 rows in set (0.00 sec)
复制代码 结果还是一样的,请问怎么解决?
|
|