让discuz论坛的数据共享一个mysql数据库

让两台Web服务器使用同一个数据库来为用户提供discuz的论坛服务

实验环境：
系统： Linux 5.8
所需的rpm包(系统光盘上自带的有)：
httpd ,php53, php53-mbsting, php53-mysql, mysql, mysql-server
以及Discuz_7.2_FULL_SC_GBK.zip的源码包

首先请关闭selinux
# setenforce 0

1.在Server1上安装相关的rpm包

# yum -y install httpd php53 php53-mbstring php53-mysql
# /etc/init.d/httpd start
Starting httpd: [ OK ]
# chkconfig httpd on

测试apache是否能正常工作

# vi /etc/httpd/conf/httpd.conf
DirectoryIndex index.php -->编辑这一项
# cd /var/www/html/
# vi index.php
<?php
phpinfo();
?>
# /etc/init.d/httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]

测试php页面


2.安装discuz

# unzip Discuz_7.2_FULL_SC_GBK.zip -d /var/www/html/
# cd /var/www/html/
# rm -rf index.php readme utilities
# mv upload/* ./
# setfacl -m u:apache:rwx ./config.inc.php ./p_w_uploads/ ./forumdata/ ./forumdata/cache/ ./forumdata/templates/ ./forumdata/threadcaches/ ./forumdata/logs/ ./uc_client/data/cache/

3.更改php主配置文件

# vi /etc/php.ini
short_open_tag = On
date.timezone = Asia/Shanghai
解决乱码
# vi /etc/httpd/conf/httpd.conf
注释掉： AddDefaultCharset UTF-8

4. 在172.16.45.2 上安装mysql

# yum -y install mysql mysql-server
# /etc/init.d/mysql start --> 初始化数据库
# mysql
mysql> use mysql 设定当前默认操作的表
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT host,user,password FROM user; 查看用户信息
+-----------------------+------+----------+
| host | user | password |
+-----------------------+------+----------+
| localhost | root | |
| station90.example.com | root | |
| 127.0.0.1 | root | |
| localhost | | |
| station90.example.com | | |
+-----------------------+------+----------+
5 rows in set (0.01 sec)
mysql> UPDATE user SET password=password('redhat') WHERE user='root'; 为所有root用户更改密码
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> SELECT host,user,password FROM user;
+-----------------------+------+------------------+
| host | user | password |
+-----------------------+------+------------------+
| localhost | root | 27c30f0241a5b69f |
| station90.example.com | root | 27c30f0241a5b69f |
| 127.0.0.1 | root | 27c30f0241a5b69f |
| localhost | | |
| station90.example.com | | |
+-----------------------+------+------------------+
5 rows in set (0.00 sec)
mysql> DROP USER '' @localhost; 删除匿名用户
Query OK, 0 rows affected (0.00 sec)
mysql> DROP USER '' @station90.example.com;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT host,user,password FROM user;
+-----------------------+------+------------------+
| host | user | password |
+-----------------------+------+------------------+
| localhost | root | 27c30f0241a5b69f |
| station90.example.com | root | 27c30f0241a5b69f |
| 127.0.0.1 | root | 27c30f0241a5b69f |
+-----------------------+------+------------------+
3 rows in set (0.00 sec)
mysql> CREATE DATABASE discuz_db; 为discuz创建所需的数据库
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL ON discuz_db.* TO [email protected]'172.16.45.1' IDENTIFIED BY 'redhat'; 为discuz这个用户授权
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON discuz_db.* TO [email protected]'172.16.45.3' IDENTIFIED BY 'redhat'; 为discuz2这个用户授权
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES; 更新授权表
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye

# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]

在浏览器中输入：172.16.45.1/install 进入discuz的安装配置界面