mysql monitoring

superglobesuperglobe
I get this error when I use MYSQL option to create monitor rules.



The check has been performed.



Status: DOWN?

Error returned: Client does not support authentication protocol requested by server; consider upgrading MySQL client



But I have been install the lastest MYSQL client and the lastest MYSQL ODBC driver, but still get this error.

I tried to use the ODBC option to create monitor rules, but at the ODBC connection string, no template for MYSQL, also I don't know what connection strings can input there to connect MYSQL. Can anyone help me? Thank you so much.





Best Regards

Alex

Comments

  • AdministratorAdministrator
    ServersCheck uses its built-in mySQL connection program and apparently it is not compatible with the security features you set on your mySQL server.



    The mySQL 3.51 ODBC Driver connection string is:

    DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;
  • superglobesuperglobe
    I use OBDC test and use your connection string, then it can connect to the mysql now. Thanks.
This discussion has been closed.