Centos 5.2下安装多个mysql数据库配置详解
一、编译安装第一个MySQL5.1.33
cd/opt /usr/sbin/groupaddmysql /usr/sbin/useradd-gmysqlmysql-s/bin/nologin-d/usr/local/mysql tar-zxvfmysql-5.1.33.tar.gz cdmysql-5.1.33/ ./configure--prefix=/usr/local/mysql/--enable-assembler--with-extra-charsets=complex--enable-thread-safe-client--with-big-tables--with-readline--with-ssl--with-embedded-server--enable-local-infile--with-plugins=innobase make&&makeinstall chmod+w/usr/local/mysql chown-Rmysql:mysql/usr/local/mysql cpsupport-files/my-medium.cnf/usr/local/mysql/my.cnf cd../
附：以下为附加步骤，如果你想在这台服务器上运行MySQL数据库，则执行以下两步。如果你只是希望让PHP支持MySQL扩展库，能够连接其他服务器上的MySQL数据库，那么，以下两步无需执行。
①、以mysql用户帐号的身份建立数据表：
/usr/local/mysql/bin/mysql_install_db--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--user=mysql
②、启动MySQL（最后的&表示在后台运行）
/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/usr/local/mysql/my.cnf& echo"/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/usr/local/mysql/my.cnf&">>/etc/rc.local ln-s/usr/local/mysql/bin/mysql/sbin/mysql ln-s/usr/local/mysql/bin/mysqladmin/sbin/mysqladmin mysqladmin-urootpassword1234--初始化root密码 mysqladmin-uroot-ppassword456--修改root已设置好的密码 mysql-uroot-p--用新密码连接数据库
添加mysql帐户
grantallon*.*to 'mysql3306'@'%'identifiedby'mysql3306';--添加用户mysql3306用于远程管理mysql数据库
二、编译安装第二个mysql5.1.33:
注:可以将第一个mysql的安装文件全部复制过来,为了熟练安装过程,这里就再来重新安装一遍
cd/opt /usr/sbin/useradd-gmysqlmysql3307-s/bin/nologin-d/usr/local/mysql3307 tar-zxvfmysql-5.1.33.tar.gz cdmysql-5.1.33/ ./configure--prefix=/usr/local/mysql3307/--enable-assembler--with-extra-charsets=complex--enable-thread-safe-client--with-big-tables--with-readline--with-ssl--with-embedded-server--enable-local-infile--with-plugins=innobase make;makeinstall chmod+w/usr/local/mysql3307 chown-Rmysql3307:mysql/usr/local/mysql3307 chmod-R777/usr/local/mysql3307 cp/usr/local/mysql/share/mysql/my-medium.cnf/usr/local/mysql3307/my.cnf
修改配置文件:
port=3307--修改端口 socket=/tmp/mysql3307.sock--修改sock #Herefollowsentriesforsomespecificprograms #TheMySQLserver [mysqld] port=3307 socket=/tmp/mysql3307.sock
①、以mysql用户帐号的身份建立数据表：
/usr/local/mysql3307/bin/mysql_install_db--basedir=/usr/local/mysql3307--datadir=/usr/local/mysql3307/data--user=mysql3307
②、启动MySQL（最后的&表示在后台运行）
/bin/sh/usr/local/mysql3307/bin/mysqld_safe--defaults-file=/usr/local/mysql3307/my.cnf& echo"/bin/sh/usr/local/mysql3307/bin/mysqld_safe--defaults-file=/usr/local/mysql3307/my.cnf&">>/etc/rc.local
注:如出现warningworld-writableconfigfile'/usr/local/mysql3307/my.cnf'isignored
解决办法: chmod644/usr/local/mysql3307/my.cnf
mysqladmin-P3307-S/tmp/mysql3307.sock-urootpassword1q2w3e--初始化root密码 mysqladmin-P3307-S/tmp/mysql3307.sock-uroot-ppassword1q2w3e--修改root已设置好的密码 /usr/local/mysql3307/bin/mysql-uroot-p-S/tmp/mysql3307.sock
添加mysql帐户
grantallon*.*to 'mysql3307'@'%'identifiedby'mysql3307';--添加用户mysql3307用于远程管理mysql数据库