Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.11.1 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

i forgot ocs password to acesss ocsreport

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,
in OCS Inventory NG server for Windows by (120 points)

1 Answer

0 votes
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';


#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.
by (220 points)
Powered by Question2Answer