mysql创建用户出现错误
来源:百度知道 编辑:UC知道 时间:2024/07/02 02:36:58
刚才安装了mysql数据库,没有设置密码。mysql -uroot -p 可以进入数据库,但是我想重新建立一个有密码的用户!
Field 'ssl_cipher' doesn't have a default value 出现了这个错误,怎么解决啊!
mysql>insert into mysql.user(Host,User,Password) values
("localhost","sa",password("ok")); 建立用户的语句是这样写得!
请高手帮我!谢谢
Field 'ssl_cipher' doesn't have a default value 出现了这个错误,怎么解决啊!
mysql>insert into mysql.user(Host,User,Password) values
("localhost","sa",password("ok")); 建立用户的语句是这样写得!
请高手帮我!谢谢
不能这样简单的插入数据库创建用户,因为'ssl_cipher'字段不能为空,必需指定数值,应该使用GRANT命令创建用户,格式:
13.5.1.3. GRANT和REVOKE语法
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON [object_type] {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER 'cipher' [AND]]
[ISSUER 'issuer' [AND]]
&