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=FCr Entwicklungsgenetik
Geb=E4ude 35.34 - Raum 208
HelmholtzZentrum m=FCnchen
bernd.lentes@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=FCnchen
Deutsches Forschungszentrum f=FCr Gesundheit und Umwelt (GmbH)
Ingolst=E4dter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir=B4in B=E4rbel Brumme-Bothe
Gesch=E4ftsf=FChrer: Prof. Dr. G=FCnther Wess, Dr. Nikolaus Blum, Dr. Alfons Enhsen
Registergericht: Amtsgericht M=FCnchen 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