CentOS 7配置MySQL

如你所知，CentOS官方仓库的软件包通常版本都比较旧，为了使用较新版本要花一些信息在配置上，后来发现一个快捷的一键方案：

https://www.softwarecollections.org/en/docs/

 

#安装software collection仓库
yum install epel-release centos-release-scl yum-utils

　　

 如何配置MySQL 5.7

参考官网连接  https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html

# 下载安装rpm包
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
rpm -ivh mysql57-community-release-el7-11.noarch.rpm

# 更新仓库并安装mysql-server
yum update -y && sudo yum install mysql-community-server

# 启动mysql服务
systemctl start mysqld.service

在 /var/log/mysqld.log里搜索'temporary password'找到密码

使用此密码登陆mysql

mysql -uroot -p

#设置初始密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
SET PASSWORD=PASSWORD('new password');

 

如何配置phpmyadmin

安装php 7.2

sudo yum install rh-php72
sudo yum install rh-php72-php*  # 安装所有相关库

 

php.ini和php-fpm的配置分别在下面两个目录，按需修改

/etc/opt/rh/rh-php72/php.ini
/etc/opt/rh/rh-php72/php-fpm.conf

 

启动php-fpm服务

sudo systemctl start rh-php72-php-fpm

 

假定phpmyadmin代码放在目录/data/www/phpmyadmin

安装nginx

sudo yum install nginx

修改/etc/nginx/nginx.conf，加入此配置

server {
    listen 80;
    root /data/www;
    location ~ \.php$ {
        fastcgi_pass   127.0.0.1:9000;
        include        fastcgi_params;
        fastcgi_index  index.php;
        fastcgi_param  SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }    
}

重启nginx

sudo nginx -s reload