操作系统:windows 7
mysql版本:Server ersion: 5.6.14
使用insert语句添加管理员
insert into mysql.user(Host,User,Password) values ('localhost','username',password('123456'));
报错:
ERROR 1364 (HY000): Field 'ssl_cipher' doesn`t hava a default value
解决方法:
GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;
执行结果:
Query OK, 0 rows affected
分配权限:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON database(tables).* TO 'username'@'localhost' IDENTIFIED BY '123456';
授权生效:
FLUSH PRIVILEGES