Error while connecting to jdbc MySQL. jdbc communication link failure. The last packet sent successfully to the server was 0 milliseconds ago.

Hi,
Error while connecting to database. The communication fails with the below error message.
jdbc communication link failure. The last packet sent successfully to the server was 0 milliseconds ago.
Below are the commands entered by me.
opts = configureJDBCDataSource('Vendor','MySQL');
opts = setConnectionOptions(opts, ...
'DataSourceName','MySQL80',...
'Server','localhost','PortNumber',3306, ...
'JDBCDriverLocation','C:\Users\JSRD\Downloads\mysql-connector-java-8.0.30\mysql-connector-java-8.0.30\mysql-connector-java-8.0.30.jar');
username = "root";
password = "root";
[status,msg] = testConnection(opts,username,password);
Kindly request you to resolve the same.

Answers (1)

Hi,
One possible cause is that the service is not running.
Open "Services" in Windows in administrator mode, find MySQL, right-click and select "Start".
Best wishes,
Harald

Tags

Asked:

on 24 Sep 2022

Answered:

on 9 Jan 2024

Community Treasure Hunt

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

Start Hunting!