mariadb 설치

 

sudo apt update;
sudo apt upgrade;

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | bash;
sudo apt update;
sudo apt install mariadb-server mariadb-client;

 

CREATE DATABASE `wordpress` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

CREATE USER 'userid'@'%' IDENTIFIED BY 'password';

-- '%'는 모든 호스트를 나타냅니다. 필요에 따라 호스트를 특정하십시오.
GRANT ALL PRIVILEGES ON blog.* TO 'userid'@'%';
FLUSH PRIVILEGES;


CREATE DATABASE IF NOT EXISTS wordpress;
GRANT ALL PRIVILEGES ON wordpress.* TO 'userid'@'%';
FLUSH PRIVILEGES;

sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf
#bind-address            = 127.0.0.1

character-set-server     = utf8mb4
character-set-collations = utf8mb4_general_ci

 

 

* Uncaught mysqli_sql_exception: Server sent charset (0) unknown to the client. 방지

 

1. sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf

    character-set-server     = utf8mb4
    character-set-collations = utf8mb4_general_ci

 

2. CREATE DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

3. 워드프레스 wp-config.php

    define( 'DB_CHARSET', 'utf8mb4' );
    define( 'DB_COLLATE', 'utf8mb4_general_ci' );