mysql
蓝缘
这个作者很懒,什么都没留下…
展开
-
mysql 数据库的所有表数据大小排序
对某个数据库的所有表数据大小排序SELECT TABLE_NAME, DATA_LENGTH + INDEX_LENGTH, TABLE_ROWS, concat(round((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024,2),'MB') AS DATAFROM information_schema. TABLESWHERE TABL...原创 2020-04-16 11:33:43 · 3524 阅读 · 2 评论 -
mysql 8.0 报错解决 authentication protocol requested by server; consider upgrading MySQL
错误:Client does not support authentication protocol requested by server; consider upgrading MySQL client先登录:mysql -u root -p解决:ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY...原创 2018-09-06 15:25:33 · 2321 阅读 · 1 评论