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/bug-reports.html
If your question is related to the privilege system, please include the output of mysqladmin reload, and all the error messages you get when trying to connect. When you test your privileges, you should execute mysqladmin reload version and try to ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
The server or client program might not have the proper access privileges for the directory that holds the Unix socket file or the socket file itself. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
Creating a foreign key constraint requires the REFERENCES privilege on the parent table. Warning ER_NO_REFERENCED_ROW_2 and ER_ROW_IS_REFERENCED_2 error messages for foreign key operations expose information about parent tables, even if the user has ... 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/downgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. SQL statements can be executed using the mysql command-line ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. Many server system variables are ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
EXPLAIN requires the same privileges required to execute the explained statement. Additionally, EXPLAIN also requires the SHOW VIEW privilege for any explained view. In practice, the DESCRIBE keyword is more often used to obtain information about ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
(InnoDB does not have an equivalent setting.) This variable can be changed while the server is running, but you must have privileges sufficient to set global system variables (see Section 5.1.8.1, “System Variable Privileges”). You can exert ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. ORDINAL_POSITION is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
Like the output from the SHOW PROCESSLIST statement, the PROCESSLIST table provides information about all threads, even those belonging to other users, if you have the PROCESS privilege. Otherwise (without the PROCESS privilege), nonanonymous users ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...