On Mon, May 11, 2015 at 3:20 AM, P.R.Karthik <[email protected]> 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 _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
