mysql生产环境部署，创建用户，分配最少权限

具体请参考文档：
​​​​​​​​​​​​​​​​​​​​​Getting Started | Accessing data with MySQL

先创建用户，授予所有权限

mysql> create database db_example; -- Creates the new database
mysql> create user 'springuser'@'%' identified by 'ThePassword'; -- Creates the user
mysql> grant all on db_example.* to 'springuser'@'%'; -- Gives all privileges to the new user on the newly created database

当上到生产环境前，只授予增删改查权限。

mysql> revoke all on db_example.* from 'springuser'@'%';
mysql> grant select, insert, delete, update on db_example.* to 'springuser'@'%';