Search Results
https://dev.mysql.com/doc/refman/8.4/en/differences-from-ansi.html
We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between the MySQL and standard SQL privilege systems. For example, in ...You must explicitly issue a REVOKE statement to revoke privileges for a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tzinfo-to-sql.html
If your system does not have a zoneinfo database, you can use the downloadable package described in Section 7.1.15, “MySQL Server Time Zone Support”. tz_file is the name of your time zone file: mysql_tzinfo_to_sql --leap tz_file | mysql -u root ... The mysql_tzinfo_to_sql program loads the time zone tables in the mysql ...It is used on ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
Using an Encrypted Connection MySQL client programs attempt to establish an encrypted connection if the server supports encrypted connections. $> cd /usr/local/mysql $> bin/mysql --user=user1 -p --host=192.0.2.24 --ssl-mode=VERIFY_CA ...The ...The ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
The following query determines whether the table that contains time zone names has any rows: mysql> SELECT COUNT(*) FROM mysql.time_zone_name; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ A count of zero indicates that the table is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
The server allocates mutex instruments for the plugins depending on how many they need and how many are available, as illustrated by the following sequence of statements: INSTALL PLUGIN plugin_a The server now has 150+40 = 190 mutex instruments. The ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
Instead, you can do one of the following: Tell mysqlbackup to query the end_lsn value from the last successful non-TTS backup as recorded in the backup_history table on the server using --incremental-base=history:last_backup or ...When creating an ...Each subsequent incremental backup is thus usually smaller in size than a differential backup, and is faster to make; that allows you to make very frequent incremental backups, and then enables you to restore the database to a more precise point in time when ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
Use this wizard to either export or import SQL generated from MySQL Workbench or with the mysqldump command. Access these wizards from either the Navigator area of the sidebar, or by selecting Server from the main menu, and then either Data Import ...Select each schema you want to export, optionally choose specific schema objects/tables from each schema, and generate the ...
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Applications can use the following guidelines to perform SQL-based ...The account used to authenticate a client determines which privileges the client ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source distributions. Within the server, the pluggable audit interface is implemented in the sql_audit.h and ...Note Other examples of plugins that use the audit plugin API are the query rewrite plugin (see The Rewriter Query Rewrite Plugin) and the Version Tokens plugin (see Version ...