Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
The new password becomes the primary password, but clients can use the account to connect to the server using either the primary or secondary password. Important Under some circumstances, SET PASSWORD may be recorded in server logs or on the client ... SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
To change the number of messages the server can store, change the value of max_error_count. The sql_notes system variable controls whether note messages increment warning_count and whether the server stores them. SHOW WARNINGS [LIMIT [offset,] ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
(By contrast, the index file descriptor is shared between all sessions.) The table_open_cache and max_connections system variables affect the maximum number of files the server keeps open. When the table cache fills up, the server uses the following ... When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics.html
The Server Telemetry Metrics Service and the Server Metrics Instrument Service enable you to register and query telemetry meters, metrics, and metric measurements, in order to periodically export these measurements using the OpenTelemetry protocol.
https://dev.mysql.com/doc/refman/8.4/en/validate-password-transitioning.html
In this case, the server attempts to use the component, falling back to the plugin if the component is unavailable.) Install the validate_password component: INSTALL COMPONENT 'file://component_validate_password'; Test the validate_password ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). If necessary, configure the plugin directory location by setting the value of plugin_dir at ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.corruption.html
Here are some suggestions for dealing with it: The problem can occur if the MySQL server is too busy. Reboot the database server and the storage device to see if the problem persists. If the problem persists after the database server and the storage ...170225 10:46:26 PCR1 ERROR: Page at offset 0 in D:/temp/5.7_source/test/emp2.ibd seems corrupt! A corruption problem can have different ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-process.html
In general, this is what happens when you run a backup operation with mysqlbackup: The InnoDB data files, redo log, binary log, and relay log files (except for the log files currently in use) are being copied into the backup, while the database ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-generated.html
These parameters are also checked during a restore operation for their compatibility with your target server's configuration. server-my.cnf: Contains values of the backed-up server's global variables that are set to non-default values. Inside the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.html
Normally, the restoration process requires the database server to be already shut down (or, at least not operating on the directory you are restoring the data to), except for a partial restore. Example 5.1 Restoring a Database Server mysqlbackup ...