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/multiple-windows-command-line-servers.html
Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that contains the grant tables. The procedure for starting a single MySQL server manually from the command line is described in Section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-single-user-mode.html
Once the cluster has entered single user mode, only the designated API node is granted access to the database. Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL ...
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/ndb-restore-to-different-version.html
Distributed grant tables created in NDB 7.6 and earlier are not supported in NDB 8.0. The following two sections provide information about restoring a native NDB backup to a different version of NDB Cluster from the version in which the backup was ...
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). Note The information in this section applies fully only before MySQL 5.7.5, and ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
Access to this table should never be granted to any nonadministrative accounts. Database administrators should use the following guidelines to keep passwords secure. MySQL stores passwords for user accounts in the mysql.user system table. Account ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ... | wait/synch/rwlock/sql/LOCK_grant | YES | YES | | wait/synch/rwlock/sql/LOGGER::LOCK_logger | YES | ... The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | +---------------------------------------------------+---------+-------+ ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ... | wait/synch/rwlock/sql/LOCK_grant | YES | YES | | wait/synch/rwlock/sql/LOGGER::LOCK_logger | YES | ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ... | wait/synch/rwlock/sql/LOCK_grant | YES | YES | | wait/synch/rwlock/sql/LOGGER::LOCK_logger | YES | ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | +---------------------------------------------------+---------+-------+ ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
Any privileges granted specifically for a renamed table or view are not migrated to the new name. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE ...