Why do I get a "JDBC Driver Error: CLIENT_PLUGIN_AUTH is required" error when connecting to a remote MySQL database?

4 次查看(过去 30 天)

采纳的回答

MathWorks Support Team
This appears to be a server-side authentication issue with the MySQL database.
1) Please ensure the driver version for the JDBC connection is compatible with the version of the MySQL database you are trying to connect to.
2) Please specify the parameter "useSSL=false" in the URL of JDBC connection:
>> driverpath = 'C:\xxxxxx\mysql-connector-java-X.X.XX.jar';
>> opts = configureJDBCDataSource('Vendor','Other');
>> opts = setConnectionOptions(opts,'DataSourceName','SQLServerDataSource',...
'URL','jdbc:mysql://<hostname or ip address>/<database-name>?useSSL=false&',...
'Driver','com.mysql.cj.jdbc.Driver',...
'JDBCDriverLocation',driverpath);
username = 'exampleUsername';
password = 'examplePassword';
[status, error] = testConnection(opts,username,password)
3) If these steps fail, please contact your database administrator to troubleshoot authentication and connectivity issues.

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

标签

尚未输入任何标签。

产品


版本

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by