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/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 ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. DROP {PROCEDURE | ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
It removes privilege rows for the account from all grant tables. The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
If you are upgrading to MySQL 5.7 from an earlier version, be sure to update your grant tables to make sure that the event table exists. The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set either on the command line or in the my.cnf or my.ini file (Bug #26807). Events are executed by a special ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. Where can I ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
Also note the requirements described in Grant MySQL Privileges to Backup Administrator and Using MySQL Enterprise Backup with Group Replication. MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
Group communication connections as well as recovery connections, are secured using SSL. Configuring SSL for Group Replication Recovery Recovery is performed through a regular asynchronous replication connection. Once the donor is selected, the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
mysql> CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; mysql> FLUSH PRIVILEGES; If binary logging was disabled, enable it again once the user has been created using SET SQL_LOG_BIN=1;. Group ...