search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.19k stars 322 forks source link

SSL settings in User Manager #2061

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 2062 created by webyog on 2014-11-10T10:15:21.000Z:

User requested: http://forums.webyog.com/index.php?showtopic=7560

However there is an insufficience with MySQL :http://bugs.mysql.com/bug.php?id=74685. It is not possible to specify SSL settings for a user in a CREATE USER statement. It will be necessary to do in two steps.

CREATE USER GRANT USAGE .. REQUIRE ..

.. and that may make the GUI a little 'quirky'

sibwy commented 2 years ago

Another user has requested for including the option to include TLS options while creating the MySQL user in the 'User Manager'.

MySQL v5.7+ supports the 'tls_option' in the "CREATE USER ..." statement as well as MariaDB unlike the v5.6 and below versions.

The user request can be found in SF >> 00949554