请教如何去解决mysql这个错误?
Create schema tss_0_5_0_55;
grant all on tss_0_5_0_55.* to test@tddserver identified by "test";
我在本地上连接tddserver服务器,然后执行
grant all on tss_0_5_0_55.* to test@tddserver identified by "test";
语句,出现了以下的错误:
ERROR 1044 (42000) at line 2: Access denied for user 'root'@'%' to database 'tss_0_5_0_55'
请教是什么原因造成的?
我把
grant all on tss_0_5_0_55.* to test@tddserver identified by "test";
改为
grant select,create,drop on tss_0_5_0_55.* to test@tddserver identified by "test";
是可以执行的,但是赋所有权限是不行的,请教是什么原因??
Create schema tss_0_5_0_55;
grant all on tss_0_5_0_55.* to test@tddserver identified by "test";
我在本地上连接tddserver服务器,然后执行
grant all on tss_0_5_0_55.* to test@tddserver identified by "test";
语句,出现了以下的错误:
ERROR 1044 (42000) at line 2: Access denied for user 'root'@'%' to database 'tss_0_5_0_55'
请教是什么原因造成的?
我把
grant all on tss_0_5_0_55.* to test@tddserver identified by "test";
改为
grant select,create,drop on tss_0_5_0_55.* to test@tddserver identified by "test";
是可以执行的,但是赋所有权限是不行的,请教是什么原因??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货