PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/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/innodb-parameters.html
innodb_default_row_format Command-Line Format --innodb-default-row-format=value System Variable innodb_default_row_format Scope Global Dynamic Yes Type Enumeration Default Value DYNAMIC Valid Values REDUNDANTCOMPACTDYNAMIC The ... System variables ...
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/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/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/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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
Administrators can prevent users from creating stored objects that specify highly privileged DEFINER accounts by not granting them the SUPER privilege. This remains true if the privileges needed to create the object are revoked from the account of ...If a definition omits the DEFINER attribute, the default object definer is the user who creates ...The DEFINER Attribute The SQL SECURITY Characteristic Examples Orphan Stored Objects Risk-Minimization Guidelines The ...