how can I to configure SSL flag when creating a connection?

[Zilev]

Will be something like this?, somebody can help me please?

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db',
  ssl: true
});

I'm having this error:

[Error: Server does not support secure connnection] stack: [Getter]

[dougwilson]

This error is because the MySQL server you are trying to connect to is not configured for SSL. You can read more about setting up your MySQL server for SSL connections in the MySQL manual here: https://dev.mysql.com/doc/refman/5.6/en/using-ssl-connections.html

[Zilev]

@dougwilson thanks for helping me. I've already configured MySQL to Use SSL Connections as https://dev.mysql.com/doc/refman/5.6/en/using-ssl-connections.html, but the error continues, maybe is there other step after configure?
is it ok this way to create a ssl connection?

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db',
  ssl: true
});

thanks in advance 😄

[dougwilson]

It's no problem! In order to use SSL, you cannot simply just do ssl: true :( You have to provide all the options, including the certificate in an object (more explained here: https://github.com/felixge/node-mysql#ssl-options).

Also, are you still getting the error "Server does not support secure connnection" or a different error? The error "Server does not support secure connnection" specifically means that your MySQL server itself is not correctly configured, rather than anything you are doing with this client.

[Zilev]

isn't there the possibility to only enable this flag? (ssl:true) https://github.com/felixge/node-mysql#other-available-flags, without adding any certificate in an object?

[dougwilson]

It is not possible with how MySQL works. If you can determine a way, PRs are accepted!

Also, are you still getting the error "Server does not support secure connnection" or a different error? The error "Server does not support secure connnection" specifically means that your MySQL server itself is not correctly configured, rather than anything you are doing with this client.

[Zilev]

yeah I think the main problem is I'm continue using this

ssl: true

jejeje I'll change that and test again 😄
thanks you so much for help!

[Zilev]

just a question more please, is not clear for me this flags https://github.com/felixge/node-mysql#other-available-flags, when and how can I use them?. This way?

var connection = mysql.createConnection("mysql://localhost/test?flags=-FOUND_ROWS");

If I use SSL, what will the behavior?

[dougwilson]

If you need to use the flags, you can use them with that string format, but we recommend you use the object format so that all options are available to you:

var connection = mysql.createConnection({
  database: 'test',
  flags: '-FOUND_ROWS'
})

[Zilev]

but what will do the SSL flag ?

[dougwilson]

Those flags are just listed because they are in the source code for the MySQL command line client as part of MySQL; they have no functionality in this module.

[Zilev]

ohhh now I get it 😄 thanks