![mysql workbench disable ssl mysql workbench disable ssl](https://dev.mysql.com/doc/workbench/en/images/wb-ssl-wizard-options.png)
So you will need to configure it to allow remote login and accept only secure connection. NET Connection String Options Base Options.
![mysql workbench disable ssl mysql workbench disable ssl](http://static-aliyun-doc.oss-cn-hangzhou.aliyuncs.com/assets/img/7814/156698913436543_en-US.png)
From the left-hand menu in Azure portal, click All resources, and then search for the server you have created (such as mydemoserver ). You need the fully qualified server name and login credentials. Configure MySQL For Secure Connection and Remote Loginīy default, MySQL is configured to login from the localhost and allow an unsecure connection. Get the connection information needed to connect to the Azure Database for MySQL. You can place a key pair here to disable SSL (because, you know, having that as an option in the drop-down would be too hard). On the ADVANCED TAB while configuring a new connection - there is a field marked OTHER. If the MySQL server does not support SSL, continue with a regular connection. There is no option here to disable SSL - so we can stop looking for it. If available, default value ( sslModePREFERRED) Automatically attempt SSL connection. The above output clearly indicates that your current MySQL session uses SSL to secure the connection. Setting up SSL connections for MySQL Workbench Certificate Options: No ( sslModeDISABLED) Use to make a general connection without SSL. characterset: utf8mb4 UNIX socket: /var/run/mysqld/mysqld.sock Binary data as: Hexadecimal Uptime: 2 min 9 sec Threads: 2 Questions: 10 Slow queries: 0 Opens: 117 Flush tables: 3 Open tables: 36 Queries per second avg: 0.077 - however, when i try this on 10.6.4 using near-identical my.cnf. Mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)) Connection id: 9 Current database: Current user: SSL: Cipher in use is TLS_AES_256_GCM_SHA384 Current pager: stdout Using outfile: '' Using delimiter: Server version: 8.0.23-0ubuntu0.20.04.1 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb4 Conn.