>Description:
See attached log
>How-To-Repeat:
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Ray Bellis
>Organization: Community Internet plc
>MySQL support: none
>Synopsis: Can't login to server until access tables are flushed
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 7.11 Distrib 3.22.25, for dec-osf4.0e on
>alphaev56
TCX Datakonsult AB, by Monty
Server version 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 14 min 8 sec
Threads: 1 Questions: 340 Slow queries: 0 Opens: 35 Flush tables: 1 Open tables:
24 Queries per second avg: 0.401
>Environment:
System: OSF1 alpha05.community.net.uk V4.0 1229 alpha
Machine: alpha
Some paths: /usr/local/bin/perl /usr/bin/make /usr/gnu/bin/gmake /usr/gnu/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/gnu/lib/gcc-lib/alpha-dec-osf4.0f/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc -pthread -std1' CFLAGS='' CXX='cxx -pthread -O'
CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxr-xr-x 1 root system 17 Dec 13 1999 /lib/libc.a -> ../ccs/lib/libc.a
lrwxr-xr-x 1 root system 17 Dec 13 1999 /usr/lib/libc.a ->
../ccs/lib/libc.a
Configure command: ./configure '--with-named-thread-libs=-lpthread -lmach -lexc -lc'
--prefix=/usr/local/mysql --localstatedir=/mysql --with-berkeley-db
#
# Attempt to upgrade from MySQL 3.22.25 on one server to
# MySQL 3.23.36 on another.
#
# Platform: Compaq Tru64 UNIX 4.0F
# compiler flags: as per INSTALL-SOURCE
#
# All MySQL tables have been cleanly 'rsynced' from the original
# server to the new server.
#
# Problem: non-superusers cannot gain access to the new server unless
# the MySQL grant tables are 'touched' and then flushed.
# Subsequent access then seems to work OK
#
####
#### login to existing MySQL server
####
rpb@alpha01% mysql -halpha02 -uadmin -pXXXXXXXX admin
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 326425 to server version: 3.22.25
Type 'help' for help.
mysql> Bye
####
#### failed attempt to login to new MySQL server
####
rpb@alpha01% mysql -halpha05 -uadmin -pXXXXXXXX admin
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database
'admin'
####
#### mysqlaccess output
####
rpb@alpha01% /usr/local/mysql/bin/mysqlaccess -H alpha05 -h alpha01.community.net.uk
-p XXXXXXXX admin admin
mysqlaccess Version 2.03, 27 Feb 1997
By RUG-AIV, by Yves Carlier ([EMAIL PROTECTED])
This software comes with ABSOLUTELY NO WARRANTY.
+++USING FULL WHERE CLAUSE+++
+++USING FULL WHERE CLAUSE+++
+++USING FULL WHERE CLAUSE+++
Access-rights
for USER 'admin', from HOST 'alpha01.community.net.uk', to DB 'admin'
+-----------------+---+ +-----------------+---+
| Select_priv | Y | | Shutdown_priv | N |
| Insert_priv | Y | | Process_priv | N |
| Update_priv | Y | | File_priv | N |
| Delete_priv | Y | | Grant_priv | N |
| Create_priv | N | | References_priv | N |
| Drop_priv | N | | Index_priv | N |
| Reload_priv | N | | Alter_priv | N |
+-----------------+---+ +-----------------+---+
NOTE: A password is required for user `admin' :-(
The following rules are used:
db : '','admin','admin','Y','Y','Y','Y','N','N','N','N','N','N'
host : 'alpha01.community.net.uk','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y'
user :
'%','admin','XXXXXXXXXXXXXXXX','N','N','N','N','N','N','N','N','N','N','N','N','N','N'
BUGs can be reported by email to [EMAIL PROTECTED]
####
#### 'touch' the MySQL grant tables
####
rpb@alpha01% mysql -halpha05 mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.36
Type 'help' for help.
mysql> update user set host=host;
Query OK, 0 rows affected (0.02 sec)
Rows matched: 60 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> Bye
####
#### login to new MySQL server now works
####
rpb@alpha01% mysql -halpha05 -uadmin -pXXXXXXXX admin
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.36
Type 'help' for help.
mysql> Bye
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
