Just tried this and got the following output. Any idea if i can get the REQUIRE SSL in the show grants for statement.
mysql> show grants for 'safiullah'@'10.13.2.112';
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for
safiullah@10.13.2.112 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'safiullah'@'10.13.2.112' |
| GRANT SELECT ON `mysql`.* TO 'safiullah'@'10.13.2.112' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, ALTER ROUTINE, EVENT ON `asiacellodp`.* TO 'safiullah'@'10.13.2.112' |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
mysql> show CREATE USER 'safiullah'@'10.13.2.112'\G
*************************** 1. row ***************************
CREATE USER for
safiullah@10.13.2.112: CREATE USER 'safiullah'@'10.13.2.112' IDENTIFIED WITH 'mysql_native_password' AS '*FD496A099CE648E512FADC7B3360CC7AD28951B3' REQUIRE SSL PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK
1 row in set (0.00 sec)