安装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