Search Results
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
You can generate new queries from existing ones that are similar by copying and editing script files. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Switching the replication format at runtime is not recommended when any temporary tables exist, because temporary tables are logged only when using statement-based replication, whereas with row-based replication and mixed replication, they are not ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
If the server unexpectedly exited between those two operations, the transaction would be rolled back by InnoDB at restart but still exist in the binary log. The binary log contains “events” that describe database changes such as table creation ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
On a replica the same table exists but using the MyISAM engine. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE engine, look in the sql ...
https://dev.mysql.com/doc/refman/8.4/en/bug-reports.html
When you provide an example of the problem, it is better to use the table names, variable names, and so forth that exist in your actual situation than to come up with new names. Before posting a bug report about a problem, please try to verify that ...
https://dev.mysql.com/doc/refman/8.4/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
Installing SHA-2 Pluggable Authentication The caching_sha2_password plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. MySQL provides two ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
You can always run mysqladmin version to check whether the Unix socket file that mysqladmin is trying to use really exists. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-create.html
For example, to specify a directory of C:\temp, use these lines: [mysqld] tmpdir=C:/temp The C:\temp directory must exist and have sufficient space for the MySQL server to write to. If you get an error of the following type for some queries, it ...
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
(It is a good idea to assign passwords to MySQL accounts in any case, but especially so when other login accounts exist on the server host.) See Section 2.9.4, “Securing the Initial MySQL Account”. On Windows, you can run the server as a ...