linux系统下mysql安装

下载mysql yum仓库

链接：https://pan.baidu.com/s/1yDVOeFXqNYEB5-oSTrV4Tw&shfl=sharepset 
提取码：16b0 
 

安装yum仓库

yum -y install mysql57-community-release-el7-10.noarch.rpm 

安装mysql服务器

yum -y install mysql-community-server

启动mysql服务器

systemctl start  mysqld.service
 

查看mysql服务器装态

systemctl status mysqld.service
 

 查看mysql设置的密码

grep "password" /var/log/mysqld.log

 输入密码连接mysql

mysql -uroot -p

对数据库操作，需要修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '你设置的密码';

 报错，密码等级不高

 设置等级、长度： 0,1,2从低到高设置mysql密码等级

set global validate_password_policy=0;

set global validate_password_length=1;

 

 重新设置密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '你设置的密码';

 远程登录数据库出现下面出错信息ERROR 2003 (HY000): Can’t connect to MySQL server on ‘xxx.xxx.xxx.xxx’,
原因是没有授予相应的权限

#任何主机
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

#指定主机
mysql>GRANT ALL PRIVILEGES ON *.* TO 'jack'@’10.10.50.127’ IDENTIFIED BY '654321' WITH GRANT OPTION;

# 然后刷新权限
mysql>flush privileges;