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/firewall-reference.html
The mysql.firewall_users table lists names and operational modes of registered firewall account profiles. The table has the following columns (with the corresponding Information Schema MYSQL_FIREWALL_USERS table having similar but not necessarily ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-client-commands.html
Commands for the event logs are given in Section 21.6.3, “Event Reports Generated in NDB Cluster”; commands for creating backups and restoring from them are provided in Section 21.6.8, “Online Backup of NDB Cluster”. CREATE NODEGROUP ... In ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
As a result, it is possible to create the account and set its password without naming the plugin explicitly: CREATE USER 'sha256user'@'localhost' IDENTIFIED BY 'password'; Another consequence of setting default_authentication_plugin to ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
Suppose that you want to connect using an account that has no special encryption requirements or that was created using a CREATE USER statement that included the REQUIRE SSL clause. For example: mysql --ssl-mode=REQUIRED mysqldump ...Assuming that ...Instructions for creating any required certificate and key files are available in Section 6.3.3, “Creating SSL and RSA Certificates and ... Several ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-user-by-current-bytes.html
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Generally, to install MySQL as a Windows service you should be logged in using an account that has administrator rights. Note Users ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
--user=user_name, -u user_name Command-Line Format --user=user_name Type String The user name of the MySQL account to use for connecting to the server. --connect-expired-password Command-Line Format --connect-expired-password Indicate to the server ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
If you did not have binary logging enabled when you configured the user credentials on s1, you must create the replication user on s2. In this case, connect to s2 and issue: SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT ...17.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O or SQL thread used on replica hosts. For system user, there is no host specified in the Host ...