本文共 2071 字,大约阅读时间需要 6 分钟。
根据系统版本下载
[root@hadoop ~]# rpm -qa|grep mariadbmariadb-libs-5.5.52-1.el7.x86_64[root@hadoop ~]# rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64[root@hadoop ~]# rpm -qa|grep mariadb
tar -xvf mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.20-1.el7.x86_64.rpm
[root@hadoop app]# rpm -qa|grep libaiolibaio-0.3.109-13.el7.x86_64
如果不存需要下载离线包:
rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm(若在有网情况下可执行yum install libaio)
rpm -ivh mysql-community-server-5.7.20-1.el7.x86_64.rpm
// 指定datadir, 执行后会生成~/.mysql_secret密码文件(5.7以后不在使用)[root@slave mytmp]# mysql_install_db --datadir=/var/lib/mysql// 初始化,执行生会在/var/log/mysqld.log生成随机密码[root@slave mytmp]# mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
Process: 5924 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
chmod -R 777 mysql
命令可以查看初始密码
grep 'temporary password' /var/log/mysqld.log
set password=password('123456a?');
CREATE USER 'sunld'@'%' IDENTIFIED BY '123456a?'; GRANT ALL PRIVILEGES ON *.* TO 'sunld'@'%';flush privileges;
grant all privileges on *.* to 'root'@'%' identified by '123456a?' with grant option;flush privileges;
// 检查是否已经是开机启动systemctl list-unit-files | grep mysqld
// 开机启动systemctl enable mysqld.service
配置文件:/etc/my.cnf 日志文件:/var/log/mysqld.log 服务启动脚本:/usr/lib/systemd/system/mysqld.service socket文件:/var/run/mysqld/mysqld.pid
修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置,如下所示:[mysqld]character_set_server=utf8init_connect='SET NAMES utf8'