You guys probably need to start mysql with the --skip-grant option and fix the allow tables...
See the mysql.com website or google.com for "lost password" "mysql" -----Original Message----- From: Chee-Wai Yeung [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 5:09 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mysqladmin -u root -h myhost password 'new-password' fails Karl, yes, same problem here. Looking at the user table it seems the entry is there, but mysqladmin failed. I also attempted to set by hand the password using update table. The update succeeded, but then when I used mysql -u root -h <hostname> -p and typed in the password, mysql also denied access saying the access was denied. The problem does not exist in mysql 3.23.56. Any help appreciated. Thanks Chee Wai --- [EMAIL PROTECTED] wrote: > >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&r num=3 > http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=5bca2770813d0 016&rnum=6 > http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=8a5b663b86b43 73b&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] > ===== ~~~~~~~~~~~~~~ Chee-Wai Yeung Email: [EMAIL PROTECTED] __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
