一些常用的MySQL設定與指令

安裝並設定 MySQL Server 5.0.51a
執行指令: apt-get install mysql-server-5.0
設定 MySQL 預設編碼及連線參數: vim /etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
default-character-set=utf8
default-collation=utf8_general_ci
  <----- br="">
[mysqld]
#
# * Basic Settings
#
<----- br=""><----- br="">character-set-server=utf8 
<----- br=""><----- br=""><----- br=""><----- br="">collation-server=utf8_general_ci 
<----- br=""><----- br=""><----- br=""><----- br=""><----- br="">init-connect='SET NAMES utf8' <----- br="">
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
max_connections = 500 <----- br="">
重新啟動 MySQL Server: 執行指令 /etc/init.d/mysql restart

建立新的DataBase
create database `DB_Name` default charset utf8 collate utf8_general_ci;
建立新的使用者
GRANT ALL PRIVILEGES ON DB_Name.* TO 'user_name'@localhost IDENTIFIED BY 'password';