我的大数据之路--centOS mysql5.7分布式的安装

安装MySql 5.7

root用户下

 yum install weget

由于CentOS 的yum源中没有mysql，需要到mysql的官网下载yum repo配置文件。

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

repo安装rmp

 rmp -ivh mysql57-community-release-el7-9.noarch.rpm 

执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repo mysql-community-source.repo

开始安装

sudo yum install mysql-server

完成后启动mysql

systemctl start mysqld 

登录

mysql -u root -p

第一次登录可能会报错
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)
原因是/var/lib/mysql的访问权限问题。下面的命令把/var/lib/mysql的拥有者改为当前用户：

chown –R root:root /var/lib/mysql

重启

service mysqld restart

重新登录，假如出现

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

则要重新设置密码

update user set password=password("你的新密码") where user="root";

或者

update mysql.user set authentication_string=password('root') where user='root';

立即实现

 flush privileges;

又出现
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
则密码复杂度不够
更改密码复杂度

set global validate_password_policy=0;
set global validate_password_length=1;

再次更改密码

set password=password("root");

重新登录
mysql -uroot -p

成功

重启关闭命令为：
systemctl restart mysqld.service
systemctl start mysqld.service
systemctl stop mysqld.service

参考博客
https://www.cnblogs.com/gumuzi/p/5711495.html
https://www.cnblogs.com/freely/p/8087885.html