mysql.md · mirrors_pingcap/discourse_docker - Gitee.com

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

mysql.md 1.25 KB

## Install MySQL 5.7 Server

* apt-get install mysql-server

## Create User

```
sudo cat /etc/mysql/debian.cnf
# Login MySQL with root;

CREATE USER 'discourse'@'localhost' IDENTIFIED BY 'password123ABC&';

# Login MySQL with discourse

CREATE DATABASE IF NOT EXISTS discourse;
```

## Config utf8mb4

vim /etc/mysql/my.cnf

```
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
```

## Config Bind IP

vim /etc/mysql/mysql.conf.d/mysqld.cnf

firewall setting requred.

```
bind-address            = 0.0.0.0
```

## Discourse Deploy With Docker

* https://github.com/discourse/discourse/blob/master/docs/INSTALL-cloud.md

## Config Discourse With MySQL

detail: https://meta.discourse.org/t/running-discourse-with-a-separate-postgresql-server/46375

vim containers/app.yml

rm `templates/postgres.template.yml` line

set env in containers/app.yml

```
 DISCOURSE_DB_USERNAME: discourse
 DISCOURSE_DB_PASSWORD: s3kr1t
 DISCOURSE_DB_HOST: <IP or hostname>
 DISCOURSE_DB_NAME: discourse
 ```

get `DISCOURSE_DB_HOST` ip: `ip -4 addr show docker0 | grep -Po 'inet \K[\d.]+'`

## Launch Discourse

* `./launcher rebuild app`

一键复制原始数据按行查看历史

提交于 2019-11-06 16:40 . discourse mysql

## Install MySQL 5.7 Server

* apt-get install mysql-server

## Create User

```
sudo cat /etc/mysql/debian.cnf
# Login MySQL with root;

CREATE USER 'discourse'@'localhost' IDENTIFIED BY 'password123ABC&';

# Login MySQL with discourse

CREATE DATABASE IF NOT EXISTS discourse;
```

## Config utf8mb4

vim /etc/mysql/my.cnf

```
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
```

## Config Bind IP

vim /etc/mysql/mysql.conf.d/mysqld.cnf

firewall setting requred.

```
bind-address            = 0.0.0.0
```

## Discourse Deploy With Docker

* https://github.com/discourse/discourse/blob/master/docs/INSTALL-cloud.md

## Config Discourse With MySQL

detail: https://meta.discourse.org/t/running-discourse-with-a-separate-postgresql-server/46375

vim containers/app.yml

rm `templates/postgres.template.yml` line

set env in containers/app.yml

```
 DISCOURSE_DB_USERNAME: discourse
 DISCOURSE_DB_PASSWORD: s3kr1t
 DISCOURSE_DB_HOST: <IP or hostname>
 DISCOURSE_DB_NAME: discourse
 ```

 get `DISCOURSE_DB_HOST` ip: `ip -4 addr show docker0 | grep -Po 'inet \K[\d.]+'`

 ## Launch Discourse

 * `./launcher rebuild app`

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

1

https://gitee.com/mirrors_pingcap/discourse_docker.git

[email protected]:mirrors_pingcap/discourse_docker.git

mirrors_pingcap

discourse_docker

discourse_docker

master