ModDBExport Authentication failed

Forum Home Forums Understanding the Software ModDBExport Authentication failed

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #7409
    kcks66
    Participant

    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:
    mysql

    Rapid SCADA ModDBExport configuration:
    DB-Setting

    Pls advice for my mistake, thank you.

    #7411
    Mikhail
    Moderator

    Hi,

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

    #7413
    kcks66
    Participant

    Hi Mikhail,

    Rapid SCADA can access MySQL now. Thank you.

    cnldata

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

    password

    #7414
    kcks66
    Participant

    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.

    calculated-real

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

    #7723
    David01
    Participant

    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:

    Connection problems

    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.

    #7727
    Mikhail
    Moderator

    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.

    #7733
    David01
    Participant

    It’s working now.

    Thank you very much, Mikhail.

    #7743
    Mikhail
    Moderator

    Thanks for noticing. It’s very common issue.

Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.