I installed mysql in my pc that have windows xp operating system. I digit this code to create a new users database:

mysql> insert into user values(
    -> 'localhost',
    -> 'phpuser',
    -> Password('phppass'),
    -> 'n', 'n', 'n', 'n', 'n', 'n', 'n',
    -> 'n', 'n', 'n', 'n', 'n', 'n', 'n');

but appear this message:

Error 1136: Column count doesn't match value count at row 1

what is the problem?

It means that you're inserting a different number of values than you have columns in the table.


Take care,

Nik
http://www.bigaction.org/