mysql 5.1.36_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)