|
mysql에서 사용자 추가가 왜 안되는거죠?
1)
mysql> insert into user
->
values('192.168.1.10','test1',password('test1'),'Y','Y','Y','Y','Y'
,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
ERROR 1136: Column count doesn't match value count at row 1
2)
mysql> insert into
user(Host,User,Password,Select_priv,Insert_priv,Update_priv,
Delete_priv,Create_priv,Drop_priv,Reload_priv,Shutdown_priv,Process_priv,File_priv,Grant_priv,References_priv,Index_priv,Alter_priv)
a ->
values('192.168.1.10','test1',password('test1'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresp
onds to your MySQL server version for the right syntax to use near
'user(Host,Us
er,Password,Select_priv,Insert_priv,Update_priv,Del
|
