FAQ Categories Show
Basic Usage A.1. What is a MySQL connection? Why might I need to create more than one? A.2. Does MySQL Workbench support the TLSv1.2 protocol? A.3. How do I create a MySQL database (schema) in MySQL Workbench? A.4. Is there an easy way to select all data from a table, and then see the results?
Workbench Functionality A.1. How do I use the SSL Certificate wizard to enable SSL for both my MySQL server and MySQL client? A.2. How do I copy my saved MySQL connections in Workbench to a different computer? A.3. How can I view my MySQL Workbench query history? A.4. Can I preserve a results tab rather than have it refresh every time I execute a statement? A.5. How does the embedded web browser functionality work? For example, clicking Workbench Forum on the Home screen opens the forum in its own embedded MySQL Workbench tab. A.6. How does MySQL Workbench increase import performance?
Workbench Behavior A.1. Why do my query results sometimes say Read Only but other times I can edit data in the results grid? A.2. I'm attempting to execute a DELETE query but the query fails with an "Error Code: 1175" error. How do I proceed? A.3. My MySQL server connection is timing out with an error like "Error Code: 2013. Lost connection to MySQL server during query". Can I adjust the timeout? A.4. What do the column flag acronyms (PK, NN, UQ, BIN, UN, ZF, AI, G) in the MySQL Workbench Table Editor mean?
Data Management A.1. How do I import comma-separated values (CSV) data into MySQL using Workbench? A.2. How do I export MySQL data to a plain text file with a format such as CSV, JSON, or XML? A.3. How to export (save) a MySQL database to a text file?
General How do I check MySQL query timeout?MySQL has its wait_timeout variable default value set to 28800 seconds (8 hours).. SHOW VARIABLES.. SHOW SESSION VARIABLES.. SHOW GLOBAL VARIABLES.. How do I change timeout in MySQL?Change the MySQL timeout on a server. Log in to your server by using Secure Shell® (SSH).. Use the sudo command to edit my. ... . Locate the timeout configuration and make the adjustments that fit your server. ... . Save the changes and exit the editor.. What is wait timeout in MySQL?If wait_timeout is 1800 (30 Minutes), the DB Connection will close in 30 minutes if the connection is idle (indicated by Sleep in the command column of the processlist). If connect_timeout is 10, then mysqld will reject you if you cannot login (authenticate) in 10 seconds.
What is query timeout?The query-timeout command is used to indicate the length of time in seconds that the appliance waits for an SQL request to complete. The measured duration is from when the service sends the request to and receives the results from the SQL data server. The query timeout must be greater than the connection timeout.
|