centos 安装 mysql 5.7

centos 安装 mysql 5.7

下载mysq：wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
#安装mysql：rpm -ivh mysql57-community-release-el7-8.noarch.rpm

#启动mysql

systemctl start mysqld.server  

#安装mariadb-server

yum install -y mariadb-server

#启动服务

systemctl start mariadb.service				

#开机启动

systemctl enable mariadb.service		

#mysql初始化目录日志(可查看初始化密码)

/var/log/mysqld.log

密码示例：2020-12-01T02:23:52.729164Z 1 [Note] A temporary password is generated for root@localhost: _i&KDisTD8ms

#centos连接mysql：   mysql -uroot -p		
#显示数据库： 		show databases;			
设置密码验证强度：
	 set global validate_password_policy=LOW; 
	 set global validate_password_length=6 （备选）
修改mysql密码：
	ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aite8899';
修改权限	
	update mysql.user set host='%' where host='localhost';
执行提交	
	fulsh privileges;
	flush privileges;
退出mysql
	exit;

1.启动命令
	[root@xufeng Desktop]# service mysqld start
	Redirecting to /bin/systemctl start mysqld.service
	2.关闭命令
	[root@xufeng ~]# service mysqld stop
	Redirecting to /bin/systemctl stop mysqld.service
	3.重启命令
	[root@xufeng ~]# service mysqld restart
	Redirecting to /bin/systemctl restart mysqld.service