Ok, this is the deal

I have installed WinMySQLadmin 1.4 client on a Windows 2000 os, all seems to be ok to the point where I have managed to create a new test database successfully. However, when trying to create a new user in the 'user' table in the database 'mysql' using the following code I get the error as below:

mysql> insert into user values(
    -> 'localhost',
    -> 'phpuser',
    -> password('phppass'),
    -> 'n', 'n', 'n', 'n', 'n', 'n', 'n',
    -> 'n', 'n', 'n', 'n', 'n', 'n', 'n');
ERROR 1136: Column count doesn't match value count at row 1

I have tried this over and over again, checking my syntax etc. but still have the same problem, the only things that are different in my set up are:

1) The file my-example.cnf was not part of the set up - the only .cnf files that I have are - my-small.cnf, my-medium.cnf, my-large.cnf and my-huge.cnf, therefore I have not copied, renamed and paste into/as C:\my.cnf - I'm not sure if this is causing or going to cause any problems.

2) When using the DESC command to list the 'user' table structure I get a return of 31 rows in set (14 additional rows as below) -
| Show_db_priv
| Super_priv
| Create_tmp_table_priv
| Lock_tables_priv
| Execute_priv
| Repl_slave_priv
| Repl_client_priv
| ssl_type
| ssl_cipher
| x509_issuer
| x509_subject
| max_questions
| max_updates
| max_connections

Can someone please advise on where I may be going wrong on this, as I have since discovered that these initial steps are required in order for me to be able to continue with the 'try it outs' etc....

Many thanks

Jamal

Well, the error message suggests you're inserting the wrong number of columns.

If your user table has additional columns not created by the default installation of MySQL*, then you'll have to modify your query to either list the columns you're inserting into OR insert values for ALL columns in the user table.

1: INSERT INTO user (Host, User, Password) VALUES ('localhost', 'user', password('pass'));

2: INSERT INTO user ('localhost', 'user', ... all 31 columns here);


* The mysql.user table should have 17 columns, host, user, pass, the following yes/no permissions flags:
  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


Take care,

Nik
http://www.bigaction.org/