[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.