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/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. Access to this table should never be granted to any nonadministrative accounts. A user who has access to modify ... Database administrators should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. This option tells MySQL not to trust the information in the .MYI file header and to re-create it using information from ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
In addition, you cannot use FOR UPDATE as part of the SELECT in a statement such as CREATE TABLE new_table SELECT ... (If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being ...
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
They indicate the host where the MySQL server is running, and the user name and password of your MySQL account. $> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin ... To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
You can stop the MySQL server by executing this command: C:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply ...Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
Otherwise, the table must be created on the same MySQL server instance into which it is being imported. If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not done. For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
Along with the JSON data type, a set of SQL functions is available to enable operations on JSON values, such as creation, manipulation, and searching. JSON columns, like columns of other binary types, are not indexed directly; instead, you can ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-binary.html
We assume that you have placed a copy of the archive in the directory C:\Documents and Settings\username\My Documents\Downloads on the computer having the IP address 198.51.100.20, where username is the name of the current user. (You can obtain this ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
If there is no user context, this value can be NULL. The value need not actually be a “user”; the meaning depends on the application. Functions that implement the keyring function interface pass the value of CURRENT_USER() as the user_id value ... MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later ...