Centos 多个mysql数据库

一、编译安装第一个MySQL 5.1.33

?

cd /opt   /usr/sbin/groupadd mysql   /usr/sbin/useradd -g mysql mysql -s /bin/nologin -d /usr/local/mysql   tar -zxvf mysql-5.1.33. tar .gz   cd mysql-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 && make install   chmod +w /usr/local/mysql   chown -R mysql:mysql /usr/local/mysql   cp support-files /my-medium .cnf /usr/local/mysql/my .cnf   cd ../

附：以下为附加步骤，如果你想在这台服务器上运行MySQL数据库，则执行以下两步。如果你只是希望让PHP支持MySQL扩展库，能够连接其他服务器上的MySQL数据库，那么，以下两步无需执行。

①、以mysql用户帐号的身份建立数据表：

?

1	/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 -u root password 1234 --初始化root密码   mysqladmin -u root -p password 456 --修改root已设置好的密码   mysql -u root -p         --用新密码连接数据库

添加mysql帐户 

?

grant all on *.* to   'mysql3306' @ '%' identified by 'mysql3306' ;     --添加用户mysql3306用于远程管理mysql数据库

二、编译安装第二个mysql 5.1.33:

注:可以将第一个mysql的安装文件全部复制过来,为了熟练安装过程,这里就再来重新安装一遍

?

cd /opt   /usr/sbin/useradd -g mysql mysql3307 -s /bin/nologin -d /usr/local/mysql3307   tar -zxvf mysql-5.1.33. tar .gz   cd mysql-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 ; make install   chmod +w /usr/local/mysql3307   chown -R mysql3307:mysql /usr/local/mysql3307   chmod -R 777 /usr/local/mysql3307   cp /usr/local/mysql/share/mysql/my-medium .cnf /usr/local/mysql3307/my .cnf

修改配置文件:

?

port = 3307                   --修改端口   socket = /tmp/mysql3307 .sock       --修改sock   # Here follows entries for some specific programs   # The MySQL server   [mysqld]   port = 3307   socket = /tmp/mysql3307 .sock

①、以mysql用户帐号的身份建立数据表：

?

1	/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

注:如出现 warning world-writable config file ' /usr/local/mysql3307/my.cnf' is ignored

解决办法:  chmod 644 /usr/local/mysql3307/my.cnf

?

mysqladmin -P 3307 -S /tmp/mysql3307 .sock -u root password 1q2w3e --初始化root密码   mysqladmin -P 3307 -S /tmp/mysql3307 .sock -u root -p password 1q2w3e --修改root已设置好的密码   /usr/local/mysql3307/bin/mysql -uroot -p -S /tmp/mysql3307 .sock

添加mysql帐户 

?

grant all on *.* to   'mysql3307' @ '%' identified by 'mysql3307' ;     --添加用户mysql3307用于远程管理mysql数据库