i forgot ocs password to acesss ocsreport

Question

hi everyone

i made updating to password to ocs user, then i restar apache and mysql services, then when i want to login into http://localhost/ocsreports ,  appear this message:

ERROR: MySql connection problem
Access denied for user 'ocs'@'filtec-fs02.us.sharedom.net' (using password: YES)
ERROR: MySql connection problem

and i cant write another user, even from mysql console i cant update the password,

Answer 1

Do you know root password? If not, then reset root password from DB.

use this:

# mysqld_safe --skip-grant-tables &

# mysql

Now logged in

#mysql> use mysql;

Now update password:

#mysql> update user SET password=password('NEW PASS') WHERE user='root';

Exit:

#mysql> quit

Restart mysql.

Now with root password:

Logon in mysql:

#mysql -uroot -p

mysql> use ocsweb

mysql>SET PASSWORD FOR 'ocs'@'localhost' = PASSWORD('MyNewPass');

Then reconfigure file dbconfig.inc.php in ocsreports directory.