Hi, this is my system:
mysql> status -------------- mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1 Connection id: 142883 Current database: mysql Current user: root@localhost SSL: Not in use Current pager: less Using outfile: '' Using delimiter: ; Server version: 5.0.26-Max-log Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 223 days 22 hours 38 min 49 sec Threads: 1 Questions: 9178423 Slow queries: 99 Opens: 607644 Flush tables: 3 Open tables: 64 Queries per second avg: 0.474 my user-table looks like this: mysql> select host,user,password from user; +----------------+------+-------------------------------------------+ | host | user | password | +----------------+------+-------------------------------------------+ | localhost | root | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 | | pc52974.gsf.de | root | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 | | pc52974.gsf.de | | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 | | localhost | | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 | | % | root | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 | | 127.0.0.1 | root | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 | +----------------+------+-------------------------------------------+ I know that this is not the best solution, I will change it. Using mysql on a Linux-system I can login with "mysql -u root" without supplying a password. How is this possible although there is a password for each user and for root in the user-table ? Thanks in advance. Bernd -- Bernd Lentes Systemadministration Institut für Entwicklungsgenetik Gebäude 35.34 - Raum 208 HelmholtzZentrum münchen bernd.len...@helmholtz-muenchen.de phone: +49 89 3187 1241 fax: +49 89 3187 2294 http://www.helmholtz-muenchen.de/idg Je suis Charlie Helmholtz Zentrum München Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH) Ingolstädter Landstr. 1 85764 Neuherberg www.helmholtz-muenchen.de Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe Geschäftsführer: Prof. Dr. Günther Wess, Dr. Nikolaus Blum, Dr. Alfons Enhsen Registergericht: Amtsgericht München HRB 6466 USt-IdNr: DE 129521671 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
