![]() If the SSL connection is configured as disabled then don't try to make an SSL connection and allow a normal one. Maybe I'm misunderstanding the error message, but I do not think so. Server version: 5.6.14-log MySQL Community Server > However, even so the connection test gives me an error message "SSL not enabled" which I don't want anyway.Ĭonnecting by hand works ~]$ mysql -host=127.0.0.1 -user=myuser -port=3333 -p The following figure shows the initial settings of a new connection using the Standard TCP/IP over SSH. The path to the SSH known hosts file is configurable (see Section 3.2.6, SSH Preferences ). I don't want SSL as this is not needed and explicitly disable this in Setup New Connection -> SSL -> Use SSL -> "No" On Microsoft Windows, they are stored in a file created by MySQL Workbench under the user's folder, such as C:\Users\ username \.ssh\knownhosts. We can, however, ask the MySQL client to connect without SSL by using the command: mysql -h -u -p ssl-modeDISABLED mysql> status Connection id: 93.![]() So I configure a connection to the server via a tunnel on endpoint 127.0.0.1:3333. Open /home/.mysql/workbench/connections.xml. Get help from the PlanetScale support team, or join our GitHub discussion board to see how others are using PlanetScale.I want to connect to a remote mysql server and am using a ssh tunnel (I saw afterwards that it looks like this is possible directly in MySQL workbench but I'll look at that later). On account of these changes, the file paths. The following MySQL GUI applications have been tested and confirmed to work with PlanetScale databases: NOTE: We are in the process of modifying the configuration for many Bitnami stacks. Then youll see both: DBMS connection keep-alive interval (in seconds): DBMS connection read time out (in seconds): The latter is where youll want to up the limit from 600 to something a bit more.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |