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]#

?

?

?

?

?

?

?

?

?

?

?

?

?