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/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/bit-type.html
The BIT data type is used to store bit values. The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...
https://dev.mysql.com/doc/refman/8.0/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/declare-local-variable.html
The value can be specified as an expression; it need not be a constant. If the DEFAULT clause is missing, the initial value is NULL. Local variables are treated like stored routine parameters with respect to data type and overflow checking. type ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade-with-mysqlbackup.html
As part of a provisioning approach you can use MySQL Enterprise Backup to copy and restore the data from a group member to new members. Deploy a new server instance, which must be running the same version of MySQL as the older member where the ...