What are the minimum MySQL user permissions to allow optimization and repair?-Mysql Tutorial-php.cn

What are the minimum MySQL user permissions to allow optimization and repair?

PHPz

Release： 2023-09-15 13:33:08

forward

993 people have browsed it

允许优化和修复的最低 MySQL 用户权限是多少？

#select and insert statements are the minimum MySQL user permissions required to allow optimization and repair.

You can grant insert and select permissions to users using the following syntax -

grant insert,select on yourDatabaseName.* to &#39;yourUserName&#39;@&#39;localhost&#39;;

Copy after login

First, this is the query that creates the user -

mysql> create user &#39;Emma&#39;@&#39;localhost&#39; identified by &#39;Emma123&#39;;
Query OK, 0 rows affected (0.26 sec)

Copy after login

This is the one that funds the above user Query -

mysql> grant insert,select on web.* to &#39;Emma&#39;@&#39;localhost&#39;;
Query OK, 0 rows affected (0.21 sec)

Copy after login

Here is the query to display all authorizations for the above user -

mysql> show grants for &#39;Emma&#39;@&#39;localhost&#39;;

Copy after login

This will produce the following output -

+-------------------------------------------------------+
| Grants for Emma@localhost                             |
+-------------------------------------------------------+
| GRANT USAGE ON *.* TO `Emma`@`localhost`              |
| GRANT SELECT, INSERT ON `web`.* TO `Emma`@`localhost` |
+-------------------------------------------------------+
2 rows in set (0.00 sec)

Copy after login

The above is the detailed content of What are the minimum MySQL user permissions to allow optimization and repair?. For more information, please follow other related articles on the PHP Chinese website!