October 9, 2020 at 9:28 am #7409
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)
Rapid SCADA ModDBExport configuration:
Pls advice for my mistake, thank you.October 9, 2020 at 4:38 pm #7411October 10, 2020 at 2:48 am #7413October 10, 2020 at 3:42 am #7414
I am getting all the REAL channel type exported to MySQL. However, the OTHER THAN REAL channel types were not exported to MySQL.
Pls advice for how shall I configure the other channels types in highlighted?
Thank you.December 14, 2020 at 12:56 pm #7723David01Participant
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.
Please help.December 15, 2020 at 12:28 pm #7727
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;
from this page. The issue is not related directly to Rapid SCADA. You should search the internet and try suggested solutions.December 15, 2020 at 1:54 pm #7733David01Participant
It’s working now.
Thank you very much, Mikhail.December 16, 2020 at 1:31 pm #7743
Thanks for noticing. It’s very common issue.
- You must be logged in to reply to this topic.