一、编译安装第一个MySQL 5.1.33
?
| cd/opt
/usr/sbin/groupaddmysql
/usr/sbin/useradd-g mysql mysql -s/bin/nologin-d/usr/local/mysql
tar-zxvf mysql-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-R mysql:mysql/usr/local/mysql
cpsupport-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
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-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数据库
|
