Set up a JDBC connection from Matlab to MySQL on osX
7 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have set up MATLAB (2016b 64-bit) to interact with the local MySQL server. I followed the instructions and created a javaclasspath.txt file on Matlab's prefdir location where I saved the mysql-connector-java-5.1.40-bin.jar location. Afterwards, I used the native Matlab Database Explorer App to set up a connection, where after following the steps Matlab created a .mat file on the current folder (see picture):
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/160539/image.jpeg)
As you can see above the .mat file contains a cell array with the listed inputs. My question is the following, now that I have successfully set up the server I want to create a "conn = database()" variable. How can I do that? I have read the Matlab guide and this guide on Stackoverflow but I get an error "Invalid connection" when I execute :
conn = database('Data_Science', 'root', '*****', 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost:3306/Data_Science?useSSL=false');
e = exec(conn,['create table BULKTEST (salary decimal, '...
'player varchar(25), signed_date varchar(25), '...
'team varchar(25))']);
Is something wrong with my code above? Did I write the information wrong? The second part (e) is c/p from Matlab's site. So my doubts are about conn.
SOLUTION:
Ok, the problem was on the conn command. When I used this code, without including the ?useSSL=false :
conn = database('Data_Science', 'root', '*****', 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost:3306/Data_Science');
I received this warning:
Fri Feb 10 13:48:03 GMT 2017 WARN: Establishing SSL connection without
server's identity verification is not recommended. According to MySQL
5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established
by default if explicit option isn't set. For compliance with existing
applications not using SSL the verifyServerCertificate property is set to
'false'. You need either to explicitly disable SSL by setting useSSL=false,
or set useSSL=true and provide truststore for server certificate verification.
So I looked online and the solution was to include ?useSSL=false at the end of conn. Indeed, this worked as I no longer received any further warnings, but when I checked the conn on workspace there was a line with the following message:
The connection property 'useSSL' only accepts values of the form: 'true',
'false', 'yes' or 'no'. The value 'falseData_Science' is not in this set.
Which I never noticed before, that caused the connection error. So I just reversed back to the original conn, amending the ?useSSL=false change I made. Now, I still receive the warning but it works.
4 Kommentare
Kojiro Saito
am 11 Feb. 2017
It's good you could work around by yourself. The last error "The value 'falseData_Science' " seems strange.
Anyway, without useSSL option, you can also run exec command by defining "conn" as
conn = database('Data_Science','root','PASSWORD','Vendor','MySQL', 'Server', 'localhost', 'PortNumber', 3306);
Two key-value pairs, 'Server', 'localhost' and PortNumber', 3306 can be omitted because they're default values.
Ivan Surovtcev
am 17 Aug. 2017
Have the same problem. Same error and the 'falseData_Science' in my case is 'falseDataBaseName'.
Does it look like Matlab incorrectly merges strings when trying to make a connection?
Antworten (1)
Hannes Greim
am 22 Aug. 2018
Try adding an "&" at the end of the new portion of the string:
?useSSL=false&
3 Kommentare
Shay Rotics
am 31 Jan. 2019
Thanks, had the same problem of the matlab concatanating the 'false' to 'falseuser_db' and the '&' solved it. Many thanks
Arpan Badeka
am 4 Apr. 2019
This has been fixed in later releases. To make it work keep the first argument as empty.
conn = database('', 'root', '*****', 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost:3306/Data_Science?useSSL=false');
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!