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
2020-6-2
回答: MathWorks Support Team
2020-11-24
Why do I get a "JDBC Driver Error: CLIENT_PLUGIN_AUTH is required" error when connecting to a remote MySQL database?
采纳的回答
MathWorks Support Team
2020-6-2
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!