Using MySQL 5.5 on FreeBSD 10.1

SQL語法教學
FreeBSD MySQL
Mysql調整成全UTF-8語系
MySQL 超新手入門
#mysql -u root -p
#Enter password:XXXXXXXX
//若出現
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 5.5.40-log Source distribution

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

//表示正常

//*調整Mysql成UTF-8語系*//
mysql>\s  或  mysql>status 或 mysql>show variables like 'character_set%';

Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1

#ee /usr/local/etc/my.cnf＿
//在[local]中 加入
default-character-set=utf8
/在[mysqld]中 加入

#my add by Michael 2014/12/18
datadir=/home/mysql
default-character-set=utf8
default-collation=utf8_general_ci

//重啟mysql

//刪除資料庫名為XXXXX
mysql>DROP DATABASE XXXXX;
//建立資料庫名為XXXXX
mysql>show character set; //其中Charset 有utf8

mysql>create database XXXXX
或
mysql>create database XXXXX default character set utf8;
mysql>show databases;
mysql>show create database XXXXX;
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>
mysql>