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

grant insert,select on yourDatabaseName.* to 'yourUserName'@'localhost';

mysql> create user 'E妹妹a'@'localhost' identified by 'E妹妹a1二3';
Query OK, 0 rows affected (0.两6 sec)

mysql> grant insert,select on web.* to 'E妹妹a'@'localhost';
Query OK, 0 rows affected (0.两1 sec)

mysql> show grants for 'E妹妹a'@'localhost';

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