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/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/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/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/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/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/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/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. The default user name is ODBC on ...