ModDBExport Authentication failed

[kcks66]

Hi Mikhail,

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)

MySQL connection:
https://ibb.co/rywmTzx

Rapid SCADA ModDBExport configuration:
https://ibb.co/3RyQrcJ

Pls advice for my mistake, thank you.

[Mikhail]

Hi,

Try different solutions from this page. Which one is right for you?

[kcks66]

Hi Mikhail,

Rapid SCADA can access MySQL now. Thank you.

https://ibb.co/DKMtrds

I manually overwrite the “password”, and it worked.

https://ibb.co/HNY0YxW

[kcks66]

Hi Mikhail,

I am getting all the REAL channel type exported to MySQL. However, the OTHER THAN REAL channel types were not exported to MySQL.

https://ibb.co/kXcWyWp

Pls advice for how shall I configure the other channels types in highlighted?
Thank you.

[David01]

Hello,

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.

[Mikhail]

Hello,

Try

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.

[David01]

It’s working now.

Thank you very much, Mikhail.

[Mikhail]

Thanks for noticing. It’s very common issue.

[Author]

Posts