第一步下载源并安装
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum localinstall mysql57-community-release-el7-11.noarch.rpm
查看是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
yum install mysql-community-server
第二步设置托管
#设置托管
systemctl enable mysqld
#刷新使设置生效
systemctl daemon-reload
#启动
systemctl start mysqld
#停止和重启
systemctl stop,restart mysqld
第三步:查询root密码
[root@daxian mysql]# grep 'temporary password' /var/log/mysqld.log
2019-02-26T06:49:36.570135Z 1 [Note] A temporary password is generated for root@localhost: ew-YjGiq!6.>
第四步:登录mysql
mysql -u root -p
密码为刚查询出来的密码
第五步:修改root密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY '*******';
第六步:新建数据库,并配置用户和权限
create database keycloak;
grant all privileges on keycloak.* to daxian@'%' identified by '*********';
flush privileges;
第七步:mysql的默认配置文件的路径
配置文件:/etc/my.cnf
日志文件:/var/log//var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pid
第八步:修改设置
vim /etc/my.cnf
[mysqld]
#忽悠大小写
lower_case_table_names = 1
#group_concat的最大长度
group_concat_max_len = 102400
第九步:重启生效
systemctl restart mysqld