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: [EMAIL PROTECTED]
To: mysql@lists.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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
