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/preface.html
Oracle and/or its affiliates reserve any and all rights to this documentation not expressly granted above. This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. Differences between minor versions of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 13.7.4.1, “SET Syntax for Variable Assignment”, and Section 5.1.8, “Using System Variables”. Most of these program variables also ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Table_locks_immediate The number of times that a request for a table lock could be granted immediately. Table_locks_waited The number of times that a request for a table lock could not be granted immediately and a wait was needed. The MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
It is important that the MySQL server be run using an unprivileged (non-root) login account. For further instructions for running MySQL as an unprivileged user, see Section 6.1.5, “How to Run MySQL as a Normal User”. If the server is unable to ... This section describes how start the server on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and ... The validate_password plugin serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft Windows. The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/alter-function.html
(That privilege is granted automatically to the function creator.) If binary logging is enabled, the ALTER FUNCTION statement might also require the SUPER privilege, as described in Section 23.7, “Stored Program Binary Logging”. ALTER FUNCTION ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
By default, that privilege is granted automatically to the procedure creator. This behavior can be changed by disabling the automatic_sp_privileges system variable. ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... This ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access privileges. The list of ... Once you know how to enter SQL statements, you are ready to access a ...