2、用命令"rpm -i"逐一安装。如：rpm -i MySQL-3.22.22-1.i386.rpm

3、建立数据库，如建立一个名为"test"的数据库用命令：mysqladmin create test
4、设立用户。以root的身份用"mysql"进入查询状态。

mysql>
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> insert into user (host,user,password)
-> values('%','test',password('mypassword'));
Query OK, 1 row affected (0.00 sec)

mysql> insert into user (host,user,password)
-> values('localhost','test',password('mypassword'));
Query OK, 1 row affected (0.00 sec)

这样就建立起一个用户名为"test"，密码为"mypassword"的用户。

5、赋给用户"test"访问test数据库的权限。

mysql> insert into db (host,db,user,select_priv,insert_priv,update_priv,
-> delete_priv,create_priv,drop_priv)
-> values('%','test','test','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected (0.00 sec)

mysql> insert into db (host,db,user,select_priv,insert_priv,update_priv,
-> delete_priv,create_priv,drop_priv)
-> values('localhost','test','test','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected (0.00 sec)

mysql> \q
Bye
退出去。

mysqladmin reload 使生效。

6、以新创建的用户进入数据库的命令行查询：mysql -h 202.xxx.xxx.xxx -u chat -p
或者：mysql -h localhost -u chat -p
建立表room,list,user

mysql> use test
Database changed
mysql> create table room (port bigint NOT NULL,
-> roomname varchar(40),pid varchar(6),num int,type char(1));
Query OK, 0 rows affected (0.00 sec)

mysql> create table list (host varchar(20) NOT NULL,
-> port varchar(10),name varchar(40),roomname varchar(40));
Query OK, 0 rows affected (0.00 sec)

mysql> create table user (name varchar(20) NOT NULL,passwd varchar(20));
Query OK, 0 rows affected (0.00 sec)

建立表room,list,user的索引

mysql> use test
Database changed
mysql>alter table room add index (port), add primary key (port);
Query OK, 0 rows affected (0.00 sec)
mysql>alter table user add index (name), add primary key (name);
Query OK, 0 rows affected (0.00 sec)
mysql>alter table list add index (host);
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye