Yep, I did this too when I was first starting out.
Something you put into mysql.user is syntactically incorrect.
The server does a sanity check on it's permissions, and if they are screwy,
kills itself to save your data. (very big of it, yes?)
The quickest way out of this mess is to delete the mysql database directory
(rm -Rf /usr/local/mysql/var/mysql) which gets rid of all grant tables, then
run /usr/bin/mysql_install_db to put fresh tables in.
You can't use mysql_fix_privilege_tables, because you can't start the
server.
Then, once you have done that, ONLY use the GRANT option until you really
really really really really understand how the grant tables work together.
On 3/29/01 7:47 AM, "Denis Mettler" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I had a running system (suse Linux 7.1, php 4, mysql 3.22.32 and apache
> 1.3.12).
> but the mysql daemon is running in root.
> 10 minutes before i tried to add a new user in the table user of the db
> mysql. but i got no results.
>
> so, i tried again.
> -nothing!
>
> then i killed the mysql daemon.
> and now i couldn't start the mysql daemon again!
>
> The exact error message is:
>
> Starting mysqld daemon with databases from /usr/local/mysql/var
> [2] Done bin/safe_mysqld
> washington:/usr/local/mysql # mysqld daemon ended
>
> ANY IDEAS???
>
> Regards
> Denis
>
> -------------------------------------------------------
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
