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/show-processlist.html
If you have the PROCESS privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
To change mysqld to run as a normal unprivileged Unix user user_name, you must do the following: Stop the server if it is running (use mysqladmin shutdown). For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should ... On Windows, you can run the server as a Windows service using a normal user ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system database because it adds a row to the mysql.func system table to register the function. If the server is started with the --skip-grant-tables option, functions registered in the ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
DCL Data control language, a set of SQL statements for managing privileges. These terms are commonly used in information about the MySQL database server. This glossary originated as a reference for terminology about the InnoDB storage engine, and ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
Also note the requirements described in Grant MySQL Privileges to Backup Administrator and Using MySQL Enterprise Backup with Group Replication. MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been requested and how many numbers are granted per request. The INNODB_SYS_TABLESTATS table provides a view of low-level status information about ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
See Section 13.1.33, “RENAME TABLE Statement”.) Privileges granted specifically for the renamed table are not migrated to the new name. Online support details, syntax examples, and usage notes for DDL operations are provided under the following ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. The following procedure shows how to configure MySQL to ...
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
Example: “To reload the grant tables, use the FLUSH PRIVILEGES statement.” Text in this style indicates input that you type in examples. This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44.
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
The server caches information in memory as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. This memory is not released by the corresponding REVOKE, DROP USER, DROP SERVER, and UNINSTALL PLUGIN statements, so for a ...