[질문]mysql 에서 사용자가 왜 추가가 되지 않는건지 ?
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
그냥 grant 쓰세요 간편하게...
그냥 grant 쓰세요 간편하게...
댓글 달기