mysql5.1.36 源程序安装记录

//使用root登录，创建mysql用户
#useradd mysql
//并设置密码
#passwd mysql

//使用mysql用户登录，进行安装
//解压下载的文件
$tar -xzvf mysql-5.1.36.tar.gz
//进入安装文件夹
$cd mysql-5.1.36
//配置
$./configure --prefix=/home/mysql/my51 --with-charset=gbk --with-extra-charsets=complex --with-innodb --with-named-curses-libs=/usr/lib/libncurses.so.5
.
.
.
Thank you for choosing MySQL!

//编辑
$make
//安装
$make install

//进入安装后的运行目录
$cd /home/mysql/my51/bin/
//初始化数据库
$./mysql_install_db
//后台运行
$./mysqld_safe &
//进入mysql
$./mysql

//查看使用的端口
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+
1 row in set (0.00 sec)

mysql> quit;

//修改管理员密码
$./mysqladmin -uroot password '111111'

$cd /home/mysql/my51/
$cp share/mysql/my-large.cnf my.cnf
$vi my.cnf
//修改[client]和[mysqld]下的port配置；注释socket配置

port            = 3351
#socket          = /tmp/mysql.sock

//保存退出

//关闭数据库
$bin/mysqladmin -uroot -p shutdown
//重新启动
$bin/mysqld_safe &
//重新登录
$./mysql -uroot -p
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3351  |
+---------------+-------+
1 row in set (0.00 sec)