Bernd wrote: > a password ? > > 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 ? > > I found it out by myself: I have a .my.cnf in my home-directory. I forgot.
Bernd 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