linux下一台服务器安装多个mysql.doc

Linux下一个服务器安装多个mysql一 为了统一安装的版本，先卸载已经安装的mysql卸载已经安装的mysql1. 查找已安装的myslq 版本： #rpm -q mysql 在屏幕上将显示已安装的mysql包名如：mysql-5.0.77-4.el5_5.3 如果通过该命令，提示没有安装mysql，而你确定已安装，可以使用下面命令，尝试一下： #rpm -qa | grep -i mysql MySQL-server-5.5.11-1.rhel5 2. 强制卸载(将要卸载的必须是上面查询到的mysql的全称包括版本号，此处是在无法正常卸载时不得已的操作，强制卸载，必须用参数-nodeps)： #rpm -e -nodeps mysql-5.0.77-4.el5_5.3 3.成功卸载，系统不提示任何信息二 安装前请先安装所有依赖的包，或者安装过程中看见缺少什么包就安装什么包三 安装第一个mysqlmysql1:使用默认配置rootlocalhost usr# groupadd mysqlrootlocalhost usr# useradd -g mysql mysqlrootlocalhost usr# cd /usr/localrootlocalhost local# tar -zxvf mysql-5.0.51.tar.gz rootlocalhost local# cd mysql-5.0.51rootlocalhost mysql-5.0.51# ./configure -prefix=/usr/local/mysqlrootlocalhost mysql-5.0.51# makerootlocalhost mysql-5.0.51# make installrootlocalhost mysql-5.0.51# cd ./mysqlrootlocalhost mysql# ./bin/mysql_install_db -user=mysql rootlocalhost mysql# chown -R root .rootlocalhost mysql# chown -R mysql varrootlocalhost mysql# chgrp -R mysql .rootlocalhost mysql# ./bin/mysqld_safe -user=mysql &rootlocalhost mysql# ./bin/mysqladmin -uroot password mysqlrootlocalhost mysql# cp ./mysql-5.0.51/support-files/f /etc/frootlocalhost mysql# cp ./mysql-5.0.51/support-files/mysql.server /etc/rc.d/init.d/mysql1rootlocalhost mysql# chkconfig -add mysql1rootlocalhost mysql# chkconfig -level mysql1 345 onrootlocalhost mysql# chkconfig -list mysql1rootlocalhost mysql#四 安装第二个mysqlmysql2使用3307端口，配置文件为：/etc/frootlocalhost usr# groupadd mysqlrootlocalhost usr# useradd -g mysql mysqlrootlocalhost usr# cd /usr/localrootlocalhost local# tar -zxvf mysql-5.0.51.tar.gz rootlocalhost local# cd mysql-5.0.51rootlocalhost mysql-5.0.51# ./configure -prefix=/usr/local/mysql5rootlocalhost mysql-5.0.51# makerootlocalhost mysql-5.0.51# make installrootlocalhost mysql-5.0.51# cd ./mysql5rootlocalhost mysql# ./bin/mysql_install_db -user=mysqlrootlocalhost mysql# chown -R root .rootlocalhost mysql# chown -R mysql varrootlocalhost mysql# chgrp -R mysql .rootlocalhost mysql# ./bin/mysqld_safe -user=mysql &rootlocalhost mysql# ./bin/mysqladmin -uroot password mysqlrootlocalhost mysql# cp ./mysql-5.0.51/support-files/f /etc/frootlocalhost mysql# cp ./mysql-5.0.51/support-files/mysql.server /etc/rc.d/init.d/mysql2rootlocalhost mysql# chkconfig -add mysql2rootlocalhost mysql# chkconfig -level mysql2 345 onrootlocalhost mysql# chkconfig -list mysql2rootlocalhost mysql#配置mysql2vim /etc/rc.d/init.d/mysql2修改下面的内容：1. 将目录/usr/local/mysql改为当前安装的mysql目录，即/usr/local/mysql52. 将引用的配置文件名称由f改为当前要使用的配置文件f3. 在$bindir/mysqld_safe中添加-defaults-file=/etc/f$bindir/mysqld_safe -defaults-file=/etc/f -datadir=$datadir -pid-file=$server_pid_file $other_args /dev/null 2&1 &注意： 修改完后datadir需要使用如下命令来初始化datadir： ./bin/mysql_install_db -datadir=/usr/local/mysql5/var -user=mysql配置fvim /etc/f修改相关的端口、socketclient#password = your_passwordport = 3307socket = /tmp/mysql5.sock# The MySQL servermysqldport = 3307socket = /tmp/mysql5.sock五 启动mysql1和mysql2Mysql1:cd /etc/rc.d/init.d/./mysql1 startMysql2:./mysql2 start六 其他服务器命令行客户端链接mysqlmysql -ulportal -pportalpwr -h PortalDev3-DB2 -P 3306mysql -ulportal -pportalpwr -h PortalDev3-DB2 -P 3307七 主要错误与解决：q. Cant connect to local MySQL server through socket /tmp/mysql.sock(11)rootlocalhost mysql# chown -R root .rootlocalhost mysql# chown -R mysql /varrootlocalhost mysql# chgrp -R mysql .q. -bash: /etc/rc.d/init.d/mysqld: