I have to enable an SSL connection to MySQL to access I in Microsoft Visual Stud

Question

I have to enable an SSL connection to MySQL to access I in Microsoft Visual Studio 2017 to submit queries with.
In Visual Studio C# we have a list view with entries and a folder attached to each entry. We are to insert, delete, entries that are selected in the list view with SQL statements, into appropriate tables of pending, approved, and denied, where the SSL Connection comes into play. Along with inserting and deleting we also have to update that table to either approve, deny, and pending tables.
Within the folder associated with each list view item is a .txt file with the associated properties to each table in the database. My question is how to set up an SSL connection for remote access for Visul Studio 2017 and how to insert, delete, update entries into tables in the database? I have to enable an SSL connection to MySQL to access I in Microsoft Visual Studio 2017 to submit queries with.
In Visual Studio C# we have a list view with entries and a folder attached to each entry. We are to insert, delete, entries that are selected in the list view with SQL statements, into appropriate tables of pending, approved, and denied, where the SSL Connection comes into play. Along with inserting and deleting we also have to update that table to either approve, deny, and pending tables.
Within the folder associated with each list view item is a .txt file with the associated properties to each table in the database. My question is how to set up an SSL connection for remote access for Visul Studio 2017 and how to insert, delete, update entries into tables in the database?
In Visual Studio C# we have a list view with entries and a folder attached to each entry. We are to insert, delete, entries that are selected in the list view with SQL statements, into appropriate tables of pending, approved, and denied, where the SSL Connection comes into play. Along with inserting and deleting we also have to update that table to either approve, deny, and pending tables.
Within the folder associated with each list view item is a .txt file with the associated properties to each table in the database. My question is how to set up an SSL connection for remote access for Visul Studio 2017 and how to insert, delete, update entries into tables in the database?

Explanation / Answer

step1:here we are providing the ssl connections to the mqsql database.

step2:we need to generate pem file based on the fqdn(fully qualified domain)

step3:we need to created CA, server and client certificates.

Add the generated to my.cnf the client SSL section

[client]

ssl-ca=/app/mysql_ssl/ca-cert.pem

ssl-cert=/app/mysql_ssl/client-cert.pem

ssl-key=/app/mysql_ssl/?lient-key.pem

step4:Created new mysql user

cmd to create new mysql user are as follows:

CREATE USER 'hari'@'%' IDENTIFIED BY 'cheggexpert';

GRANT USAGE ON *.* TO 'hari'@'%' REQUIRE X509;

FLUSH PRIVILEGES;----------------------------->>>>From here we need to create mysql user with username hari and password as

cheggexpert and we have grant usage in all folders all the folders of that user

which will connect through X509(name of the certificate)

step5:Now you are able to conenct the mysql database

>>mysql --user=hari --password --ssl-ca=/app/mysql_ssl/ca-cert.pem --ssl-cert=/app/mysql_ssl/client-cert.pem --ssl-key=/app/mysql_ssl/client-key.pem

here we are not passing the password but providing the certificate here

My question is how to set up an SSL connection for remote access for Visual Studio 2017 and how to insert, delete, update entries into tables in the database?

We are setting up ssl to user(hari) of the database.

here the database name is hari from that database we need to insert,delete and update tables.

so where ever we have we need to remotely connect by using certificates and connect to the database and do the operations.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---