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/debugging-server.html
You should also read the OS-specific section in this manual for problems that may be unique to your environment. This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables ... If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe ...
https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
Most of these can also be found in other places in this manual. This section lists environment variables that are used directly or indirectly by MySQL. If this variable is set, its value overrides the default for $HOME/.mysql_history. Options on ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rotation.html
To rename an error log file, do so manually before flushing. For information about handling this case, see Section 7.4.6, “Server Log Maintenance”. If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. (See next item.) DISABLED: This value renders the Event Scheduler nonoperational. It is also possible to use 0 for OFF, ...When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
Suppose also that this user has the SELECT privilege for myschema, but no other privileges for this schema. In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
Passwords can be expired manually, and on the basis of a policy for automatic expiration (see Section 8.2.15, “Password Management”). For any operation not permitted within the session, the server returns an ER_MUST_CHANGE_PASSWORD error: mysql> ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-connectors-apis.html
For common questions, issues, and answers relating to the MySQL Connectors and other APIs, see the following areas of the Manual: Using C API Features Connector/ODBC Notes and Tips Connector/NET Programming MySQL Connector/J Developer Guide .
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
The implication of this is that, at any given time, the replica is not guaranteed to be in synchrony with the source unless you take some special measures. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW ... In ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
For example, assets such as pharmaceutical research results, oil field exploration results, financial contracts, or personal data of law enforcement informants may require encryption. How is InnoDB data-at-rest encryption different from encryption ...Is data decrypted for users who are authorized to see it? ...