mysql crash...please help
While experimenting with mysql the mysqld stopped responding to root@localhost. This is probably an effect of such command: delete from user where host='localhost'; Now I get this while trying to mysqladmin: [root@localhost koha-RC1]# mysqladmin reload mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' [root@localhost koha-RC1]# What to do? Benedict
Here is what the search engine at cpan.org brings. Is this something we could use to facilitate separating the language from presentation? Of interest to me is this: "PGetText provides the same functionality as GNU gettext does, but it is written in pure perl and doesn't require any system locale stuff." If someone tells me how to modify perl scripts I will follow blindly the instructions. Results 1 - 5 of 5 Found Gettext Perl extension for emulating gettext-related API. Gettext-0.01 - 08 Jan 2000 - James Briggs gettext message handling functions gettext-1.00 - 22 Jul 1996 - Phillip Vandry Locale::gettext message handling functions gettext-1.01 - 25 Feb 1998 - Phillip Vandry Locale::PGetText pure perl i18n routines Locale-PGetText-0.16 - 20 Feb 1999 - Mike Shoyher Locale::Maketext::Lexicon::Gettext PO and MO file parser for Maketext Locale-Maketext-Lexicon-0.15 - 29 Nov 2002 - ☺唐宗漢☻
Hi, Benedict, In article <1043850368.1121.14.camel@localhost.localdomain>, Benedict <kb2qzv@poczta.wp.pl> wrote:
Now I get this while trying to mysqladmin: [root@localhost koha-RC1]# mysqladmin reload mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' [root@localhost 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 <a.c.li@ieee.org>
participants (2)
-
Ambrose Li <acli＠ada.dhs.org> via forwarder -
Benedict