Posted on 2011-11-25 23:40
貝貝爸爸 閱讀(3904)
評論(3) 編輯 收藏 所屬分類:
Linux 、
數(shù)據(jù)庫
$> sudo yum install mysql mysql-server mysql-workbench
# 啟動mysql
$> sudo systemctl start mysql.service
# 設置自動啟動
$> sudo systemctl enable mysql.service
- 修改默認字符集，修改/etc/my.cnf文件
[mysqladmin]
user=root
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
character-set-server=UTF8
port=3306
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
default-character-set=UTF8
port=3306
socket=/var/lib/mysql/mysql.sock
-
查看默認字符集
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)