CentOS7.6在线安装Mysql

检查系统中是否已安装 MySQL

 rpm -qa | grep mysql

 未安装mysql

检查系统中是否已安装 mariadb

rpm -qa|grep -i mariadb

 安装mariadb

卸载mariadb

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

卸载后，下载安装包文件

 wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

可以在此之前更改为阿里的库

wget -O /etc/yum.repos.d/centos-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

安装mysql57-community-release-el7-11.noarch.rpm包

yum -y localinstall mysql57-community-release-el7-11.noarch.rpm

 已安装好

 

安装mysql

yum install -y mysql-server

安装时会出现密码问题需要先执行密码，在执行安装yum install -y mysql-server

查询是否安装成功

rpm -qa | grep mysql

 

#启动 mysql

systemctl start mysqld.service

#重启 mysql
systemctl restart mysqld.service

#停止 mysql
systemctl stop mysqld.service

#设置 mysql 开机启动
systemctl enable mysqld.service

 查询最初密码

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

 A temporary password is generated for root@localhost: 密码

 

 登入mysql

mysql -u root -p

设置密码

set password for 'root'@'localhost' = password('H00fzp@123');

 远程登入

grant all privileges on *.* to 'root'@'%' identified by 'H00fzp@123';

 权限刷新

flush privileges;

数据库复制表让表名全部小写设置

 vim /etc/my.cnf

在末尾插入

lower_case_table_names

 先按  Esc  在输入 :wq  保存退出