Ignition to MYSQL error

[Uchenna_Nwaba]

Please help me fish out the problem

java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘root’@‘localhost’ (using password: YES))
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:656)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734)
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:299)
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:252)
at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1096)
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:582)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:103)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:652)
… 12 more

[josborn]

@Uchenna_Nwaba

Access denied for user ‘root’@‘localhost’

We will need more info on your setup to help.

[Uchenna_Nwaba]

I am new to ignition, I tried configuring connecting Ignition to MySQL database, but got the error.
What additional info would you have me send?

[josborn]

That’s perfectly ok, but with only the error there isn’t much to go on. Are you sure you typed the right password in?

What version of Ignition and MySQL and please show us how you set up your database connection.

[Uchenna_Nwaba]

Ignition 8.1 and MYSQL 8.0.28. I typed in the exact username (root) and password that I used to setup MYSQL into ignition’s database configuration settings for MYSQL. Thought it would be a smooth sail. This is from Management section, users and privileges page, and root as User option

[Uchenna_Nwaba]

Although the password on this MYSQL page above seems longer (hence different) from the one I used to login into it.

[josborn]

Did you install the driver?

Drivers on MySql Jar files missing

You’ll need to install the MySQL JDBC Driver. You can find instructions and a link to the driver here: https://docs.inductiveautomation.com/display/DOC80/JDBC+Drivers+and+Translators We used to distribute the MySQL JDBC driver with Ignition but we’ve stopped doing so as of Ignition 8 because it’s not allowed by the license.

We would need to see your database connection, log into the gateway web interface > settings > databases > connections > edit

All signs point to bad password though. Also its not a good practice to use the root user, you should create one for ignition to use.

[Uchenna_Nwaba]

Don’t mind me, I did not use the right MYSQL database scheme name. I have fixed that, It now works.
I understand the principles of database design, but just getting to be acquainted with configuration and administration.

Many thanks, Josborn, particularly for your swift response, its remarkable.