二进制安装 mariadb
tar xvf mariadb-10.2.15-linux-x86_64.tar.gz -C /usr/local/
cd /usr/local/
ln -s mariadb-10.2.15-linux-x86_64/ mysql
useradd -r -s /sbin/nologin mysql
chown -R mysql.mysql mysql/
mkdir /data/mysql -pv
chown mysql.mysql /data/mysql/
vim /etc/profile.d/lamp.sh
PATH=/appl/httpd24/bin:/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
. /etc/profile.d/lamp.sh
cd mysql/
./scripts/mysql_install_db –datadir=/data/mysql –user=mysql
vim /etc/my.cnf
datadir=/data/mysql
chkconfig –add mysqld
chkconfig –list
service mysqld start
ss -ntl
创建wordpress数据库,和管理用户
MariaDB (none)> create database wordpress;
MariaDB (none)> grant all on wordpress.* to wpuser@’192.168.30.%’ identified by ‘centos’;
学员评价