![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
weixin_41462238
这个作者很懒,什么都没留下…
展开
-
查看数据库表大小
查看数据库表大小 select table_schema as '数据库', 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='zhongan' order by data_le原创 2020-12-30 16:26:23 · 173 阅读 · 0 评论 -
mysql 1044错误
root用户新建了一个数据库,赋权限给用户A, grant 权限 on 数据库.数据表 to ‘用户’ @ ‘主机名’; grant all on db_test.* to ‘test’@’%’; 报错如下: [Err] 1044 - Access denied for user ‘root’@’%’ to database ‘db_test’ 报错可以看出root没有权限,查询用户表看root用户权限 SELECT host,user,Grant_priv,Super_priv FROM mysql.us原创 2020-12-30 16:26:42 · 209 阅读 · 0 评论