//使用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)