数据库

MySQL

创建utf8字符集数据库

CREATE DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

创建用户

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

查看数据库大小

SELECT table_schema "数据库名", SUM(data_length + index_length) / 1024 / 1024 "数据库大小 (MB)" FROM information_schema.TABLES WHERE table_schema = 'your_database_name' GROUP BY table_schema;

查看数据表大小

SELECT table_name, ROUND((data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)' FROM information_schema.TABLES WHERE table_schema = 'your_database_name' AND table_name = 'your_table_name';