Mysql Warning -- Establishing SSL connection without server's identity verification is not recommended.

Warning while using lates MySQL J Driver: mysql-connector-java-5.1.41-bin.jar

Following is the warning while running the project from eclipse:

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.


Adding useSSL=false to the Database URL solves the problem.

example : "jdbc:mysql://localhost:3306/" + dbName + "? useSSL=false";

Comments

  1. UnknownNovember 12, 2017 at 10:51 PM

    "jdbc:mysql://localhost:3306/" + dbName + "?useSSL=false";
    ex: database name: shop
    I'll have "jdbc:mysql://localhost:3306/shop?useSSL=false";
    GG!

    ReplyDelete
  2. UnknownApril 30, 2018 at 1:52 AM

    i add this
    "jdbc:mysql://localhost:3306/dbname?useSSL=false";
    but it can not work ...

    ReplyDelete
    Replies
    1. mntanprojectApril 30, 2018 at 9:46 AM

      dbname refer to your database name for the system. for example database name is my_sql_database then the query will be
      - jdbc:mysql://localhost:3306/my_sql_database?useSSL=false;

      and also please note for port number your localhost using.

      Delete

Post a Comment

Popular posts from this blog

CPU locks at 700Mhz

Device : Laptop Acer Aspire S3 951, core i7 2637M upgraded to windows 10 from windows 7 64x. Cpu clock speed constantly locks at 700Mhz after running the laptop for a while. Able to resolve this in short term, by shut down the laptop, turn off the adaptor, but the lock will come back again after running some heavy task. try run prime95 to test it. updating BIOS somehow work in short term as well. As for long term solution, - updated the chipset driver with the latest provided by Intel ( just overwrite the one comes with Acer for windows 7 driver). - updated the Intel Management Engine with the one provided by Intel. Laptop has been running for few days (without shutting down) heavy processing sometime. Now without having CPU clock speed locks. - updated Not sure if it is related with hard drive failure. PC's hard drive fail soon when try to reformat the PC with windows 10 installer. upgraded to SSD now running smooth.
Read more

Set navigation drawer selected item from Fragment

  public class HomeFragment extends Fragment {   private NavigationView navigationView ;   public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {  navigationView = (NavigationView)getActivity().findViewById(R.id. navigation_view ); navigationView .setCheckedItem(R.id. nav_staff );   }     use getActivity instead of using view.
Read more