你新建用户的命令不对哦, 格式:grant select on 数据库.* to 用户名@登录主机 identified by \"密码\" 例如增加一个用户test1密码为abc,让他可以在任何主机上登录,并对所有数据库有查询、插入、修改、删除的权限。首先用以root用户连入MySQL,然后键入以下命令:grant select,insert,update,delete on *.* to test2@localhost identified by \"abc\" 如果你不想test2有密码,可以再打一个命令将密码消掉。grant select,insert,update,delete on mydb.* to test2@localhost identified by \"\"
MySQL查询最大值的方法并不十分复杂源码天空,下面就为您介绍MySQL查询最大值的方法,如果您遇到过MySQL查询最大值字段的问题,不妨一看。select a.*, b.count from ( select * from message where to_uid=2026 and is_del<2 and from_uid>0 order by mid desc ) as a join ( select reply_id,count(*) as count from message where reply_id>0 group by reply_id ) as b on (a.reply_id=b.reply_id) group by a.reply_id order by a.mid desc欢迎分享,转载请注明来源:内存溢出
评论列表(0条)