Go to Edit -> Preferences -> SQL Editor and there you’ll see: DBMS connection keep-alive interval (in seconds): 600 DBMS connection read time out (in seconds): 600 DBMS connection time out (in seconds): 60 The DBMS connection keep-alive interval means how often Workbench sends keep-alive request to the server to keep the connection alive. Since … Read more
The problem here is the difference in syntax across different MySQL server versions. It seems that MySQL Workbench 8.0.12 is auto-generating CREATE UNIQUE INDEX statement for the MySQL server version 8.0. From the MySQL Server 8.0 Docs, the syntax for CREATE INDEX is: CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,…) … Read more
pull the scroll bar downward. i had the same issue but all i needed to do was to extend the navigation menu.
In MySql Workbench version 8.0 you can just follow the next steps Go to Server tab Go to Database Export This opens up something like this Select the schema to export in the Tables to export Click on Export to Self-Contained file Check if Advanced Options… are exactly as you want the export Click the … Read more
This command almost gives you what you want, and it even works with a remote server. The only caveat is that it generates a TSV file (fields are separated by a tab). mysql mydb -e “select * from mytable” -B > mytable.tsv But you could convert it to CSV using sed, as suggested in this … Read more
You need to install the following in order to run the current version of MySQL Workbench: Microsoft .NET Framework 4.5.2 Microsoft Visual C++ 2019 Redistributable for Visual Studio 2019 See: dev.mysql.com/doc/workbench/en/wb-requirements-software.html .
Background: This problem occurs when the binary string values (BINARY/VARBINARY type) are returned in the results. The binary strings contain the zero bytes and for some reason, apparently security, have not been shown by default. More details about binary strings here. Even in the reported example SELECT INET_NTOA(167773449), the function returns binary string. Check this … Read more
I had this exact same issue. The solution provided in this thread (same as the_nuts answer) is to uninstall 6.3.6 and install 6.3.4 from the archived versions: https://downloads.mysql.com/archives/workbench/
Open MySQL Workbench Create the old server’s connection (if you haven’t it) Create the new server’s connection (if you haven’t it) Go to Server Administration and click Manage Import / Export Select old server Select all schemas in Export to Disk tab In options select Export to Self-Contained File, wait until it finished Back to … Read more
I had the same problem today. The only way I found to fix it was: executing the install file select “Reconfigure” over the mysql server In Authentication Method tab, select “Use Legacy Authentication Method” It should fix your problem.