haohsq的博客

查看mysql数据库容量大小第一种情况：查询所有数据库的总大小，方法如下：mysql> use information_schema;mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES;+-----------+| data |+-----------+| 3052.76MB |+-----------+1 row in set (0.02 sec)统

1、查看数据库占用容量：use information_schema;select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES;2、开启root远程访问GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;FLUSH privileges;...