From: Claudio Nanni - TomTom (claudio.nannigmail.com)
Date: Thu Oct 09 2008 - 15:56:40 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.parminexverizon.net
> To: mysqllists.mysql.com
> 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'
>
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]