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/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. Anyone using MySQL on a ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-file-context.html
The /var/lib/mysql-files/ directory is intended to be used for operations such as SELECT ... The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the files could be denied. The ...
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
For details, see Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”, Section 5.4.3, “The General Query Log”, and Section 5.4.5, “The Slow Query Log”. MySQL Server has several logs that can help you find ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
Use of this option somewhat limits LOAD DATA and SELECT ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program Options”. The most common methods are to ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
(In particular, you can change your own password.) To see which account the server authenticated you as, invoke the CURRENT_USER() function: SELECT CURRENT_USER(); If a FOR user clause is given, the account name uses the format described in Section ... SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user ...
https://dev.mysql.com/doc/refman/5.7/en/show-character-set.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW Statements”. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all ...
https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW Statements”. SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW Statements”. SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. To name the account, ...