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/two-digit-years.html
Remember that these rules are only heuristics that provide reasonable guesses as to what your data values mean. If the rules used by MySQL do not produce the values you require, you must provide unambiguous input containing 4-digit year values. To ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-system-monitoring.html
To be able to monitor the generated SQL, the Performance Schema tables must be enabled. Issue: mysql-py> \sql SELECT enabled FROM performance_schema.setup_consumers WHERE NAME = 'events_statements_history' +---------+ | enabled | +---------+ | YES | ... For general X Plugin monitoring, use the status variables that it ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
Components must be loaded into the server before they can be used. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles component loading and ...The ...MySQL supports manual component loading at runtime and automatic loading during server ...
https://dev.mysql.com/doc/refman/8.0/en/installing-development-tree.html
Prerequisites for Installing from Development Source Setting Up a MySQL Git Repository Prerequisites for Installing from Development Source To install MySQL from a development source tree, your system must satisfy the tool requirements listed at ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-admin.html
Database administrators should use the following guidelines to keep passwords secure. Account passwords can be expired so that users must reset them. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) ...MySQL stores passwords for user accounts in the mysql.user system ...Access ...
https://dev.mysql.com/doc/refman/8.0/en/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. mysqldump adds a SET @@SESSION.sql_log_bin=0 statement to a dump file from a server where GTIDs are in use, which disables binary logging while the dump file is ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. This means that anyone can attempt to connect to the server using any user name, so you cannot make a database secure in any way unless all MySQL accounts have passwords. Warning ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...Standard ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-installation.html
To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). To install the validate_password component, use this statement: INSTALL COMPONENT ... This ...For general information about installing and uninstalling components, see Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/windows-extract-archive.html
If you do not install MySQL at C:\mysql, you must specify the path to the install directory during startup or in an option file. Extract the install archive to the chosen installation location using your preferred file-compression tool. To install ...Make sure that you are logged in as a user with administrator ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. The effect is the same as issuing a START TRANSACTION followed by a SELECT from any InnoDB table. MySQL enables extra ...SET autocommit disables or enables the default autocommit mode for the current ...