1.查看系統用戶 ~~~ SELECT User, Host, Password FROM mysql.user; ~~~ 2.修改配置文件 ``` vim /etc/mysql/my.conf 找到bind-address = 127.0.0.1這一行 改為bind-address = 0.0.0.0即可 ``` 3.為需要遠程登錄的用戶賦予權限 ***** 4.查詢數據庫中個表的占用量 ``` select table_schema as 'cloud_agent_prod', table_name as '表名', table_rows as '記錄數', truncate(data_length/1024/1024, 2) as '數據容量(MB)', truncate(index_length/1024/1024, 2) as '索引容量(MB)' from information_schema.tables where table_schema='cloud_agent_prod' order by table_rows desc, index_length desc; ```