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.

Problem 1045 after changing ocs MySQL password [closed]

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> 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:

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

closed with the note: Solved - 2 files need to be modified with the new password
in OCS Inventory NG server for Unix by (240 points)
closed by

1 Answer

0 votes

Figured it out.

You need to change the ocs password in TWO files.

Edit ocs password around line 31.

Edit ocs password around line 6.

by (240 points)
Powered by Question2Answer