Problem 1045 after changing ocs MySQL password [closed]

Question

I got the following error after changing ocs MySQL password:

ERROR: MySql connection problem 1045
Access denied for user 'ocs'@'localhost' (using password: YES)

I changed the MySQL password using:

# mysql -u root -p
mysql> SET PASSWORD FOR ocs@'localhost' = PASSWORD('yourpassword');
mysql> SET PASSWORD FOR ocs@'%' = PASSWORD('yourpassword');
mysql> FLUSH PRIVILEGES;
mysql> quit
# nano /etc/apache2/sites-available/z-ocsinventory-server.conf
   Edited ocs password around line 31.

# /etc/init.d/apache2 restart

I'm using OS:
# lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 8.4 (jessie)
Release:        8.4
Codename:       jessie

Server info:

Software
PHP Version :
5.6.19-0+deb8u1 (apache2handler)
Web Server : Apache/2.4.10 (Debian)
Database Server : (Debian) version 5.5.47-0+deb8u1

Answer 1

Figured it out.

You need to change the ocs password in TWO files.

z-ocsinventory-server.conf
Edit ocs password around line 31.

dbconfig.inc.php
Edit ocs password around line 6.