# groupadd mysql //添加用户组
# useradd -g mysql mysql //添加用户并指派用户组
# tar -xzvf mysql-5.0.95 //解压mysql-5.0.95.tar.gz安装源文件包
# cd mysql-5.0.95 //跳转到解压目录下
# ./configure --prefix=/usr/local/mysql
// 指定安装目录,有时可能会找不到 libncursesw.so.5,此时指定
// ./configure --with-named-curses-libs=/usr/lib/libncursesw.so.5 --prefix=/usr/local/mysql
# make //安装
# make install //安装
# cd /usr/local //查看权限并指派执行权限
# ls -l
drwxr-xr-x 9 root root 4096 Feb 25 20:27 mysql
# chown -R mysql:mysql mysql
# ls -l
drwxr-xr-x 9 mysql mysql 4096 Feb 25 20:27 mysql
// 创建用户
# cd mysql/bin
# ./mysql_install_db --user=mysql
// 启动实例
# ./mysqld_safe &
// 查看进程
# ps -ef|grep mysql
root 7592 3935 0 07:06 pts/1 00:00:00 /bin/sh ./mysqld_safe
mysql 7609 7592 0 07:06 pts/1 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/localhost.localdomain.pid --skip-external-locking
root 7622 3935 0 07:07 pts/1 00:00:00 grep mysql
//关闭进程
# ./mysqladmin shutdown
STOPPING server from pid file /usr/local/mysql/var/localhost.localdomain.pid
120227 07:08:21 mysqld ended
[1]+ Done ./mysqld_safe
//进入mysql客户端
# ./mysql
//查看数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
//创建数据库
mysql> create database gavin;
Query OK, 1 row affected (0.01 sec)
//使用某个数据库实例
mysql> use gavin;
Database changed
//创建表
mysql> create table student(
-> name varchar(10) not null,
-> grade varchar(10) not null,
-> age int default 0)
-> engine=MyISAM;
Query OK, 0 rows affected (0.00 sec)
//查看表信息
mysql> describe student;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(10) | NO | | NULL | |
| grade | varchar(10) | NO | | NULL | |
| age | int(11) | YES | | 0 | |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
//删除表
mysql> drop table student;
//删除数据库
mysql> drop database gavin;
//退出
mysql> exit
Bye
# useradd -g mysql mysql //添加用户并指派用户组
# tar -xzvf mysql-5.0.95 //解压mysql-5.0.95.tar.gz安装源文件包
# cd mysql-5.0.95 //跳转到解压目录下
# ./configure --prefix=/usr/local/mysql
// 指定安装目录,有时可能会找不到 libncursesw.so.5,此时指定
// ./configure --with-named-curses-libs=/usr/lib/libncursesw.so.5 --prefix=/usr/local/mysql
# make //安装
# make install //安装
# cd /usr/local //查看权限并指派执行权限
# ls -l
drwxr-xr-x 9 root root 4096 Feb 25 20:27 mysql
# chown -R mysql:mysql mysql
# ls -l
drwxr-xr-x 9 mysql mysql 4096 Feb 25 20:27 mysql
// 创建用户
# cd mysql/bin
# ./mysql_install_db --user=mysql
// 启动实例
# ./mysqld_safe &
// 查看进程
# ps -ef|grep mysql
root 7592 3935 0 07:06 pts/1 00:00:00 /bin/sh ./mysqld_safe
mysql 7609 7592 0 07:06 pts/1 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/localhost.localdomain.pid --skip-external-locking
root 7622 3935 0 07:07 pts/1 00:00:00 grep mysql
//关闭进程
# ./mysqladmin shutdown
STOPPING server from pid file /usr/local/mysql/var/localhost.localdomain.pid
120227 07:08:21 mysqld ended
[1]+ Done ./mysqld_safe
//进入mysql客户端
# ./mysql
//查看数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
//创建数据库
mysql> create database gavin;
Query OK, 1 row affected (0.01 sec)
//使用某个数据库实例
mysql> use gavin;
Database changed
//创建表
mysql> create table student(
-> name varchar(10) not null,
-> grade varchar(10) not null,
-> age int default 0)
-> engine=MyISAM;
Query OK, 0 rows affected (0.00 sec)
//查看表信息
mysql> describe student;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(10) | NO | | NULL | |
| grade | varchar(10) | NO | | NULL | |
| age | int(11) | YES | | 0 | |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
//删除表
mysql> drop table student;
//删除数据库
mysql> drop database gavin;
//退出
mysql> exit
Bye