>Description:
When I start up mysqld (4.1.0-alpha), I get the message in the
error log:
mysql.user table is not updated to new password format: Disabling new password
usage until mysql_fix_privilege_tables is run
I *HAVE* run mysql_fix_privilege_tables. At least 4 times.
I have a whole bunch of privilege columns including super_priv.
Every time I run it it corrupts the (select-only web server) users
I created since upgrading (from 3.23.56 to 4.1.0-alpha) by
handing out privileges I don't want these users to have, like
CREATE TEMPORARY TABLES.
What's the point of SHOW PRIVILEGES? There are a lot of privilege
columns in mysql.user that don't show in SHOW PRIVILEGES, yet
I can grant them and display them in SHOW GRANTS FOR ... .
I thought it was to keep the list of privileges in sync with
what the server actually supports?
>How-To-Repeat:
Start mysqld.
Get warning message.
Run mysql_fix_privilege_tables.
Repeat ad nauseum.
>Fix:
Is the mysql_fix_privilege_tables that came with 4.1.0-alpha
really up to date?
>Submitter-Id: <submitter ID>
>Originator: Gordon Burditt
>Organization:
>MySQL support: none [none | licence | email support | extended email support ]
>Synopsis: mysql_fix_privilege_tables doesn't fix the privilege tables
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.0-alpha (FreeBSD port: mysql-server-4.1.0_1)
>Server: /usr/local/bin/mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for
>portbld-freebsd4.7 on i386
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.1.0-alpha-log
Protocol version 10
Connection mysql.burditt.org via TCP/IP
TCP port 3306
Uptime: 2 hours 25 min 6 sec
Threads: 1 Questions: 385428 Slow queries: 7 Opens: 35 Flush tables: 1 Open
tables: 29 Queries per second avg: 44.272
>C compiler: 2.95.4
>C++ compiler: 2.95.4
>Environment:
System: FreeBSD hammy.lonestar.org 4.7-RELEASE FreeBSD 4.7-RELEASE #1: Wed Feb 19
01:29:17 CST 2003 [EMAIL PROTECTED]:/scratch5/i386-obj/usr/src/sys/HAMMY i386
Some paths: /usr/local/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe -O3 -fno-omit-frame-pointer' CXX='cc'
CXXFLAGS='-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti
-fno-exceptions' LDFLAGS='' ASFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1218496 Dec 3 2002 /usr/lib/libc.a
lrwxrwxr-x 1 root wheel 9 Dec 3 2002 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 574916 Dec 3 2002 /usr/lib/libc.so.4
Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug'
'--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools'
'--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory'
'--with-comment=FreeBSD port: mysql-server-4.1.0_1' '--enable-thread-safe-client'
'--enable-assembler' '--with-berkeley-db' '--with-openssl' '--prefix=/usr/local'
'--build=i386-portbld-freebsd4.7' 'CFLAGS=-O -pipe -O3 -fno-omit-frame-pointer'
'CXX=cc' 'build_alias=i386-portbld-freebsd4.7' 'CC=cc' 'CXXFLAGS=-O -pipe -O3
-fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
