PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. A user ...This ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). Creating a foreign key constraint requires the REFERENCES privilege on the parent table. Such an index is created on the referencing ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The table has these columns: USER The user name part of an account. If a removed filter is assigned to any user ...The tables can be accessed only by users who have privileges for that ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
When you use the set command with mysql_config_editor to create a login path, you need not specify all possible option values (host name, user name, password, port, socket). The file location is the %APPDATA%\MySQL directory on Windows and the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-using-management-client.html
Cluster backups are created by default in the BACKUP subdirectory of the DataDir on each data node. The backup files created for a backup with a given backup_id are stored in a subdirectory named BACKUP-backup_id in the backup directory. Error: 1321 ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html
Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL monitor. Suppose the my.cnf file is as shown here: [mysql] user jon Trying to ...Due to this behavior, problems can occasionally arise when no value is provided for an option that expects ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Compressed tables can be created in file-per-table tablespaces or in general tablespaces.
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
(The server writes the random password to the error log.) Installation creates no anonymous-user accounts. Instead, establish such properties at account-creation time with CREATE USER or modify them afterward with ALTER USER. The server now requires ...To enable MySQL 5.7 clients to connect to 8.0 servers using accounts that authenticate using caching_sha2_password, the MySQL 5.7 client library and client programs support the caching_sha2_password client-side authentication plugin as of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
For this purpose, a failed connection attempt is one for which the client user and host match a known MySQL account but the provided credentials are incorrect, or do not match any known account. Determination of the applicable user name and host ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system database. For example: DROP USER 'jeffrey'@'localhost'; ...It removes privilege rows for the account from all grant ...Attempts to access such objects may ...