在root用下
创建了books数据库
创建新用户如下:
mysql> grant select, insert, update, delete, index, alter, create, drop
-> on books.*
-> to bookorama identified by 'bookorama123';
返回结果如下:
Query OK, 0 rows affected (0.00 sec)然后在phpMyAdmin中的mysql数据库下
select * from user
结果:有bookorama用户但是,权限没有附上
还有登录新建的用户:
-h localhost -u bookorama -p
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '-h localhost -u bookorama -p' at line 1
是什么情况,有谁帮忙给解释下。
创建了books数据库
创建新用户如下:
mysql> grant select, insert, update, delete, index, alter, create, drop
-> on books.*
-> to bookorama identified by 'bookorama123';
返回结果如下:
Query OK, 0 rows affected (0.00 sec)然后在phpMyAdmin中的mysql数据库下
select * from user
结果:有bookorama用户但是,权限没有附上
还有登录新建的用户:
-h localhost -u bookorama -p
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '-h localhost -u bookorama -p' at line 1
是什么情况,有谁帮忙给解释下。
这和php无关,移到mysql版回答的人更专业
在dos命令下
-u bookorama -p bookorama123
登录到bookorama用户
use books;
show grants;
结果:
+----------------------------------------------------------------------------------------------------------+
| Grants for bookorama@% |
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'bookorama'@'%' IDENTIFIED BY PASSWORD '*1ECE648641438A28E1910D0D7403C5EE9E8B0A85' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `books`.* TO 'bookorama'@'%' |
+----------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
可以看出bookorama的权限是付上了
但是,用root用户登录phpMyAdmin
use mysql
select * from user
从结果看出bookorama的权限没有显出来
对应权限都是'N'
是怎么回事,难道我的phpMyAdmin 没有配置好。
在dos命令下
-u bookorama -p bookorama123
登录到bookorama用户
use books;
show grants;
结果:
+----------------------------------------------------------------------------------------------------------+
| Grants for bookorama@% |
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'bookorama'@'%' IDENTIFIED BY PASSWORD '*1ECE648641438A28E1910D0D7403C5EE9E8B0A85' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `books`.* TO 'bookorama'@'%' |
+----------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
可以看出bookorama的权限是付上了
但是,用root用户登录phpMyAdmin
use mysql
select * from user
从结果看出bookorama的权限没有显出来
对应权限都是'N'
是怎么回事,难道我的phpMyAdmin 没有配置好。
在dos命令下
-u bookorama -p bookorama123
登录到bookorama用户
use books;
show grants;
结果:
+----------------------------------------------------------------------------------------------------------+
| Grants for bookorama@% |
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'bookorama'@'%' IDENTIFIED BY PASSWORD '*1ECE648641438A28E1910D0D7403C5EE9E8B0A85' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `books`.* TO 'bookorama'@'%' |
+----------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
可以看出bookorama的权限是付上了
但是,用root用户登录phpMyAdmin
use mysql
select * from user
从结果看出bookorama的权限没有显出来
对应权限都是'N'
是怎么回事,难道我的phpMyAdmin 没有配置好。