삽질 하며 조금씩 배워가는 유저입니다.
MySQL에서 사용자를 추가하려고 아래와 같이 했습니다.
왜 이상한 메세지가 나오는지 알려주세요.
localhost mysql># ./bin/mysql -u root -p
Enter Password:
~~~~
~~~~
mysql> use mysql
Database changed
mysql> INSERT INTO user VALUES('localhost','guest',password('12345'));
ERROR 1136: Column count doesn't match value count at row 1
mysql> INSERT INTO user VALUES('localhost','guest',password('12345'))
> ('N','N','N','N','N','N','N','N','N','N','N','N','N','N');
ERROR 1064: You have an error in your SQL syntax near '('N','N','N','N','N','N',
'N','N','N','N','N','N','N','N')' at line 2