Thanks again, yes, my output is different:

mysql> desc user;
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Field                 | Type                              | Null | Key | Default | Extra |
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Host                  | varchar(60)                       |      | PRI |         |       |
| User                  | varchar(16)                       |      | PRI |         |       |
| Password              | varchar(41)                       |      |     |         |       |
| Select_priv           | enum('N','Y')                     |      |     | N       |       |
| Insert_priv           | enum('N','Y')                     |      |     | N       |       |
| Update_priv           | enum('N','Y')                     |      |     | N       |       |
| Delete_priv           | enum('N','Y')                     |      |     | N       |       |
| Create_priv           | enum('N','Y')                     |      |     | N       |       |
| Drop_priv             | enum('N','Y')                     |      |     | N       |       |
| Reload_priv           | enum('N','Y')                     |      |     | N       |       |
| Shutdown_priv         | enum('N','Y')                     |      |     | N       |       |
| Process_priv          | enum('N','Y')                     |      |     | N       |       |
| File_priv             | enum('N','Y')                     |      |     | N       |       |
| Grant_priv            | enum('N','Y')                     |      |     | N       |       |
| References_priv       | enum('N','Y')                     |      |     | N       |       |
| Index_priv            | enum('N','Y')                     |      |     | N       |       |
| Alter_priv            | enum('N','Y')                     |      |     | N       |       |
| Show_db_priv          | enum('N','Y')                     |      |     | N       |       |
| Super_priv            | enum('N','Y')                     |      |     | N       |       |
| Create_tmp_table_priv | enum('N','Y')                     |      |     | N       |       |
| Lock_tables_priv      | enum('N','Y')                     |      |     | N       |       |
| Execute_priv          | enum('N','Y')                     |      |     | N       |       |
| Repl_slave_priv       | enum('N','Y')                     |      |     | N       |       |
| Repl_client_priv      | enum('N','Y')                     |      |     | N       |       |
| ssl_type              | enum('','ANY','X509','SPECIFIED') |      |     |         |       |
| ssl_cipher            | blob                              |      |     |         |       |
| x509_issuer           | blob                              |      |     |         |       |
| x509_subject          | blob                              |      |     |         |       |
| max_questions         | int(11) unsigned                  |      |     | 0       |       |
| max_updates           | int(11) unsigned                  |      |     | 0       |       |
| max_connections       | int(11) unsigned                  |      |     | 0       |       |
+-----------------------+-----------------------------------+------+-----+---------+-------+
31 rows in set (0.00 sec)

>hi,,
>can u send me output of this
>
>mysql
>use mysql;
>desc user;
>
>
>As I have following output where it has 14 Grant column in this table.. seems you have some less or some extra in u r user table
>
>
>
>mysql> desc user;
>+-----------------+-----------------+------+-----+---------+-------+
>| Field           | Type            | Null | Key | Default | Extra |
>+-----------------+-----------------+------+-----+---------+-------+
>| Host            | char(60) binary |      | PRI |         |       |
>| User            | char(16) binary |      | PRI |         |       |
>| Password        | char(16) binary |      |     |         |       |
>| Select_priv     | enum('N','Y')   |      |     | N       |       |
>| Insert_priv     | enum('N','Y')   |      |     | N       |       |
>| Update_priv     | enum('N','Y')   |      |     | N       |       |
>| Delete_priv     | enum('N','Y')   |      |     | N       |       |
>| Create_priv     | enum('N','Y')   |      |     | N       |       |
>| Drop_priv       | enum('N','Y')   |      |     | N       |       |
>| Reload_priv     | enum('N','Y')   |      |     | N       |       |
>| Shutdown_priv   | enum('N','Y')   |      |     | N       |       |
>| Process_priv    | enum('N','Y')   |      |     | N       |       |
>| File_priv       | enum('N','Y')   |      |     | N       |       |
>| Grant_priv      | enum('N','Y')   |      |     | N       |       |
>| References_priv | enum('N','Y')   |      |     | N       |       |
>| Index_priv      | enum('N','Y')   |      |     | N       |       |
>| Alter_priv      | enum('N','Y')   |      |     | N       |       |
>+-----------------+-----------------+------+-----+---------+-------+
>17 rows in set (0.02 sec)
>
>
>Llanos Serna García-Conde <llanosserna@hotmail.com> wrote:
>
>Hi, thanks for your help. I did what you said but I get an error:
>
>
>[root@pclabo mysql]# mysql
>Welcome to the MySQL monitor.  Commands end with ; or \g.
>Your MySQL connection id is 1119 to server version: 4.1.9-standard
>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>mysql> USE mysql;
>Reading table information for completion of table and column names
>You can turn off this feature to get a quicker startup with -A
>Database changed
>mysql> delete from user where user='ser';
>Query OK, 2 rows affected (0.11 sec)
>mysql> INSERT INTO user VALUES('%','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>ERROR 1136 (21S01): Column count doesn't match value count at row 1
>mysql> INSERT INTO user VALUES('%','ser',PASSWORD('heslo'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>ERROR 1136 (21S01): Column count doesn't match value count at row 1
>mysql> INSERT INTO user VALUES('localhost','ser',PASSWORD('heslo'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>ERROR 1136 (21S01): Column count doesn't match value count at row 1
>mysql>
>
>I don't understand this error!! Please help,
>Llanos
>
> >hi,
> >it seems the password or user profile problem
> >
> >do this
> >
> >
> >USE mysql;
> >
> >delete from user where user='ser';
> >
> >( It will delete 2 records)
> >
> >Then insert agin ...............
> >
> >
> >
> >INSERT INTO user VALUES('%','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
> >
> >INSERT INTO user VALUES('localhost','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
> >
> >
> >
> >FLUSH PRIVILEGES;
> >
> >
> >Llanos Serna García-Conde <llanosserna@hotmail.com> wrote:
> >Hi all, I'm trying to see the serweb logging screen but I get the following error:
> >
> >Warning: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/www/html/serweb/serweb_2004-07-27/phplib/db_mysql.inc on line 73
> >Database error: pconnect(localhost, ser, $Password) failed.
> >MySQL Error: ()
> >Session halted.
> >
> >My Mysql version is 4.1.9.
> >
> >My /etc/hosts:
> >127.0.0.1               pclabo localhost.localdomain localhost
> >172.25.97.19            sipproxy.plczar.endesa.es       sipproxy
> >
> >In ser_mysql.sh, db_mysql.inc and config.php:
> >DBNAME ser
> >DBHOST localhost
> >USER ser
> >PW heslo
> >
> >I can connect to the database in either of these ways:
> > > mysql -u ser -p
> >Enter password: heslo
> >
> >or
> >
> > >mysql -h 172.25.97.19 -u ser -p
> >Enter password: heslo
> >
> >From another machine I can also connect to the DB with the Mysql Query Browser:
> >Server Host: 172.25.97.19
> >Username: ser
> >Password: heslo
> >
> >What's the problem? Any ideas?
> >Thank you
> >Llanos
> >
> >_______________________________________________
> >Serusers mailing list
> >serusers@lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
> >
> >
> >---------------------------------
> >Yahoo! Mail Mobile
> >  Take Yahoo! Mail with you! Check email on your mobile phone.
>
>
>
>
>---------------------------------
>Do you Yahoo!?
>  Yahoo! Mail - You care about security. So do we.