![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
菜鸟一枚之一
这个作者很懒,什么都没留下…
展开
-
Centos7安装msyql8、简单安装
rpm -qa | grep -i -E mysql|mariadbrpm -qa | grep -i -E mysql|mariadb | xargs -n1 sudo rpm -e --nodepssudo yum remove mysql-libssudo yum install libaiosudo yum -y install autoconfsudo rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpmsudo rpm -iv原创 2021-11-23 18:04:58 · 1764 阅读 · 0 评论 -
msyql8 Your password does not satisfy the current policy requirements
alter user user() identified by "FGsd_jfdlaflk455-+";set global validate_password.policy=LOW;set global validate_password.length=6alter user user() identified by "123456";![在这里插入图片描述](https://img-blog.csdnimg.cn/5448b4197e3445afa216c7c1578e82ee.png?x-原创 2021-11-23 17:58:27 · 282 阅读 · 0 评论 -
查询mysql元数据转换成hive语句
create view test2 ASSELECT a.*,b.TABLE_COMMENTFROM (SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, DATA_TYPE, CASE DATA_TYPE WHEN 'bigint' THEN 'bigint' WHEN 'int' THEN 'bigint' WHEN 'smallint' THEN 'bigint' WHEN 'tiny原创 2021-11-20 13:42:25 · 868 阅读 · 0 评论 -
查看mysql某张表数据量
#查看张表的数据量SELECT table_schema as '数据库',table_name AS '表',round(((data_length) / 1024 / 1024), 2) '数据量大小(MB)',round(((index_length) / 1024 / 1024), 2) '索引量(MB)'FROM information_schema.TABLESwhere table_schema = 'gmall' '数据库'and table_name = 'favor_inf转载 2021-11-18 17:06:58 · 1187 阅读 · 0 评论 -
mysql连接报错问题
记录一次Linux上的mysql在windows上使用Navicat Premuim连接报错,不能连接的问题首先是mysql的远程权限已经开启,然后使用navicat来连接,报错,不能连接上,Linux的ssh的端口已经修改,没有使用默认端口22。具体操作以上的操作成功之后,在通过常规连接去连接mysql,然后连接成功那么为什么会这样呢?以上图,可以看出Navicat是直接连接数据库的https://blog.csdn.net/qq_40018938/article/details/907原创 2021-11-04 17:04:35 · 615 阅读 · 0 评论 -
host sfbg101 is not allowerd to connect to this mysql server
host sfbg101 is not allowerd to connect to this mysql serverGRANT ALL PRIVILEGES ON . TO ‘root’@‘sfbg101’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;原创 2021-11-04 16:52:46 · 78 阅读 · 0 评论