Hello!
[EMAIL PROTECTED] wrote:
>>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.
>
Problem is that tables contain of more than just one file, recover
user.* from your backup (the extensions might vary depending on the
table type)
> 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
>
>
>
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
---------------------------------------------------------------------
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
