SQL
Description:
User has ALL grants to the database.
mysql> show grants for [EMAIL PROTECTED];
+-------------------------------------------------------------------------------
--------------+
| Grants for [EMAIL PROTECTED]
|
+-------------------------------------------------------------------------------
--------------+
| GRANT USAGE ON *.* TO '_ANALIT_'@'XXX.XXX.XXX.XXX' IDENTIFIED BY PASSWORD 'yyy
yyyyyyyyyyyyy' |
| GRANT ALL PRIVILEGES ON `atas`.* TO '_ANALIT_'@'XXX.XXX.XXX.XXX'
|
+-------------------------------------------------------------------------------
--------------+
2 rows in set (0.00 sec)
I create two connection to the server from host XXX.XXX.XXX.XXX.
The first for read, the second for write(replace, update, insert)
This works near 1 day. But after near 1 day grants lost. And I have:
mysql> insert into analit set label=10;
ERROR 1142: insert command denied to user: '[EMAIL PROTECTED]' for table
'analit'
"Show grants" on the server shows the same as above "show grants".
All grants tables are checked without error.
After restarting mysqld, grants work again.
>How-To-Repeat:
Fix:
I don't know. But restarting server restore grants working.
>Submitter-Id: <submitter ID>
>Originator: Andrey Kotrekhov
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
Synopsis: existent grants ended to work
Severity: serious
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-4.0.17 (Source distribution)
Server: /usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.17, for
unknown-freebsd4.8 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.0.17-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 day 20 hours 47 min 54 sec
Threads: 11 Questions: 5071868 Slow queries: 951 Opens: 589 Flush tables: 3 Open
tables: 157 Queries per second avg: 31.449
C compiler: 2.95.4
C++ compiler: 2.95.4
Environment:
System: FreeBSD 4.8-STABLE FreeBSD 4.8-STABLE #0: Fri Aug 22 15:44:48 EEST 2003
i386
2 CPU
Some paths: /usr/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='gcc' CFLAGS='-O3 -mpentiumpro' CXX='gcc' CXXFLAGS='-O3
-felide-constructors -fno-exceptions -fno-rtti -mpentiumpro' LDFLAGS='' ASFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1224554 22 авг 16:02 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 22 авг 16:02 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 578880 22 авг 16:02 /usr/lib/libc.so.4
Configure command: ./configure '--prefix=/usr/local/mysql' '--without-debug'
'--enable-thread-safe-client' '--with-mysqld-ldflags=-all-static' '--enable-assembler'
'--with-charset=koi8_ru' '--with-extra-charset=koi8_ukr' '--with-mysqld-user=mysql'
'--without-berkeley-db' '--without-isam' '--without-innodb' 'CFLAGS=-O3 -mpentiumpro'
'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti -mpentiumpro' 'CXX=gcc'
Perl: This is perl, version 5.005_03 built for i386-freebsd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
