Hi, On 4/11/07, Christian Hammers <[EMAIL PROTECTED]> wrote:
severity 418672 normal
Why?
tags 418672 - security
Why?
Those hex numbers translate to 'localhost', 'root' and '127.0.0.1' and there are no quotes around them so I guess you set some special options to have them displayed in such a strange way?
Yes, I used phpMyAdmin - Export.
Anyway, I cannot reproduce a reset of the users passwords during a mysql upgrade or "dpkg --reconfigure mysql-server-5.0". Can you try to reproduce it yourself?
Sure.
Also, please check against your backups and /var/log/mysql/ that you *really* had a password set.
I'm quite sure, I noticed the 'behaviour' on three different systems. mysql.err and mysql.log are empty and /var/log/mysql/ only contains binary logs.
Are there other rows in the user table? Maybe some with a set password and some without?
No, all had a password. debian:~# apt-get install mysql-server-5.0 Reading package lists... Done Building dependency tree... Done The following extra packages will be installed: libdbd-mysql-perl libdbi-perl libmysqlclient15off libnet-daemon-perl libplrpc-perl mysql-client-5.0 mysql-common psmisc Suggested packages: dbishell libcompress-zlib-perl tinyca Recommended packages: mailx The following NEW packages will be installed: libdbd-mysql-perl libdbi-perl libmysqlclient15off libnet-daemon-perl libplrpc-perl mysql-client-5.0 mysql-common mysql-server-5.0 psmisc 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. Need to get 35.1MB/35.2MB of archives. After unpacking 92.1MB of additional disk space will be used. Do you want to continue [Y/n]? Get:1 http://ftp.surfnet.nl etch/main mysql-common 5.0.32-7etch1 [52.9kB] Get:2 http://ftp.surfnet.nl etch/main libnet-daemon-perl 0.38-1.1 [45.8kB] Get:3 http://ftp.surfnet.nl etch/main libplrpc-perl 0.2017-1.1 [34.9kB] Get:4 http://ftp.surfnet.nl etch/main libdbi-perl 1.53-1 [647kB] Get:5 http://ftp.surfnet.nl etch/main libmysqlclient15off 5.0.32-7etch1 [1791kB] Get:6 http://ftp.surfnet.nl etch/main libdbd-mysql-perl 3.0008-1 [140kB] Get:7 http://ftp.surfnet.nl etch/main mysql-client-5.0 5.0.32-7etch1 [7193kB] Get:8 http://ftp.surfnet.nl etch/main mysql-server-5.0 5.0.32-7etch1 [25.2MB] Fetched 35.1MB in 2m21s (248kB/s) Preconfiguring packages ... Selecting previously deselected package mysql-common. (Reading database ... 13005 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.0.32-7etch1_all.deb) ... Selecting previously deselected package libnet-daemon-perl. Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1.1_all.deb) ... Selecting previously deselected package libplrpc-perl. Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1.1_all.deb) ... Selecting previously deselected package libdbi-perl. Unpacking libdbi-perl (from .../libdbi-perl_1.53-1_i386.deb) ... Selecting previously deselected package libmysqlclient15off. Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.32-7etch1_i386.deb) ... Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_3.0008-1_i386.deb) ... Selecting previously deselected package mysql-client-5.0. Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.32-7etch1_i386.deb) ... Selecting previously deselected package psmisc. Unpacking psmisc (from .../psmisc/psmisc_22.3-1_i386.deb) ... Setting up mysql-common (5.0.32-7etch1) ... Selecting previously deselected package mysql-server-5.0. (Reading database ... 13255 files and directories currently installed.) Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.32-7etch1_i386.deb) ... Setting up libnet-daemon-perl (0.38-1.1) ... Setting up libplrpc-perl (0.2017-1.1) ... Setting up libdbi-perl (1.53-1) ... Setting up libmysqlclient15off (5.0.32-7etch1) ... Setting up libdbd-mysql-perl (3.0008-1) ... Setting up mysql-client-5.0 (5.0.32-7etch1) ... Setting up psmisc (22.3-1) ... Setting up mysql-server-5.0 (5.0.32-7etch1) ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables.. debian:~# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from mysql.user; +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | Host | User | Password | 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 | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | debian | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | localhost | debian-sys-maint | *BA1EC5FB0A0C9E3AEA76EFA61D3C7225A3B978BF | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ 3 rows in set (0.00 sec) mysql> delete from mysql.user where host = 'debian'; Query OK, 1 row affected (0.00 sec) mysql> update mysql.user set host = '%', password = password('1234') where user = 'root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye debian:~# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) debian:~# mysql -p1234 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> exit Bye debian:~# mysql -p1234 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from mysql.user; +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | Host | User | Password | 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 | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | % | root | *A4B6157319038724E3560894F7F932C8886EBFCF | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | localhost | debian-sys-maint | *BA1EC5FB0A0C9E3AEA76EFA61D3C7225A3B978BF | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ 2 rows in set (0.01 sec) mysql> exit Bye debian:~# vi /etc/apt/sources.list (etch -> testing) debian:~# apt-get update Get:1 ftp://ftp.de.debian.org testing Release.gpg [189B] Get:2 ftp://ftp.de.debian.org testing Release [68.5kB] Get:3 ftp://ftp.de.debian.org testing/main Packages [5866kB] Fetched 5935kB in 24s (241kB/s) Reading package lists... Done debian:~# apt-get upgrade Reading package lists... Done Building dependency tree... Done The following packages will be upgraded: acpid base-files debconf debconf-i18n debconf-utils debianutils findutils gzip klogd libacl1 libattr1 libedit2 libgpg-error0 libkrb53 libldap2 libmysqlclient15off libsepol1 manpages mysql-client-5.0 mysql-common mysql-server-5.0 netcat sysklogd tzdata vim-common vim-tiny 26 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 37.9MB of archives. After unpacking 963kB of additional disk space will be used. Do you want to continue [Y/n]? Get:1 ftp://ftp.de.debian.org testing/main debianutils 2.18 [52.1kB] Get:2 ftp://ftp.de.debian.org testing/main findutils 4.2.28-2 [351kB] Get:3 ftp://ftp.de.debian.org testing/main gzip 1.3.9-2 [75.7kB] Get:4 ftp://ftp.de.debian.org testing/main base-files 4.0 [34.5kB] Get:5 ftp://ftp.de.debian.org testing/main debconf-i18n 1.5.13 [151kB] Get:6 ftp://ftp.de.debian.org testing/main debconf 1.5.13 [148kB] Get:7 ftp://ftp.de.debian.org testing/main mysql-common 5.0.38-1 [53.3kB] Get:8 ftp://ftp.de.debian.org testing/main libmysqlclient15off 5.0.38-1 [1796kB] Get:9 ftp://ftp.de.debian.org testing/main mysql-client-5.0 5.0.38-1 [7232kB] Get:10 ftp://ftp.de.debian.org testing/main mysql-server-5.0 5.0.38-1 [25.4MB] Get:11 ftp://ftp.de.debian.org testing/main libattr1 1:2.4.32-1.1 [9144B] Get:12 ftp://ftp.de.debian.org testing/main libacl1 2.2.42-1 [15.1kB] Get:13 ftp://ftp.de.debian.org testing/main libsepol1 1.14-3 [114kB] Get:14 ftp://ftp.de.debian.org testing/main tzdata 2007d-1 [354kB] Get:15 ftp://ftp.de.debian.org testing/main sysklogd 1.4.1-20 [58.3kB] Get:16 ftp://ftp.de.debian.org testing/main klogd 1.4.1-20 [39.4kB] Get:17 ftp://ftp.de.debian.org testing/main libgpg-error0 1.4-2 [34.6kB] Get:18 ftp://ftp.de.debian.org testing/main libldap2 2.1.30-13.4 [151kB] Get:19 ftp://ftp.de.debian.org testing/main manpages 2.43-0 [490kB] Get:20 ftp://ftp.de.debian.org testing/main netcat 1.10-33 [66.6kB] Get:21 ftp://ftp.de.debian.org testing/main vim-tiny 1:7.0-219+1 [542kB] Get:22 ftp://ftp.de.debian.org testing/main vim-common 1:7.0-219+1 [209kB] Get:23 ftp://ftp.de.debian.org testing/main libkrb53 1.4.4-8 [408kB] Get:24 ftp://ftp.de.debian.org testing/main acpid 1.0.4-7.1 [26.3kB] Get:25 ftp://ftp.de.debian.org testing/main debconf-utils 1.5.13 [40.8kB] Get:26 ftp://ftp.de.debian.org testing/main libedit2 2.9.cvs.20050518-3 [55.8kB] Fetched 37.9MB in 2m4s (305kB/s) Preconfiguring packages ... (Reading database ... 14806 files and directories currently installed.) Preparing to replace debianutils 2.17 (using .../debianutils_2.18_i386.deb) ... Unpacking replacement debianutils ... Setting up debianutils (2.18) ... (Reading database ... 14806 files and directories currently installed.) Preparing to replace findutils 4.2.28-1 (using .../findutils_4.2.28-2_i386.deb) ... Unpacking replacement findutils ... Setting up findutils (4.2.28-2) ... (Reading database ... 14806 files and directories currently installed.) Preparing to replace gzip 1.3.5-15 (using .../archives/gzip_1.3.9-2_i386.deb) ... Unpacking replacement gzip ... Setting up gzip (1.3.9-2) ... (Reading database ... 14806 files and directories currently installed.) Preparing to replace base-files 4 (using .../base-files_4.0_i386.deb) ... Unpacking replacement base-files ... Setting up base-files (4.0) ... Installing new version of config file /etc/debian_version ... Installing new version of config file /etc/issue ... Installing new version of config file /etc/issue.net ... (Reading database ... 14806 files and directories currently installed.) Preparing to replace debconf-i18n 1.5.11 (using .../debconf-i18n_1.5.13_all.deb) ... Unpacking replacement debconf-i18n ... Preparing to replace debconf 1.5.11 (using .../debconf_1.5.13_all.deb) ... Unpacking replacement debconf ... Preparing to replace mysql-common 5.0.32-7etch1 (using .../mysql-common_5.0.38-1_all.deb) ... Unpacking replacement mysql-common ... Preparing to replace libmysqlclient15off 5.0.32-7etch1 (using .../libmysqlclient15off_5.0.38-1_i386.deb) ... Unpacking replacement libmysqlclient15off ... Preparing to replace mysql-client-5.0 5.0.32-7etch1 (using .../mysql-client-5.0_5.0.38-1_i386.deb) ... Unpacking replacement mysql-client-5.0 ... Setting up mysql-common (5.0.38-1) ... (Reading database ... 14806 files and directories currently installed.) Preparing to replace mysql-server-5.0 5.0.32-7etch1 (using .../mysql-server-5.0_5.0.38-1_i386.deb) ... Stopping MySQL database server: mysqld. Stopping MySQL database server: mysqld. Unpacking replacement mysql-server-5.0 ... Preparing to replace libattr1 2.4.32-1 (using .../libattr1_1%3a2.4.32-1.1_i386.deb) ... Unpacking replacement libattr1 ... Preparing to replace libacl1 2.2.41-1 (using .../libacl1_2.2.42-1_i386.deb) ... Unpacking replacement libacl1 ... Setting up libattr1 (2.4.32-1.1) ... Setting up libacl1 (2.2.42-1) ... (Reading database ... 14847 files and directories currently installed.) Preparing to replace libsepol1 1.14-2 (using .../libsepol1_1.14-3_i386.deb) ... Unpacking replacement libsepol1 ... Setting up libsepol1 (1.14-3) ... (Reading database ... 14847 files and directories currently installed.) Preparing to replace tzdata 2007b-1 (using .../tzdata_2007d-1_all.deb) ... Unpacking replacement tzdata ... Setting up tzdata (2007d-1) ... Current default timezone: 'Europe/Amsterdam'. Local time is now: Wed Apr 11 23:00:49 CEST 2007. Universal Time is now: Wed Apr 11 21:00:49 UTC 2007. Run 'tzconfig' if you wish to change it. (Reading database ... 14853 files and directories currently installed.) Preparing to replace sysklogd 1.4.1-18 (using .../sysklogd_1.4.1-20_i386.deb) ... Unpacking replacement sysklogd ... Preparing to replace klogd 1.4.1-18 (using .../klogd_1.4.1-20_i386.deb) ... Unpacking replacement klogd ... Preparing to replace libgpg-error0 1.4-1 (using .../libgpg-error0_1.4-2_i386.deb) ... Unpacking replacement libgpg-error0 ... Preparing to replace libldap2 2.1.30-13.3 (using .../libldap2_2.1.30-13.4_i386.deb) ... Unpacking replacement libldap2 ... Preparing to replace manpages 2.39-1 (using .../manpages_2.43-0_all.deb) ... Unpacking replacement manpages ... Preparing to replace netcat 1.10-32 (using .../netcat_1.10-33_i386.deb) ... Unpacking replacement netcat ... Preparing to replace vim-tiny 1:7.0-122+1etch2 (using .../vim-tiny_1%3a7.0-219+1_i386.deb) ... Unpacking replacement vim-tiny ... Preparing to replace vim-common 1:7.0-122+1etch2 (using .../vim-common_1%3a7.0-219+1_i386.deb) ... Unpacking replacement vim-common ... Preparing to replace libkrb53 1.4.4-7etch1 (using .../libkrb53_1.4.4-8_i386.deb) ... Unpacking replacement libkrb53 ... Preparing to replace acpid 1.0.4-5 (using .../acpid_1.0.4-7.1_i386.deb) ... Stopping Advanced Configuration and Power Interface daemon: acpid. Unpacking replacement acpid ... dpkg: warning - unable to delete old directory `/etc/acpi/events': Directory not empty dpkg: warning - unable to delete old directory `/etc/acpi': Directory not empty Preparing to replace debconf-utils 1.5.11 (using .../debconf-utils_1.5.13_all.deb) ... Unpacking replacement debconf-utils ... Preparing to replace libedit2 2.9.cvs.20050518-2.2 (using .../libedit2_2.9.cvs.20050518-3_i386.deb) ... Unpacking replacement libedit2 ... Setting up libmysqlclient15off (5.0.38-1) ... Setting up mysql-client-5.0 (5.0.38-1) ... Setting up libgpg-error0 (1.4-2) ... Setting up libldap2 (2.1.30-13.4) ... Setting up manpages (2.43-0) ... Setting up netcat (1.10-33) ... Setting up vim-common (7.0-219+1) ... Setting up vim-tiny (7.0-219+1) ... Setting up libkrb53 (1.4.4-8) ... Setting up acpid (1.0.4-7.1) ... Installing new version of config file /etc/init.d/acpid ... Installing new version of config file /etc/logrotate.d/acpid ... Loading ACPI modules.... Starting Advanced Configuration and Power Interface daemon.... Setting up libedit2 (2.9.cvs.20050518-3) ... Setting up klogd (1.4.1-20) ... Installing new version of config file /etc/init.d/klogd ... Stopping kernel log daemon.... Starting kernel log daemon.... Setting up sysklogd (1.4.1-20) ... Installing new version of config file /etc/init.d/sysklogd ... Installing new version of config file /etc/cron.daily/sysklogd ... Stopping system log daemon.... Starting system log daemon.... Setting up debconf-i18n (1.5.13) ... Setting up debconf (1.5.13) ... Setting up mysql-server-5.0 (5.0.38-1) ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables.. Setting up debconf-utils (1.5.13) ... debian:~# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.38-Debian_1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from mysql.user; +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | Host | User | Password | 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 | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | % | root | *A4B6157319038724E3560894F7F932C8886EBFCF | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | localhost | debian-sys-maint | *BA1EC5FB0A0C9E3AEA76EFA61D3C7225A3B978BF | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | debian | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | 127.0.0.1 | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ 5 rows in set (0.00 sec) mysql> exit Bye debian:~# -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]