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; ```