#47 - Changing the password in a MySQL DB and updating the connection with Ignition SCADA server

In this post we will see a method for changing a MySQL database password and how to update this parameter when connecting to a SCADA Ignition server. I recently had to do this operation after updating the MySQL version.

• Open Services and stop MySQL from running by selecting and clicking Stop the service.

• Create a text document mysql-pwd-reset.txt with the command below. Place the document at the root C: \

ALTER USER 'root'@'localhost' IDENTIFIED BY 'novaSenha';

• Open CMD as Administrator and execute the commands below:

Change dir:

>cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"

>C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 5.7\\my.ini" --init-file=C:\mysql-pwd-reset.txt

When the database access password does not match the password configured on the Ignition Gateway, a connection error appears.

Edit the password on Ignition Gateway Config>DB>DB connection and click on Change password and insert the new password:

Verify that after the change the connection has been established on the Gateway Status>Connections>DB: