本文內(nèi)容是關(guān)于MySQL的，和Python關(guān)系不大。

1. 安裝MySQL

http://wiki.ubuntu.org.cn/MySQL
環(huán)境Ubuntu 14.04

2. 登錄MySQL

mysql -u root -p

3. 創(chuàng)建數(shù)據(jù)庫

創(chuàng)建數(shù)據(jù)庫

CREATE DATABESE chatroom;

切換到chatroom 數(shù)據(jù)庫

USE chatroom;

4. 創(chuàng)建表

創(chuàng)建用戶注冊表并初始化

CREATE TABLE username
(
  user_id    int  NOT NULL  AUTO_INCREMENT,
  user_name  char(20) NOT NULL ,
  password char(20)  NOT NULL,
  PRIMARY KEY (user_id)
) ENGINE=InnoDB;

# 往表中寫入初始的數(shù)據(jù)
INSERT INTO username(user_id ,
  user_name  ,
  password 
)
VALUES(1,
  'Administrator',
  '1234');

INSERT INTO username(user_id,
  user_name  ,
  password 
)
VALUES(2,
  'netease1',
  '123');

INSERT INTO username(user_id,
  user_name  ,
  password 
)
VALUES(3,
  'netease2',
  '123');

INSERT INTO username(user_id ,
  user_name  ,
  password 
)
VALUES(4,
  'netease3',
  '123');

INSERT INTO username(user_id ,
  user_name  ,
  password 
)
VALUES(5,
  'netease4',
  '123');

創(chuàng)建房間表

CREATE TABLE room
(
  room_id    int  NOT NULL,
  creator  char(20) NOT NULL ,
  is_password bool, 
  password char(20) ,
  PRIMARY KEY (room_id)
) ENGINE=InnoDB;