mysql
曹恭铖
这个作者很懒,什么都没留下…
展开
-
mysql查看表对应的物理空间
select concat(round(sum(data_length/1024/1024/1024),2),'GB') from information_schema.tables where table_schema='库名' and table_name='表名';原创 2020-10-14 12:27:15 · 421 阅读 · 0 评论 -
mysql修改用户密码的方法及命令
转自:https://www.cnblogs.com/mmx8861/p/9062363.html方法1: 用SET PASSWORD命令首先登录MySQL。格式:mysql> set password for 用户名@localhost = password('新密码');例子:mysql> set password for root@localhost = pass...转载 2019-05-06 11:14:10 · 508 阅读 · 0 评论 -
MySQL 报错Fatal error: mysql.user table is damaged
转自:https://www.jianshu.com/p/c6cabef4e9e5shell> mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)shell> service mysqld restartSto...转载 2019-05-06 13:26:49 · 1484 阅读 · 0 评论 -
MYSQL:WARN: Establishing SSL connection without server's identity verification is not recommended.
转自:https://blog.csdn.net/u010429286/article/details/77750177WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7....转载 2019-07-23 11:38:17 · 101 阅读 · 0 评论