APM DB 분리 설치

[[ web server ]]

sudo apt-get install apache2

sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt

sudo apt-get install php5-mysql

ubuntu@web01:~$ sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql

wordpress decompress

# vi /var/www/html/wordpress/wp-config.php

// ** MySQL settings - You can get this info from your web host ** //

/** The name of the database for WordPress */

define('DB_NAME', 'wp_db');

/** MySQL database username */

define('DB_USER', 'wp_user');

/** MySQL database password */

define('DB_PASSWORD', '######');

/** MySQL hostname */

define('DB_HOST', '192.168.1.25');

[[ db server ]]

sudo apt-get install mariadb-server python-pymysql

# sudo vi /etc/mysql/mariadb.conf.d/wordpress.cnf

[mysqld]

bind-address = 192.168.1.25

default-storage-engine = innodb

innodb_file_per_table

collation-server = utf8_general_ci

character-set-server = utf8

ubuntu@controller:~$ sudo mysql -u root -p

CREATE DATABASE wp_db;

GRANT ALL PRIVILEGES ON wp_db.* TO 'wp_user'@'localhost' \

  IDENTIFIED BY 'krnvyd03';

GRANT ALL PRIVILEGES ON wp_db.* TO 'wp_user'@'%' \

  IDENTIFIED BY 'krnvyd03';