Some notes on mysql create routine permissions

1. If the user has the create routine permission, he can create a procedure | function.

2. If a user creates a procedure | function, MySQL will automatically grant him the alter routine and execute permissions for the procedure | function.

3. Example:

User root creates a spuser@'localhost' user and grants it the create procedure permission

grant create routine on tempdb.* to spuser@'localhost' identified by '123456';

Create a routine with the spuser@'localhost' user

delimiter go
create procedure sp_hello_world()
begin
  select 'hello world';
end 
go

delimiter ;

Check the permissions of spuser@'localhost' again

mysql> show grants;
+---------------------------------------------------------------------------------------------------------------+
| Grants for spuser@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'spuser'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' |
| GRANT CREATE ROUTINE ON `tempdb`.* TO 'spuser'@'localhost' |
| GRANT EXECUTE, ALTER ROUTINE ON PROCEDURE `tempdb`.`sp_hello_world` TO 'spuser'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+

The above description of mysql create routine permissions is all I have to share with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.

You may also be interested in:

Detailed explanation of the solution to the error in creating a user and granting permissions in mysql8.0
How to open external network access rights for mysql
Detailed explanation of MySQL user rights verification and management methods
Summary of MySQL stored procedure permission issues
How to modify mysql permissions to allow hosts to access
Solution to the problem that the configuration file my.cnf in MySQL cannot be started due to permission issues
Detailed explanation of using Dockerfile to build MySQL image and implement data initialization and permission setting
Example of how to create a local user in mysql and grant database permissions
Enable remote access rights for MySQL under Linux and open port 3306 in the firewall
Mysql: The user specified as a definer (''xxx@''%'') does not exist solution

<<: How to assign a public IP address to an instance in Linux

>>: Problems with using wangeditor rich text editing in Vue