I am using MySQL 5.7. I couldn’t make a connection in between Rapid SCADA and MySQL. The log show:
2020-10-09 17:07:41 Start ModDBExport module
2020-10-09 17:07:42 Error connecting to DB MySQL – 127.0.0.1: Authentication to host ‘127.0.0.1’ for user ‘root’ using method ‘mysql_native_password’ failed with message: Access denied for user ‘root’@’localhost’ (using password: YES)
I am having the same problem the original poster had. I am using MySQL 8.0. and I am getting the following error all the time:
2020-12-14 13:49:53 Error connecting to DB MySQL – localhost: Authentication to host ‘localhost’ for user ‘root’ using method ‘mysql_native_password’ failed with message: Access denied for user ‘root’@’localhost’ (using password: YES)
The configuration is really simple, so I don’t understand why it’s not working. I am just trying to connect to the localhost. And I tried it on different projects but the same thing happens all the time. I am currently using the HelloWorld sample project.
My connection string is as follows:
I have been stuck for hours now. I tried everything. I entered the password manually. I tried different users. I tried reconfiguring the MySQL server with a different authentication configuration but then I got an error saying I don’t have the necessary plugins. I also read the answers in the link above but none worked.