Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-reserved-words.html
For example, a table column named rank on a MySQL 5.7 source that is replicating to a MySQL 8.4 replica could cause a problem because RANK became a reserved word in MySQL 8.0. Replication can fail in such cases with Error 1064 You have an error in ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
For example, the InnoDB system tablespace, undo tablespace, and redo log might be stored in an alternative location. Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON REPLICA to prevent them from ... You can add another replica to an existing replication configuration without stopping the source ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter.html
Table 4.6 Conditions that affect default --bootstrap values Condition Description --conf-base-port Modifies generated bind_port values for each connection type. The supplied hostname is written to the host_name field of the ... mysqlrouter Option ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not followed by UPDATE or DELETE. The following DML: CALL, INSERT, UPDATE, DELETE, REPLACE, IMPORT TABLE, LOAD DATA, LOAD ...EXPLAIN, DESCRIBE, or DESC which are not followed by UPDATE or ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
To encrypt data in an InnoDB file-per-table tablespace, run ALTER TABLE tbl_name ENCRYPTION = 'Y'. To encrypt a general tablespace or the mysql tablespace, run ALTER TABLESPACE tablespace_name ENCRYPTION = 'Y'. Does the transportable tablespaces ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
Alternatively, on any platform, you can reset the password using the mysql client (but this approach is less secure): Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option. If you know the root password and want to ... If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html
Table 6.1 Methods to Export or Import data in MySQL Workbench GUI Location Data Set Export Types Import Types Additional Details Object Browser context menu Tables JSON, CSV JSON, CSV Simple table operations, includes moderate control over the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
The following table shows a comparison between each DBMS product supported by the Migration Wizard and MySQL. Table 10.1 Conceptual equivalents between supported DBMS products and MySQL Concept MS SQL Server Sybase ASE PostgreSQL MySQL Note ...
https://dev.mysql.com/doc/connectors/en/connector-j-upgrading-to-8.0.html
Applications that used to catch the removed exceptions should now catch the corresponding exceptions listed in Table 3.3 below. Note Some of these Connector/J 5.1 exceptions are duplicated in the com.mysql.jdbc.exception.jdbc4 package; that is ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
3.14.6: Updating a table that contains a primary key that is either FLOAT or compound primary key that uses FLOAT fails to update the table and raises an exception. The security manager on the MySQL server uses its grant tables to determine whether ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...