Jill 筆記 - 線上書籍

:::

MiniServer設定
============

1.新增使用者會自動在/home建立user資料夾

```
<pre class="brush:bash;" style="margin-left: 40px;">
cd /opt/tools

cd Addusers/

vi passwd.txt
```

- 新增使用者
 
 ```
<pre class="brush:bash;" style="margin-left: 40px;">
./maccount.sh add passwd.txt
```

- 刪除使用者
 
 ```
<pre class="brush:bash;" style="margin-left: 40px;">
./maccount.sh del passwd.txt
```

- 查詢UID500以後的一般使用者
 
 ```
<pre class="brush:bash;" style="margin-left: 40px;">
cat /etc/passwd | awk -F: '{if($3 > 500) {print $0}}'
```

2.開啟~user可用的權限

```
<pre class="brush:bash;" style="margin-left: 40px;">
a2enmod userdir

vi /etc/apache2/mods-available/php5.conf

# php_admin_value engine Off

service apache2 restart
```

3.建資料庫

```
<pre class="brush:bash;" style="margin-left: 40px;">
./maccount.sh mysql passwd.txt

service mysql restart
```

4.讓資料庫預設utf-8

```
<pre class="brush:bash;">
[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysqld]

skip-character-set-client-handshake

collation-server = utf8_general_ci

init-connect='SET NAMES utf8'

character-set-server = utf8
```

MarkDown