MATLAB: Do I get a “JDBC Driver Error: CLIENT_PLUGIN_AUTH is required” error when connecting to a remote MySQL database

MATLAB

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

Best Answer

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.

Related Solutions

MATLAB: Is it possible to use SSL with MySQL with the Database Toolbox 3.5 (R2008b)

In order to make use of SSL encryption to connect to your database, you will need the following:

1. The assistance of your database administrator to configure the MySQL server to accept SSL connections.

2. The SSL PEM public-key file that corresponds to your server's encryption key.

Here is the procedure:

1. Follow the steps in the MySQL documentation below to to verify that...

(a) Your MySQL server has SSL support,

(b) You can use the MySQL Command-Line Client to connect to the server using SSL:

https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html

In particular, the following SQL command may be informative:

     show variables like 'have_ssl'

If the answer from your server is 'NO', then the server has no SSL support compiled into it. If the answer is 'DISABLED', your system administrator does not start the MySQL server with SSL enabled. If the answer is 'YES', you may be able to use SSL.

2. Follow the steps in the MySQL documentation below to configure your Java environment to use the server's PEM certificate with JDBC. You can specify Java options for MATLAB by modifying or creating the 'java.opts' file located here:

   $MATLABROOT\bin\ARCH\java.opts

Here, $MATLABROOT is the directory where MATLAB is installed, and $ARCH is your computer's architecture, for example 'win32'.

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-using-ssl.html

3. Restart MATLAB

4. Modify your call to the DATABASE command from

   hconn = database('DatabaseName','UserName','Passwd',...
                                'com.mysql.jdbc.Driver',... 
                                'jdbc:mysql://HOST:PORT/DatabaseName')

   hconn = database(''DatabaseName','Username','Passwd',...
                                'com.mysql.jdbc.Driver',...
  'jdbc:mysql://HOST:PORT/DatabaseName?verifyServerCertificate=false&useSSL=true&requireSSL=true&')

Please note that the trailing '&' in the URL is required.

MATLAB: Do I get an error when I try to access a remote database using the Microsoft SQL 2000 JDBC driver

This documentation bug has been fixed for Release 14 (R14). For previous releases, please read below for any possible workarounds:

To connect to the remote database using the Microsoft SQL 2000 JDBC Driver please use the following command:

conn = database
('iri','andy','andy','com.microsoft.jdbc.sqlserve
r.SQLServerDriver','jdbc:microsoft:sqlserver://an
dre1:1433;database=iri')

Best Answer

Related Solutions

MATLAB: Is it possible to use SSL with MySQL with the Database Toolbox 3.5 (R2008b)

MATLAB: Do I get an error when I try to access a remote database using the Microsoft SQL 2000 JDBC driver

Related Question