[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Koha-devel] Re: mysql crash...please help

From: Ambrose Li <address@hidden> via forwarder
Subject: [Koha-devel] Re: mysql crash...please help
Date: Wed Jan 29 08:02:02 2003

Hi, Benedict,

In article <address@hidden>,
Benedict  <address@hidden> wrote:
>Now I get this while trying to mysqladmin:
>address@hidden koha-RC1]# mysqladmin reload
>mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user: 'address@hidden' (Using password: NO)'
>address@hidden koha-RC1]#

I suppose you have proper filters in place so that people can't just
connect to your mysql port. So, the following should be safe to do.

1. Stop the MySQL system with /etc/rc.d/init.d/mysql stop

   If this does not work (e.g., ps ax|grep mysqld still show mysqld
   after a while), do a "killall mysqld safe_mysqld" (and "hope" the
   tables are ok)

2. Restart MySQL with no security. You'll need to know where your
   mysqld is. (You can read the /etc/rc.d/init.d/mysql to find out,
   or use the "rpm -ql mysql" command, I think.) Suppose it is in
   /usr/sbin/mysqld. Then do a

   /usr/sbin/mysqld --skip-grant-tables

3. Run mysql and give root a password, by doing a

   insert into mysql.users values ('localhost', 'root',
      password('REAL-ROOT-PASSWORD'), 'Y', 'Y', 'Y', 'Y', 'Y',
      'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

   If MySQL complains that the number of columns is not right, do
   a "describe mysql.users;" and adjust the number of 'Y''s

4. Restart the MySQL system (with security).

There might be a shorter fix, but this should work.

Ambrose LI Cheuk-Wing  <address@hidden>

reply via email to

[Prev in Thread] Current Thread [Next in Thread]