>Description:
I installed the 4.0.12-max binary distribution for x86-linux (got the
same behavior with -standard). This was a brand new installation. When
I ran scripts/mysql_install_db, it tells me:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h tug.org password 'new-password'
See the manual for more instructions.
The first command, without the -h, worked fine, and indeed I must type
password now when I say mysqladmin -u root or -u root -h localhost.
However, the second command, with the -h tug.org, fails, with the error
message
mysqladmin: unable to change password; error: 'Can't find any matching row in the
user table'
More importantly, I can still run commands like
mysqladmin -u root -h tug.org variables
without being asked for a password. (By the way, I suggest adding this
test to the other ones listed in the `General security' node.)
When I inspected the user table as explained in the manual,
there are lines for both localhost and tug.org, and only the localhost
line has a password (which I've x'd it below):
mysql> select Host,User,Password from mysql.user WHERE User='root';
+-----------+------+------------------+
| Host | User | Password |
+-----------+------+------------------+
| localhost | root | xxxxxxxxxxxxxxxx |
| tug.org | root | |
+-----------+------+------------------+
So I looked in the manual, but found no information on this error. I
also tried searching the mailing lists at lists.mysql.com with no luck,
although searching was so slow I couldn't be as thorough as I would
liked to have been. I also searched for this on google[/groups] with no
results, but found (not surprisingly) a number of other people reporting
the exact same problem:
http://groups.google.com/groups?q=mysqladmin+%22find+any+matching+row%22&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=alig93%242t8e%241%40FreeBSD.csie.NCTU.edu.tw&rnum=3
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=5bca2770813d0016&rnum=6
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=8a5b663b86b4373b&rnum=4
I expect I could explicitly set the password for [EMAIL PROTECTED] with set
password. But the point is that the mysql_install_db script is telling
me to do something that doesn't work.
Any help appreciated ...
>How-To-Repeat:
... follow INSTALL-BINARY instructions and: ...
root# mysqladmin -u root -h tug.org password mynewpassword
mysqladmin: unable to change password; error: 'Can't find any matching row in the
user table'
>Submitter-Id: <submitter ID>
>Originator: Karl Berry
>Organization:
>MySQL support: none
>Synopsis: mysqladmin -u root -h myhost password 'new-password' fails
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.12-max (Official MySQL-max binary)
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult 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 4.0.12-max-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 37 min 7 sec
Threads: 1 Questions: 52 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1
Queries per second avg: 0.023
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux tug.org 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='-O2 -mpentiumpro -DBIG_TABLES' CXX='gcc'
CXXFLAGS='-O2 -mpentiumpro -felide-constructors -DBIG_TABLES' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Aug 14 2002 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 2 root root 1285884 Aug 7 2002 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27336078 Aug 7 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Aug 7 2002 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official
MySQL-max binary' '--with-extra-charsets=complex' '--with-server-suffix=-max'
'--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler'
'--disable-shared' '--with-berkeley-db' '--with-raid' '--with-innodb' 'CFLAGS=-O2
-mpentiumpro -DBIG_TABLES' 'CXXFLAGS=-O2 -mpentiumpro -felide-constructors
-DBIG_TABLES' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
