# Centos下安裝mariaDB方法

我在cnaaa上購買了雲伺服器。

**1、安裝mariadb-server**

```
yum install mariadb-server
```

**2、安裝相關環境**

```
yum install mariadb-embedded mariadb-libs mariadb-bench mariadb mariadb-sever
```

**3、安裝mariadb**

```
yum install mariadb
```

**4、啟動mariadb**

```
systemctl start mariadb
```

**5、設定開機啟動**

```
systemctl enable mariadb
```

**6、配置資料庫**（主要是設定密碼）

```
mysql_secure_installation
```

**7、設定編碼**

**①在`/etc/my.cnf`檔案下新增如下內容：**

```
init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
```

**②在`/etc/my.cnf.d/client.cnf`檔案[client]標籤下新增如下內容：**

```
default-character-set=utf8
```

**③在`/etc/my.cnf.d/mysql-clients.cnf`檔案[mysql]標籤下新增如下內容：**

```
default-character-set=utf8
```

**④重啟mariadb，命令如下：**

```
systemctl restart mariadb
```

**⑤檢視mariadb檢視字符集，語句如下：**

```
show variables like "%character%";show variables like "%collation%";
```

**8、允許遠端連線mariadb資料庫**

**①關閉防火牆，命令如下：**

```
systemctl stop firewalld
```

**②修改user表中host，具體如下****(依次執行即可)：**

```
select host, user from user;update user set host='%' where host='centos.portal';flush privileges;systemctl restart mariadb
```

Centos下安裝mariaDB方法

相關文章