[Ilugc] Mysql user's SSL connection status
- From: bala150985@xxxxxxxxx (Balasubramaniam Natarajan)
- Date: Mon, 11 May 2015 10:31:28 -0400
On Mon, May 11, 2015 at 3:20 AM, P.R.Karthik <prkart at gmail.com> wrote:
You can force all the the users to use SSL by enabling "ssl-only" on the
mysql config ( /etc/my.cnf ) and enabling SSL in user creation ( REQUIRE
SSL ). Make sure that you application has the client certs installed.
The below query will provide you the list of users who do not have SSL
( REQUIRE
SSL ).
select user,host,ssl_type from mysql.user where ssl_type='';
Regards,
KarthiK.P.R
I guess my question is not phrased properly.
1. Enable mysql on *serverA* with SSL support.
2. Create a user remotesecure to login without the REQUIRE SSL to login
remotely.
3. Log in using remotesecure from *serverB* by given it the appropriate SSL
certs.
4. At the mysql prompt type \s I can see that I am riding over SSL.
5. Now open another connection to mysql on *serverA* from *serverC* as root
user without giving it SSL certs and type in \s you can see that you are
riding on clear text.
6. What is the command I need to type in *serverC *connection to see that
equivalent output of step4 ?
--
Regards,
Balasubramaniam Natarajan
http://blog.etutorshop.com
Other related posts: