centos7搭建mysql5.6 && mysql 8.0

检查是否安装mysql

rpm -qa | grep mysql

检查已安装的Mariadb

rpm -qa | grep -i mariadb

卸载已安装的Mariadb数据库

rpm -qa | grep mariadb | xargs rpm -e --nodeps

下载mysql5.6安装包文件

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

安装rpm包

rpm -ivh mysql-community-release-el7-5.noarch.rpm

查看可用的mysql安装文件

yum repolist all | grep mysql

安装mysql

yum install mysql-server

检查mysql是否安装成功

rpm -qa | grep mysql

启动mysql

systemctl start mysql.service

systemctl stop mysql

systemctl status mysql

systemctl enable mysql   #开机启动

修改root密码

# mysql -uroot
> use mysql;
> update user set password=PASSWORD('密码') where User='root';
> flush privileges;

设置远程访问权限

mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '密码';

设置mysql表名不区分大小写

lower_case_table_names=1

 重启mysql 使配置生效

systemctl restart mysqld.service

查看mysql 状态

systemctl status mysqld.service

至此mysql安装完成 

官网下载MySQL 8 

官网yum 地址 

https://dev.mysql.com/downloads/repo/yum/

yum install mysql80-community-release-el7-11.noarch.rpm

安装Mysql

yum install mysql-community-server




systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

修改密码

查看临时密码
grep 'temporary password' /var/log/mysqld.log



登录
mysql -uroot -p


修改原始密码
alter user 'root'@'localhost' identified by '123';


赋权
CREATE USER 'root'@'%' IDENTIFIED BY '123';
grant all on *.* to 'root'@'%';

新用户或新IP 赋予权限

#创建账户
create user 'root'@'%' identified by '123456';

#赋予权限
grant all privileges on *.* to 'root'@'%' with grant option;

#刷新
flush privileges;