Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-tzinfo-to-sql.html
The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name: mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql If your time zone needs to account for leap seconds, invoke ... The mysql_tzinfo_to_sql program loads the time zone tables in the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
Because mysqlbinlog does not know in advance whether the rest of the log contains row events, by default it displays the format description event using a BINLOG statement in the initial part of the output. The following examples illustrate how ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld.html
For information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing MySQL. mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. MySQL Server ...
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%login%'; +----------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------+---------------+ | mysql_no_login | ACTIVE | ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-many-tables.html
Since this overhead only applies to the initial table open operation, to “warm up” a table for later use, access it immediately after startup by issuing a statement such as SELECT 1 FROM tbl_name LIMIT 1. If you have configured non-persistent ...
https://dev.mysql.com/doc/refman/8.4/en/option-modifiers.html
However, you may want to disable it in some instances, such as when sending the output of mysql into another program that expects to see only data and not an initial header line. Some options are “boolean” and control behavior that can be ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
When the server reads the grant tables, it initializes state information for each account regarding whether failed-login tracking is enabled, whether the account is currently temporarily locked and when locking began if so, and the number of ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...