>Description:
After issuing an incorrect GRANT command Mysqld crashed, but
restarted itself. On the next boot-up of the machine, Mysqld
crashes on startup with an added message about unable to find
user.MYD Copying user.MYD from a backup directory changed the
message to user.FRM but still crashes.
The err file also showed a problem as a result from the
incorrect GRANT command:
Found invalid password for user: 'edward@%'; Ignoring user
Moving the *bin*, *err*, and mysql/ directory and replacing
them from a backup (files after initial install of Mysql)
removed the problem, so the problem is definitely in the
Grant tables.
If other people can repeat this, I think this would classify
as a serious error, as people could crash the database with
just a typo (I just confused commands for Mysql and another
database).
>How-To-Repeat:
This is from my .mysql_history and is the sequence of commands
through which the crash was triggered (changed
host/user/pass).
The line that triggered the error is the one with "password"
in it (it has 1 argument to much for the GRANT command):
create database crashdb;
grant all on crashdb to someuser;
flush privileges;
revoke all on crashdb from someuser;
grant all on crashdb to someuser identified by 'pass';;
grant all on crashdb to someuser identified by password 'pass';;
revoke all on crashdb;
grant all on crashdb to [EMAIL PROTECTED] identified by password('pass');
grant all on crashdb to [EMAIL PROTECTED] identified by 'pass';
flush privileges;
\q
>Fix:
Use the correct GRANT syntax
>Submitter-Id: <submitter ID>
>Originator: Edward van der Jagt
>Organization: The Network Guru
>MySQL support: none
>Synopsis: Incorrect GRANT causes crash of mysqld
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.41 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for suse-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 3.23.41-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 48 min 33 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.000
>Environment:
This is a SuSE 7.3 system.
System: Linux whisper 2.4.16-4GB #1 Tue Dec 18 14:16:17 GMT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-O2 -mcpu=i486 -march=i486
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 634880 jun 6 21:43 /lib/libc.so.4
-rwxr-xr-x 1 root root 1384168 sep 20 2001 /lib/libc.so.6
-rw-r--r-- 1 root root 25215580 sep 20 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 sep 20 2001 /usr/lib/libc.so
-rw-r--r-- 1 root root 856542 sep 24 2001 /usr/lib/libc-client.a
lrwxrwxrwx 1 root root 20 mrt 7 23:34 /usr/lib/libc-client.so ->
libc-client.so.2000c
-rwxr-xr-x 1 root root 718160 sep 24 2001 /usr/lib/libc-client.so.2000c
Configure command: ./configure --disable-shared --with-mysqld-ldflags='-all-static'
--with-client-ldflags='-all-static' --without-berkeley-db --without-innodb
--enable-assembler --enable-large-files --infodir=/usr/share/info --libdir=/usr/lib
--libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man
--prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug
--datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-libwrap
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
