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/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
Row-Level Locking Table-Level Locking Choosing the Type of Locking Row-Level Locking MySQL uses row-level locking for InnoDB tables to support simultaneous write access by multiple sessions, making them suitable for multi-user, highly concurrent, ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
The administrator needs to execute a statement like this: mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host'; where your_mysql_name is the MySQL user name assigned to you and your_client_host is the host from which you connect ...Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that follows. row *************************** Id: 1 User: root Host: ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
The following instructions assume that you are already familiar with how to use MySQL Enterprise Backup to perform a backup; if that is not the case, please review the MySQL Enterprise Backup 4.1 User's Guide, especially Backing Up a Database Server. Also note the requirements described in Grant MySQL Privileges to Backup Administrator and Using MySQL Enterprise Backup with Group ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. As an administrator, connect to the server and create an ... The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. row *************************** OBJECT_TYPE: LOCKING SERVICE OBJECT_SCHEMA: ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Flush_commands The number of times the server flushes tables, whether because a user executed a FLUSH TABLES statement or due to internal server operation. Locked_connects The number of attempts to connect to locked user accounts. The MySQL server ...