Statements that grant MySQL user permissions

The statements described below are used to grant MySQL user permissions. These statements can be used to grant database developers the permission to create tables, indexes, views, stored procedures, and functions... And other MySQL user permissions.

Grant permissions to create, modify, and delete MySQL Data Table structures.

Grant create on testdb. * to developer @ '192. 192.% ';
Grant alter on testdb. * to developer @ '192. 192.% ';
Grant drop on testdb. * to developer @ '192. 192.% ';

Grant the MySQL foreign key operation permission.

Grant references on testdb. * to developer @ '192. 192.% ';

Grant the permission to operate MySQL temporary tables.

Grant create temporary tables on testdb. * to developer @ '2017. 192.% ';

Grant the permission to operate MySQL indexes.

Grant index on testdb. * to developer @ '192. 192.% ';

Grant permissions to operate the MySQL view and view the source code.

Grant create view on testdb. * to developer @ '192. 192.% ';
Grant show view on testdb. * to developer @ '192. 192.% ';

Grant permissions to operate MySQL stored procedures and functions.

Grant create routine on testdb. * to developer @ '192. 192.% '; -- now, can show procedure status
Grant alter routine on testdb. * to developer @ '192. 192.% '; -- now, you can drop a procedure
Grant execute on testdb. * to developer @ '192. 192.% ';

The preceding statements describe MySQL user permissions.

Insufficient mysql Indexes

MySQL database connection command

MySql connection string description

Example of a java mysql Stored Procedure

Introduction to mysql trigger new old