Xe Web Server 구축

cd /home/test3/www

mv in.html index.html

cd ../

https://www.xpressengine.com

xe.zip <---- 다운로드

알드라이브로 SULinux로 전송

# unzip xe.zip

# mv xe ./www

# cd www

# chmod 707 xe -R

service mysqld restart

mysql -p mysql

123456

> show databases;

create database test3;

> flush privileges;

> insert into user (host,user,password) values('localhost','test3',password('123456')); 

> flush privileges;

> grant all privileges on test3.* to test3@localhost identified by '123456';

> flush privileges;

> service mysqld restart

> select host,user,password from user;

> select host,user,password from user where user='test3';

# vi /usr/local/apache/conf/extra/httpd-vhosts.conf

- DocumentRoot    /home/test3/www/xe

# service httpd restart

-------- SULinux -------------

mbc 생성 

위와 똑같은 방식

database 는 CentOS server 에서 구동

-------- CentOS --------------

create database mbc;

flush privileges;

insert into user (host,user,password) values('192.168.91.140','mbc',password('123456'));

insert into user (host,user,password) values('192.168.91.%','mbc',password('123456')); <--- c class

insert into user (host,user,password) values('%','mbc',password('123456')); <--- 모든 host   ****

flush privileges;

grant all privileges on mbc.* to 'mbc'@'%' identified by '123456';

flush privileges;

systemctl stop firewalld

systemctl restart mariadb

update user set password=password('123456') where user='root'

flush privileges;

db 서버 중지할시