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(
-> '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) -
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....