linux 安装多个mysql5.5

 

目标：在服务器安装两个mysql5.5端口分别为3316和3326

 

// 添加mysq用户、l用户组

[root@test02 software]# groupadd mysql

[root@test02 software]# useradd -r -g mysql mysql

 

// 解压

[root@test02 software]# tar zxf mysql-5.5.22-linux2.6-i686.tar.gz

 

// 重命名

[root@test02 software]# mv mysql-5.5.22-linux2.6-i686 mysql-3316

 

// 进入到mysql 安装目录

[root@test02 software]# cd mysql-3316

 

 

// 改变权限

[root@test02 mysql-3316]# chown -R mysql:mysql .

 

// 初始化系统数据库

[root@test02 mysql-3316]# scripts/mysql_install_db --user=mysql

 

//修改配置文件中的端口号和socket文件位置,mysql中提供了多个配置文件模板，这里只修改support-files中的my-samll.cnf

// 将其中的3306改为3316，socket 改为 /tmp/mysql3316.sock

[root@test02 mysql-3316]# vim support-files/my-small.cnf

 

//运行mysql

[root@test02 mysql-3316]# ./bin/mysqld_safe --defaults-file=support-files/my-small.cnf --user=mysql &

[1] 3724
[root@test02 mysql-3316]# 121031 14:12:40 mysqld_safe Logging to '/opt/software/mysql-3316/data/test02.err'.
121031 14:12:40 mysqld_safe Starting mysqld daemon with databases from /opt/software/mysql-3316/data

 

// 修改root密码，这里需要显示指定端口号和socket文件路径
[root@test02 mysql-3316]# ./bin/mysqladmin -u root -P 3316 -S /tmp/mysql3316.sock password '123456'

 

// 连接到数据库，这里需要显示指定端口号和socket文件路径

[root@test02 mysql-3316]# ./bin/mysql -u root -p  -P 3316 -S /tmp/mysql3316.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 

这样就安装完了，另一个端口为3326的数据库也按上面这样安装

 

 

[root@test02 mysql-3326]# ps aux|grep mysql
root      3335  0.0  0.1  18592  2028 pts/0    S+   13:56   0:00 ./bin/mysql -uroot -p -P5188 -S/tmp/mysql3316.sock
root      3724  0.0  0.1  63828  1352 pts/1    S    14:12   0:00 /bin/sh ./bin/mysqld_safe --defaults-file=support-files/my-small.cnf --user=mysql
mysql     3939  0.0  3.0 321268 31472 pts/1    Sl   14:12   0:00 /opt/software/mysql-3316/bin/mysqld --defaults-file=support-files/my-small.cnf --basedir=/opt/software/mysql-3316 --datadir=/opt/software/mysql-3316/data --plugin-dir=/opt/software/mysql-3316/lib/plugin --user=mysql --log-error=/opt/software/mysql-3316/data/test02.err --pid-file=/opt/software/mysql-3316/data/test02.pid --socket=/tmp/mysql3316.sock --port=3316
root      4021  0.0  0.1  63828  1352 pts/1    S    14:18   0:00 /bin/sh ./bin/mysqld_safe --defaults-file=support-files/my-small.cnf --user=mysql
mysql     4236  0.1  3.0 321400 31708 pts/1    Sl   14:18   0:00 /opt/software/mysql-3326/bin/mysqld --defaults-file=support-files/my-small.cnf --basedir=/opt/software/mysql-3326 --datadir=/opt/software/mysql-3326/data --plugin-dir=/opt/software/mysql-3326/lib/plugin --user=mysql --log-error=/opt/software/mysql-3326/data/test02.err --pid-file=/opt/software/mysql-3326/data/test02.pid --socket=/tmp/mysql3326.sock --port=3326
root      4267  0.0  0.0  61188   768 pts/1    R+   14:19   0:00 grep mysql
[root@test02 mysql-3326]#