Search Results
https://dev.mysql.com/doc/refman/8.4/en/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ... If ...
https://dev.mysql.com/doc/refman/8.4/en/windows-upgrading.html
Although upgrading between release series is not directly supported, the "Custom Setup" option allows defining an installation location as otherwise the MSI installs to the standard location, such as C:\Program Files\MySQL\MySQL Server 8.4\. For ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
Note If you do this, you should not access MyISAM tables from another program (such as from another MySQL server or with myisamchk) when the tables are in use. In this case, when the server opens a MyISAM table, it checks whether the table is marked ... The following options to mysqld can be used to change the behavior of MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
Use MySQL Server's clone plugin to transfer all the data from an existing replica to a clone. Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in MySQL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-16.html
(Bug #25650912) X DevAPI: Connector/J now supports the ability to send connection attributes (key-value pairs that application programs can pass to the server at connect time) for X Protocol connections. It is suitable for use with MySQL Server ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-connection-linux.html
Select Microsoft SQL Server as the source database system and fill out the remaining options as described in this section. Figure 10.43 SQL Server Connection Parameters Example on Linux Source RDBMS connection parameters include: Database System: ...For additional information about how to install a FreeTDS driver on Linux that will work with the MySQL Workbench migration wizard, see Section 10.5.2.2, ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
Each connection made to the MySQL server is represented by a separate connection tab. A server can be active or inactive when the connection tab for it is opened. The SQL query tab is a secondary tab that opens by default when you make a connection ... The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, and output ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
This is another way to transfer data from one MySQL server to another while performing a migration, and it complements the existing solutions. The premise is to use a generated script on the source server to create a dump that you move to the target ... This section summarizes many of the new features added to MySQL Workbench 6.3, in relation to the MySQL Workbench 6.2 ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables ...Setting ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-session.html
sessionVariables A comma or semicolon separated list of "name=value" pairs to be sent as "SET [SESSION] ..." to the server when the driver connects. Since Version 3.1.8 characterEncoding Instructs the server to set session system variables ...This ...