PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts).
https://dev.mysql.com/doc/refman/8.0/en/automatic-start.html
To be current, you should update your option files to use the [mysql.server] and [mysqld_safe] groups instead. On Unix and Unix-like systems, you can invoke mysqld_safe, which tries to determine the proper options for mysqld and then runs it with ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE TABLE. The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for ...
https://dev.mysql.com/doc/refman/8.0/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes take place) writes updates and changes as “events” to the binary ...The information in the binary log is stored in different logging formats according to the database changes being ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
However, because the BLACKHOLE table does not actually store any data, UPDATE and DELETE triggers are not activated: The FOR EACH ROW clause in the trigger definition does not apply because there are no rows. The BLACKHOLE storage engine acts as a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Note While a compressed table is read only, and you cannot therefore update or add rows in the table, DDL (Data Definition Language) operations are still valid. Compressed storage format is a read-only format that is generated with the myisampack ...
https://dev.mysql.com/doc/refman/8.0/en/concurrent-inserts.html
If you specify HIGH_PRIORITY, it overrides the effect of the --low-priority-updates option if the server was started with that option. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
DNS SRV records also can be updated centrally by administrators when servers are added or removed from the configuration or when their host names are changed. In the Domain Name System (DNS), a SRV record (service location record) is a type of ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
There are additional write costs to consider when using a secondary index on a virtual column due to computation performed when materializing virtual column values in secondary index records during INSERT and UPDATE operations. A secondary index ...