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/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. Access to this table should never be granted to any nonadministrative accounts. A user who has access to modify ... Database administrators should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication I/O thread is currently reading from the source's ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...If binary log file position based replication is in use, when the replica restarts, it reads the two ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
For information on how to require users to use encrypted connections, see the discussion of the REQUIRE clause of the CREATE USER statement in Section 13.7.1.2, “CREATE USER Statement”. MySQL performs encryption on a per-connection basis, and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. In addition, for a non-transactional update, if a disk ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
The best strategy for provisioning such a replica is therefore to use mysqldump to create an appropriate dump file on each source, then use the mysql client to import the dump file on the replica. For example: mysql -u<user> -p<password> < ... If ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
As an administrator, connect to the server and create an account for a local user who connects from the ::1 local IPv6 host address: mysql> CREATE USER 'ipv6user'@'::1' IDENTIFIED BY 'ipv6pass'; For the permitted syntax of IPv6 addresses in account ...Invoke the mysql client to connect to the server using the new account: $> mysql -h ::1 -u ipv6user -pipv6pass Try some simple statements that show connection information: mysql> STATUS ...mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
They indicate the host where the MySQL server is running, and the user name and password of your MySQL account. $> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin ... To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
You can stop the MySQL server by executing this command: C:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply ...Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table has these columns: USERHOST The account profile name. The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The first index is GEN_CLUST_INDEX, which is a clustered index created by InnoDB if the table does not have a user-defined clustered index. There are six columns, three of which are hidden columns created by InnoDB (DB_ROW_ID, DB_TRX_ID, and ... You ...