创建新的mysql用户 [英] Creating new mysql user
问题描述
嗨
i创建新的mysql用户有问题
即时通讯使用此代码:
[PHP ] INSERT INTO用户(主机,用户,密码,select_priv,insert_priv,update _priv)VALUES(''localhost'',''abdoelmasry'',PASSWORD('''341062''),''Y'',''Y '',''Y''); [/ PHP]
i总是收到以下消息:
字段''ssl_cipher''不会有一个默认值
i尝试为列'ssl_cipher'设置NULL值但是仍然有问题
任何人都可以提供帮助?
您的表似乎有一个必须设置值的列''ssl_cipher''。它没有默认值,并且不接受NULL。
要确定其数据类型和其他内容,请发出DESCRIBE user命令,它将显示所有列具有以下特征的表用户
展开 | 选择 | Wrap | 行号
Ok
我要做什么..
来解决这个问题?
Ok
我要做什么。 。
来解决这个问题?
这是你的桌子,所以你是唯一一个知道该领域的人。
罗纳德:很酷:
Hi
i have problem with creating new mysql user
im using this code :
[PHP]INSERT INTO user (host,user,password,select_priv,insert_priv,update _priv) VALUES (''localhost'',''abdoelmasry'',PASSWORD(''341062''),''Y'', ''Y'',''Y'');[/PHP]
i always get the following message:
Field ''ssl_cipher'' doesn''t have a default value
i tried to set NULL value for the column ''ssl_cipher'' but is still have problems
Any one can help ?解决方案It seems that you table has a column ''ssl_cipher'' that must have a value set. It has no default and NULL is not accepted.
To determine what its data type and other things are, issue a ''DESCRIBE user'' command and it will show you all columns of the table user with the following characteristics
Expand|Select|Wrap|Line Numbers
Ok
what i have to do ..
to solve that ?
Ok
what i have to do ..
to solve that ?It is your table, so you are the only one who knows what goes into that field.
Ronald :cool:
这篇关于创建新的mysql用户的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文