Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Alex Schaft on October 04, 2001, 08:17:57 PM

Title: Problem with mysql
Post by: Alex Schaft on October 04, 2001, 08:17:57 PM

Hi,

I managed to delete the user tables from the mysql database. What do I need to do to get the system running again. I'm getting

Warning: Access denied for user: 'hordemgr@localhost' (Using password: YES) in /home/httpd/horde-phplib/db_mysql.inc on line 73

Alex

Title: Re: Problem with mysql
Post by: Grethus Bode on October 08, 2001, 12:14:38 PM

I have run into the same problem. Do you have the answer yet?

Title: Re: Problem with mysql
Post by: Alex Schaft on October 08, 2001, 12:20:29 PM

Yes,

I first ran mysql_install_db, then I followed the procedure from the mysql manual for resetting a forgotten password.

What got me was the fact the the root user had a zero length password, as opposed to no password.

You then need to run mysql -u root -p mysql

It will then ask you for a password, and then you press enter. I also recreated the horde database. First I dropped it, and then you run

mysql -u root -p mysql < hordeinstall.sql

I then recreated the hordemgr user, with its password (check their install files), and gave it back its privileges to the database.

HTH,
Alex