安装基于C++的博客系统：XBlog系统

安装基本命令：
—————————————–
yum install mysql-devel libevent libevent-devel
yum install gcc-c++
yum install git
yum groupinstall “Compatibility libraries” “Base” “Development tools”
yum groupinstall “debugging Tools” “Dial-up Networking Support”
yum -y install tree nmap sysstat lrzsz dos2unix gcc* g++ tinyxml kernel wget net-tools psmisc screen vim links pcre pcre-devel zlib zlib-devel openssl openssl-devel cmake make zip unzip gzip bzip2* uuidd bc qt time ed perl ntp kernel-devel ntpdate libcurl libcurl-devel
—————————————–

更新时间：
—————————————–
ntpdate time.windows.com

设置hostname：
—————————————–
hostnamectl set-hostname newhostname
reboot

安装MySQL数据库：
—————————————–
# 下载mysql源安装包
shell> wget http://dev.mysql.com/get/mysql57 … se-el7-8.noarch.rpm
# 安装mysql源
shell> yum localinstall mysql57-community-release-el7-8.noarch.rpm
检查mysql源是否安装成功
shell> yum repolist enabled | grep “mysql.*-community.*”

安装MySQL
shell> yum install mysql-community-server

启动MySQL服务
shell> systemctl start mysqld

查看MySQL的启动状态
shell> systemctl status mysqld

开机启动
shell> systemctl enable mysqld
shell> systemctl daemon-reload

修改root默认密码
mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录mysql进行修改：
shell> grep ‘temporary password’ /var/log/mysqld.log
shell> mysql -uroot -p
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass4!’;

添加远程登录用户
默认只允许root帐户在本地登录，如果要在其它机器上连接mysql，必须修改root允许远程连接，或者添加一个允许远程连接的帐户，为了安全起见，我添加一个新的帐户：
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘yangxin’@’%’ IDENTIFIED BY ‘Yangxin0917!’ WITH GRANT OPTION;

修改MySQL数据路径
—————————————————————————–
mkdir -p /ourdata/database/mysql
cd /ourdata/database/mysql
service mysqld stop
cp -rf /var/lib/mysql/* ./
cd ..
chown -R mysql:mysql mysql/
mkdir -p /ourdata/log/mysql
cd /ourdata/log/mysql
cp -rf /var/log/mysqld.log ./
cd ..
chown -R mysql:mysql mysql/

默认配置文件路径：
配置文件：/etc/my.cnf
————————————————————————————-
[client]
#password = your_password
port = 3306
socket = /ourdata/database/mysql/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /ourdata/database/mysql
skip-external-locking
character_set_server = utf8mb4
init_connect = ‘SET NAMES utf8mb4’

explicit_defaults_for_timestamp = true
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535

log-bin=mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days = 10
early-plugin-load = “”

default_storage_engine = InnoDB
innodb_data_home_dir = /ourdata/database/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /ourdata/database/mysql
innodb_buffer_pool_size = 256M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

symbolic-links=0

log-error=/ourdata/log/mysql/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet = 100M

[mysql]
no-auto-rehash
default-character-set = utf8mb4

[myisamchk]
key_buffer_size = 64M
sort_buffer_size = 1M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

————————————————————————————-
启动MySQL
service mysqld start

安装xblog
————————
mkdir -p /ourdata/www/cplus
cd /ourdata/www/cplus
git clone https://github.com/0xsky/xblog.git
cd xblog
make
将 /doc 目录内的 xblog_dev.sql 导入到MYSQL数据库
修改 xblog.ini 内配置
./xBlog.sh start