<html><div style='background-color:'><DIV class=RTE>
<P>Thanks again, yes, my output is different:</P>
<P>mysql> desc user;<BR>+-----------------------+-----------------------------------+------+-----+---------+-------+<BR>| Field | Type | Null | Key | Default | Extra |<BR>+-----------------------+-----------------------------------+------+-----+---------+-------+<BR>| Host | varchar(60) | | PRI |
| |<BR>| User | varchar(16) | | PRI | | |<BR>| Password | varchar(41) | | | | |<BR>| Select_priv |
enum('N','Y') | | | N | |<BR>| Insert_priv | enum('N','Y') | | | N | |<BR>| Update_priv | enum('N','Y') | | |
N | |<BR>| Delete_priv | enum('N','Y') | | | N | |<BR>| Create_priv | enum('N','Y') | | | N | |<BR>| Drop_priv |
enum('N','Y') | | | N | |<BR>| Reload_priv | enum('N','Y') | | | N | |<BR>| Shutdown_priv | enum('N','Y') | | |
N | |<BR>| Process_priv | enum('N','Y') | | | N | |<BR>| File_priv | enum('N','Y') | | | N | |<BR>| Grant_priv |
enum('N','Y') | | | N | |<BR>| References_priv | enum('N','Y') | | | N | |<BR>| Index_priv | enum('N','Y') | | |
N | |<BR>| Alter_priv | enum('N','Y') | | | N | |<BR>| Show_db_priv | enum('N','Y') | | | N | |<BR>| Super_priv |
enum('N','Y') | | | N | |<BR>| Create_tmp_table_priv | enum('N','Y') | | | N | |<BR>| Lock_tables_priv | enum('N','Y') | | | N |
|<BR>| Execute_priv | enum('N','Y') | | | N | |<BR>| Repl_slave_priv | enum('N','Y') | | | N | |<BR>| Repl_client_priv | enum('N','Y') |
| | N | |<BR>| ssl_type | enum('','ANY','X509','SPECIFIED') | | | | |<BR>| ssl_cipher | blob | | | | |<BR>| x509_issuer |
blob | | | | |<BR>| x509_subject | blob | | | | |<BR>| max_questions | int(11)
unsigned | | | 0 | |<BR>| max_updates | int(11) unsigned | | | 0 | |<BR>| max_connections | int(11) unsigned | | | 0 |
|<BR>+-----------------------+-----------------------------------+------+-----+---------+-------+<BR>31 rows in set (0.00 sec)<BR><BR></P><BR><BR><BR><BR>>hi,,<BR>>can u send me output of this<BR>><BR>>mysql<BR>>use mysql;<BR>>desc user;<BR>><BR>><BR>>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<BR>><BR>><BR>><BR>>mysql> desc user;<BR>>+-----------------+-----------------+------+-----+---------+-------+<BR>>| Field | Type | Null | Key | Default | Extra |<BR>>+-----------------+-----------------+------+-----+---------+-------+<BR>>| Host | char(60) binary
| | PRI | | |<BR>>| User | char(16) binary | | PRI | | |<BR>>| Password | char(16) binary | | | | |<BR>>| Select_priv | enum('N','Y') | | | N | |<BR>>| Insert_priv | enum('N','Y')
| | | N | |<BR>>| Update_priv | enum('N','Y') | | | N | |<BR>>| Delete_priv | enum('N','Y') | | | N | |<BR>>| Create_priv | enum('N','Y') | | | N | |<BR>>| Drop_priv | enum('N','Y')
| | | N | |<BR>>| Reload_priv | enum('N','Y') | | | N | |<BR>>| Shutdown_priv | enum('N','Y') | | | N | |<BR>>| Process_priv | enum('N','Y') | | | N | |<BR>>| File_priv | enum('N','Y')
| | | N | |<BR>>| Grant_priv | enum('N','Y') | | | N | |<BR>>| References_priv | enum('N','Y') | | | N | |<BR>>| Index_priv | enum('N','Y') | | | N | |<BR>>| Alter_priv | enum('N','Y')
| | | N | |<BR>>+-----------------+-----------------+------+-----+---------+-------+<BR>>17 rows in set (0.02 sec)<BR>><BR>><BR>>Llanos Serna García-Conde <llanosserna@hotmail.com> wrote:<BR>><BR>>Hi, thanks for your help. I did what you said but I get an error:<BR>><BR>><BR>>[root@pclabo mysql]# mysql<BR>>Welcome to the MySQL monitor. Commands end with ; or \g.<BR>>Your MySQL connection id is 1119 to server version: 4.1.9-standard<BR>>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<BR>>mysql> USE mysql;<BR>>Reading table information for completion of table and column names<BR>>You can turn off this feature to get a quicker startup with -A<BR>>Database
changed<BR>>mysql> delete from user where user='ser';<BR>>Query OK, 2 rows affected (0.11 sec)<BR>>mysql> INSERT INTO user VALUES('%','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>>ERROR 1136 (21S01): Column count doesn't match value count at row 1<BR>>mysql> INSERT INTO user VALUES('%','ser',PASSWORD('heslo'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>>ERROR 1136 (21S01): Column count doesn't match value count at row 1<BR>>mysql> INSERT INTO user VALUES('localhost','ser',PASSWORD('heslo'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>>ERROR 1136 (21S01): Column count doesn't match value count at row 1<BR>>mysql><BR>><BR>>I don't understand this error!! Please help,<BR>>Llanos<BR>><BR>> >hi,<BR>> >it seems the password or user profile problem<BR>>
><BR>> >do this<BR>> ><BR>> ><BR>> >USE mysql;<BR>> ><BR>> >delete from user where user='ser';<BR>> ><BR>> >( It will delete 2 records)<BR>> ><BR>> >Then insert agin ...............<BR>> ><BR>> ><BR>> ><BR>> >INSERT INTO user VALUES('%','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>> ><BR>> >INSERT INTO user VALUES('localhost','ser',PASSWORD('helso'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');<BR>> ><BR>> ><BR>> ><BR>> >FLUSH PRIVILEGES;<BR>> ><BR>> ><BR>> >Llanos Serna García-Conde <llanosserna@hotmail.com> wrote:<BR>> >Hi all, I'm trying to see the serweb logging screen but I get the following error:<BR>> ><BR>> >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<BR>> >Database error: pconnect(localhost, ser, $Password) failed.<BR>> >MySQL Error: ()<BR>> >Session halted.<BR>> ><BR>> >My Mysql version is 4.1.9.<BR>> ><BR>> >My /etc/hosts:<BR>> >127.0.0.1 pclabo localhost.localdomain localhost<BR>> >172.25.97.19 sipproxy.plczar.endesa.es sipproxy<BR>> ><BR>> >In ser_mysql.sh, db_mysql.inc and config.php:<BR>> >DBNAME ser<BR>> >DBHOST localhost<BR>> >USER ser<BR>> >PW heslo<BR>> ><BR>> >I can connect to the database in either of these
ways:<BR>> > > mysql -u ser -p<BR>> >Enter password: heslo<BR>> ><BR>> >or<BR>> ><BR>> > >mysql -h 172.25.97.19 -u ser -p<BR>> >Enter password: heslo<BR>> ><BR>> >From another machine I can also connect to the DB with the Mysql Query Browser:<BR>> >Server Host: 172.25.97.19<BR>> >Username: ser<BR>> >Password: heslo<BR>> ><BR>> >What's the problem? Any ideas?<BR>> >Thank you<BR>> >Llanos<BR>> ><BR>> >_______________________________________________<BR>> >Serusers mailing list<BR>> >serusers@lists.iptel.org<BR>> >http://lists.iptel.org/mailman/listinfo/serusers<BR>> ><BR>> ><BR>> >---------------------------------<BR>> >Yahoo! Mail Mobile<BR>> > Take Yahoo! Mail with you! Check email on your mobile
phone.<BR>><BR>><BR>><BR>><BR>>---------------------------------<BR>>Do you Yahoo!?<BR>> Yahoo! Mail - You care about security. So do we.<BR></DIV></div></html>