List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni - TomTom Date:October 9 2008 8:56pm
Subject:Re: Cannot login into mysql server
View as plain text  
Try using the  '-h localhost' flag,

shell>mysqladmin -u root -h localhost -p


Aloha
Claudio

> SEND-PR: -*- send-pr -*-
> SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
> SEND-PR: will all comments (text enclosed in `<' and `>').
> SEND-PR:
> From: dimand.parminex@stripped
> To: mysql@stripped
> Subject: Cannot  login into mysql server
>
>   
>> Description:
>>     
>     After starting the server, logged as root into terminal, with
>     the command 'shell> mysqld_safe --user=mysql &' I receive the
>     message: Starting mysql deamon with databases from /usr/local/mysql/var
>         I cannot connect to it, however, using shell>mysql command.
>         It gives me the following message:shell>"Error 1045 (28000): Access
>     denied for user 'root'@'localhost' (using password: NO)"
>       
>         When I try to login using command:shell>mysql --user=root
>         --password=my_password
>         I receive the same message:shell>"Error 1045 (28000): Access
>     denied for user 'root'@'localhost' (using password: YES)"
>
>         When I try to set the password using: shell>mysqladmin --user=root
>         password my_password, I receive message: shell>mysqladmin: connect
>         to server at 'localhost' failed
>         error:  'Access denied for user 'root'@'localhost' (using
>         password: NO)'
>
> I stopped the server with shell>"kill 'cat host.localdomain.pid' and
> re-started it with: shell>mysqld_safe --user=mysql
> --skip-grant-tables & and tried to reset the root user password:
>
> shell>mysql
> mysql> FLUSH PRIVILEGES;
> Query OK, 0 rows affected (0.01 sec)
> mysql>UPDATE mysql.user SET Password = PASSWORD('new_password') WHERE
> user = 'root';
> Query OK, 0 rows affected (0.02 sec)
> mysql> FLUSH PRIVILEGES;
> mysql> QUIT
>
> Then I stop the server again and restart it without the
> --skip-grant-tables option:
>
> 'shell> mysqld_safe --user=mysql &'
>
> I try to connect to the server again using the new password:
> shell>mysql --user=root --password='my_new_password'
>
> and again receive the same message:
> shell>"Error 1045 (28000): Access denied for user 'root'@'localhost'
> (using password: YES)"
>
> Then I killed the server again and restarted it once more with the
> --skip-grant-tables option.
>
> I connected to the server and tried querying the mysql database:
>
> mysql>use mysql;
> Database changed
>
> mysql> SHOW DATABASES;
>
> +---------------------+
> | Database             |
> +---------------------+
> | information_schema  |
> | mysql               |
> | test                |
> +---------------------+
>
> 3 rows in set (0.20 sec)
>
>
> mysql> SHOW TABLES;
>
> +---------------------------+
> | Tables_in_mysql           |
> +---------------------------+
> | columns_priv              |
> | db                        |
> | func                      |
> | help_category             |
> | help_keyword              |
> | help_relation             |
> | help_topic                |
> | host                      |
> | proc                      |
> | proc_priv                 |
> | tables_priv               |
> | time_zone                 |
> | time_zone_leap_second     |
> | time_zone_name            |
> | time_zone_transition      |
> | time_zone_transition_type |
> | user                      |
> +---------------------------+
> 17 rows in set (0.10 sec)
>
> mysql> SELECT * FROM user;
> Empty set (0.01 sec)
>
> mysql> SELECT * FROM host;
>
> Empty set (0.00 sec)
>
> Only querying tables help_*
> gives unempty sets.
>
> In my data directory /usr/local/mysql/var/mysql
> only the files help_*.MYD are not empty.
> All the other files *.MYD are of 0 size.
>
>
>
>
>   
>> How-To-Repeat:
>>     
>     Go through all of the above steps again
>   
>> Fix:
>>     
>     Tried everything suggested by manuals and on on-line forums,
> checking file permissions, re-setting root passwords, etc.
> Nothing's changed.
> It appears that most tables in the mysql database are empty and
> there are no users at all.
>
> Installed the server and client from source.
>
> Thanks for any help.
>
> dimand.
>
>   
>> Submitter-Id:    dimand
>> Originator:    root
>> Organization:
>>     
>  <organization of PR author (multiple lines)>
>   
>> MySQL support: [none | licence | email support | extended email support ]
>> Synopsis:    <synopsis of the problem (one line)>
>> Severity:    <[ non-critical | serious | critical ] (one line)>
>> Priority:    <[ low | medium | high ] (one line)>
>> Category:    mysql
>> Class:        <[ sw-bug | doc-bug | change-request | support ] (one line)>
>> Release:    mysql-5.0.67 (Source distribution)
>> Server: /usr/local/mysql/bin/mysqladmin  Ver 8.41 Distrib 5.0.67, for
>>     
> redhat-linux-gnu on i686
> Copyright (C) 2000-2006 MySQL AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version        5.0.67-log
> Protocol version    10
> Connection        Localhost via UNIX socket
> UNIX socket        /tmp/mysql.sock
> Uptime:            27 sec
>
> Threads: 2  Questions: 2  Slow queries: 0  Opens: 5  Flush tables: 1 
> Open tables: 0  Queries per second avg: 0.074
>   
>> C compiler:    gcc (GCC) 4.1.1 20060724 (prerelease) (4.1.1-3mdk)
>> C++ compiler:  g++ (GCC) 4.1.1 20060724 (prerelease) (4.1.1-3mdk)
>> Environment:
>>     
>     <machine, os, target, libraries (multiple lines)>
> System: Linux maincard.localdomain 2.6.17-5mdv #1 SMP Wed Sep 13
> 14:32:31 EDT 2006 i686 Pentium III (Katmai) GNU/Linux
> Architecture: i686
>
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Using built-in specs.
> Target: i586-mandriva-linux-gnu
> Configured with: ../configure --prefix=/usr --libexecdir=/usr/lib
> --with-slibdir=/lib --mandir=/usr/share/man --infodir=/usr/share/info
> --enable-shared --enable-threads=posix --enable-checking=release
> --enable-languages=c,c++,ada,fortran,objc,obj-c++,java
> --host=i586-mandriva-linux-gnu --with-cpu=generic --with-system-zlib
> --enable-long-long --enable-__cxa_atexit --enable-clocale=gnu
> --disable-libunwind-exceptions --enable-java-awt=gtk
> --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
> --enable-gtk-cairo --enable-ssp --disable-libssp
> Thread model: posix
> gcc version 4.1.1 20060724 (prerelease) (4.1.1-3mdk)
> Compilation info (call): CC=''  CFLAGS=''  CXX=''  CXXFLAGS='' 
> LDFLAGS=''  ASFLAGS=''
> Compilation info (used): CC='gcc'  CFLAGS='-O3 -DDBUG_OFF   ' 
> CXX='g++'  CXXFLAGS='-O3 -DDBUG_OFF    -fno-implicit-templates
> -fno-exceptions -fno-rtti'  LDFLAGS=' -rdynamic '  ASFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 11 Aug 14  2007 /lib/libc.so.6 -> libc-2.4.so
> -rwxr-xr-x 1 root root 1195524 Mar  7  2007 /lib/libc-2.4.so
> -rw-r--r-- 1 root root 238 Mar  7  2007 /usr/lib/libc.so
> Configure command: ./configure '--prefix=/usr/local/mysql'
>
>
>
>   

Thread
Cannot login into mysql serverdimand9 Oct
  • Re: Cannot login into mysql serverClaudio Nanni - TomTom9 Oct