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>