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.Ba…

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.

[image] Uchenna_Nwaba: Access denied for user ‘root’@‘localhost’ We will need more info on your setup to help.

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?

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.

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 [Screenshot…

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

Did you install the driver? [image] Drivers on MySql Jar files missing Ignition Early Access 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+Translato…

Inductive Automation Forum

Ignition to MYSQL error

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled