Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
When upgrading to MySQL 8.4.4 or later, it is recommended that you drop any spatial indexes beforehand, then re-create them after the upgrade is complete. Alternatively, you can drop and re-create such indexes immediately following the upgrade, but ... Before upgrading to MySQL 8.4, review the changes described in the following sections to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
If the connection drops, it is possible that the session associated with the connection on the server side will still be running if the server has not yet detected that the client is no longer connected. The MySQL client library can perform an ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-setup.html
To compile and install a plugin library file, use the instructions in Section 4.4.3, “Compiling and Installing Plugin Libraries”. To make the library file available for use, install it in the plugin directory (the directory named by the ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
If adding a new session to the cache causes the number of cached sessions to exceed the defined maximum, the oldest cached session is dropped to allow the newest to be cached. If adding a new session to the cache causes the number of cached sessions ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/workbench/en/wb-generating-php.html
This example will use the sakila database, with the query being: SET @last_update = '2006-02-14'; SELECT actor_id, first_name, last_name, last_update FROM actor WHERE last_update > @last_update; While in the SQL editor, choose Tools, Utilities, Copy ... MySQL Workbench can be used to generate PHP code with the bundled PHP plugin, by using the Tools, Utilities, Copy as PHP Code menu ...
https://dev.mysql.com/doc/workbench/en/wb-importing-sql-script.html
For this tutorial, use the sakila database script, which you can find by visiting the https://dev.mysql.com/doc/index-other.html page. This is the script that contains the data definition statements for the sakila database. After you have expanded ...Open MySQL Workbench, select the models view from the sidebar in the home screen, click (>) next to Models, and then click Reverse Engineer MySQL Create ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install-odbc-drivers.html
You can also use it to create a data source for a specific database instance, to be connected using a previously configured driver. Typically you need to provide a name for the data source (the DSN), in addition to the database server IP, port, ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install.html
The MySQL Workbench Migration Wizard uses ODBC to connect to a source database, except for MySQL. You will need the ODBC driver installed that corresponds to the database you want to migrate from. The following figure shows the general components ...For example, PostgreSQL can be migrated with the psqlodbc ODBC driver; Microsoft SQL Server can be migrated using the native Microsoft SQL Server driver on Windows or with FreeTDS on Linux and ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-data-migration-setup.html
Transfers data from the source RDBMS to the target MySQL database (see the figure that follows). Options: Truncate target tables before copying data: In case the target database already exists, this will delete said data. This is the number of ...