Административные вопросы

Удаление анонимных пользователей, запрет логина с удаленных хостов:

mysql_secure_installation

mysql> SELECT host, USER FROM mysql.user;
+-----------+------------------+
| host      | USER             |
+-----------+------------------+
| localhost | debian-sys-maint |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+

Так удобно делить пользователей по типам - тестовая и рабочая база.

db-prefix.sql

CREATE USER 'user'@'localhost' IDENTIFIED BY 'somePassword';
CREATE USER 'user_test'@'localhost' IDENTIFIED BY 'somePassword_test';
GRANT ALL PRIVILEGES ON  `run_%`.* TO 'user'@'localhost';
GRANT ALL PRIVILEGES ON  `test_%`.* TO 'user_test'@'localhost';
FLUSH PRIVILEGES;

db-all-hosts.sql

CREATE USER 'user'@'%' IDENTIFIED BY 'somePassword';

create-db.sql

CREATE DATABASE `name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

db-size.sql

SELECT table_schema "database_name", SUM( data_length + index_length )/1024/1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;