PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary users. (For a discussion of concepts involved in proxying, see Section 6.2.14, ...For example, put these lines in the server my.cnf file, adjusting the .so suffix for your platform as necessary: [mysqld] plugin-load-add=mysql_no_login.so After modifying my.cnf, restart the server to cause the new settings to take ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
On all platforms, MySQL Workbench is available and offers the ability to manage user accounts (see Chapter 29, MySQL Workbench ). Installation using the macOS installer generates an initial random password, which the installer displays to the user ...A password may already be assigned to the initial account under these circumstances: On Windows, installations performed using MySQL Installer give you the option of assigning a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. statement_latency The total wait time of timed statements for the user.
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION. To determine the ...If ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html
For example, the diagnostics() and execute_prepared_stmt() procedures use the debug option if it exists, but this option is not part of the sys_config table by default because debug output normally is enabled only temporarily, by setting the ...As ...The conventional relationship just described between options in the sys_config table and user-defined variables can be exploited to make temporary configuration changes that end when your session ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
--keyring-migration-user, --keyring-migration-password: The account credentials to use to connect to the running server. The user a server in key-migration mode runs as must have permission to read and write any local keyring files, such as the data ...Pausing keyring operations during an online migration is accomplished by connecting to the running server and setting its global keyring_operations system variable to OFF before key copying and ON after key ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. Once the cluster has entered single user mode, only the designated ...When entering single user mode, connections to all other API nodes are closed gracefully and all running transactions are ...You can also ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-secure-installation.html
Whether or not this option is used, mysql_secure_installation always prompts the user for a password. This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root accounts. You ...If the plugin is not installed, mysql_secure_installation prompts the user whether to install ...Normal usage is to connect to the local MySQL server; invoke mysql_secure_installation without arguments: ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html
For example, you might set up a common multi_admin account by executing the following commands for each server: $> mysql -u root -S /tmp/mysql.sock -p Enter password: mysql> CREATE USER 'multi_admin'@'localhost' IDENTIFIED BY 'multipass'; mysql> ...