Web lists-archives.com

Re: how can i login without a password although in the user-table is a password ?




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