Hi Everyone,

I have MySQL 5.0 installed and its running under linux & apache.

My XOOPS version is 2.2.2.

I lost my root password for MySQL and I need to Reset the root password in order to gain access again.

I am about to follow the procedure under the Unix environment for MySQL root password reset:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

But I was told that if Apache is still running in the background that it will go crazy cause XOOPS doesn't have have access to databases...

Is that true? Should I first stop apache from running and then reset my sql password? Is there something I have to do in order to avoid having problems with XOOPS when resetting my sql root password?

If so, does anyone know where I can find the information for a newbie on how to successfully stop and restart apache ?

Thanks in advance!

Patrick S.
Web Designer
Minacom.com

you should be able to start/stop MySQL without having to stop apache.

only time you really need to restart apache is if you have made changes to the apache config or php.

of course XOOPS will not work until MySQL has been restarted, and DB access for XOOPS should be fine if all you're doing is resetting the MySQL root password. I'm presuming your XOOPS db has a different username & password than the root uname/password.

Quote:

Thanks Monty.

I made a mistake, I thought we upgraded to MySQL 5 but we have MySQL 4 installed.

Perfect so the only issue is that web users will not be able to go on the website.

Actually, should I Turn the site off from the XOOPS General Settings before I do anything with MySQL reset?

So that they can read that the site is closed for maintenance?

Thanks again.

mysql and apache are separate services under linux. I'm not aware of any need to restart apache when restarting mysql.

If you try to access XOOPS while MySQL is not running, you'll get some error messages; other than that, there shouldn't be any adverse results.

The procedure for starting/stopping/restarting apache depends on your linux distribution.

For example, on Red Hat or Fedora, you can do it like this:
# /sbin/service httpd start
- stops apache
# /sbin/service httpd stop
- starts apache
# /sbin/service httpd restart
- restarts (stops and starts) apache

There's more info here: http://httpd.apache.org/docs/

Quote:

You can do that if you like, but since the site-closed setting is stored in the database, it wouldn't really have any effect if MySQL is not running.

[QUOTE]You can do that if you like, but since the site-closed setting is stored in the database, it wouldn't really have any effect if MySQL is not running.[/QUOTE]

Thanks Dave.

I'll have to put up a file that says the site is down in this case, we have alot of customers travelling by.