HELP !! I killed access to my own db :(

[riekl]

Ok my board is now down .. thats what I get for playing in MySql when I have no idea what I'm doing (was trying to install the phpmychat).

Bottom line is, my mysql by default had no password on the "root" user, i assume this is the user acct the system uses to access the boards.

Well phpmysql simply would _NOT_ install without a password so i figured, fine i'll give the user a password and install it.  So i went to dos ran "mysql mysql" in the bin dir and executed 2 commands

SET PASSWORD FOR root = 'lockme'
\g

and

SET PASSWORD FOR root@localhost = "lockme";

I have no idea which one messed things up, i tried rerunning both commands with "" as the password, my boards are still inaccesible.  (You can see the access denied error @ dmaw.avalys.com).

Please help me unscrew up my system  

[riekl]

Giving this a little bump .. this is mission critical my boards are down

[David]

Edit the file Settings.php and find the line that sets your mysql password.  Just edit that line so the password is lockme.

[riekl]

Ok thats good advice ..

Only .. they were both set to "" blank, which means my mysql was setup to allow anonymous access.  So how did my changing the password on the root user, affect anonymous access to the db ?  Granted secured is much better, but still my chaning the password on root shouldn't have had this effect ?

Regardless this doesn't seem to have helped  My page is giving me a 403 error .. this isn't what I would get with a bad SQL access anyway is it ?  Ugh i need help ..

[David]

403 is a forbidden error.  Make sure apache has the correct permissions to your board's directory.