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-usage.html
This differs from the usual MySQL convention for statements such as CREATE USER and GRANT, for which you quote the user and host parts of an account name separately ('user_name'@'host_name'). Grant the SUPER privilege so that the firewall ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
NO_AUTO_CREATE_USER Prevent the GRANT statement from automatically creating new user accounts if it would otherwise do so, unless authentication information is specified. It is preferable to create MySQL accounts with CREATE USER rather than GRANT.
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
A block can include either a config or user type key; config is the default type if one is not defined. A user block should be defined for each user to be created during the product installation. Note The user type key is not supported when a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 80284 PROCESSLIST_STATE: NULL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html
As an efficiency measure to minimize the number of direct reads from the sys_config table, sys schema functions that use a value from this table check for a user-defined variable with a corresponding name, which is the user-defined variable having ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. The user name is specified by the MASTER_USER option on the CHANGE MASTER TO command when ...You can choose to create a different account for each replica, or connect to the source using the same account for each ...
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> ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-secure-installation.html
You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit anyone to access databases with names that start with test_. If the plugin is not installed, mysql_secure_installation ... This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
The client can do this by using the PASSWORD() function to generate a password hash, or by using a password-generating statement (CREATE USER, GRANT, or SET PASSWORD). MySQL lists user accounts in the user table of the mysql database. Each MySQL ...
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 ...