PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
Database privilege changes take effect the next time the client executes a USE db_name statement. Note Client applications may cache the database name; thus, this effect may not be visible to them without actually changing to a different database.
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups.html
How you back up a database depends on its size and whether you are backing up only the data, or the data and the replica state so that you can rebuild the replica in the event of failure. There are therefore two choices: If you are using replication ... To use replication as a backup solution, replicate data from the source to a replica, and then back up the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
Upgrade Procedure With Table Repair Or Rebuild Some upgrades may require that you drop and re-create database objects when you move from one MySQL series to the next. Perform any table repair or rebuilding operations needed to re-create database ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
To revoke all privileges, use the second syntax, which drops all global, database, table, column, and routine privileges for the named user or users: REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... To use this REVOKE syntax, you must have ...The REVOKE statement enables system administrators to revoke privileges from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/server-side-help-support.html
This information is stored in several tables in the mysql database (see Section 5.3, “The mysql System Database”). Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE ... SHOW CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
The FROM clause, if present, restricts the tables shown to those present in the db_name database. SHOW OPEN TABLES output has these columns: Database The database containing the table. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Federated: Offers the ability to link separate MySQL servers to create one ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Parameters in_db VARCHAR(64): The name of the database in which to check for table existance. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.