一、编译安装第一个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用户帐号的身份建立数据表:
/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 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用户帐号的身份建立数据表:
/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 identified
by 'mysql3307'; --添加用户mysql3307用于远程管理mysql数据库
本文出自 “聆听未来” 博客,请务必保留此出处http://blog.chinaunix.net/space.php?uid=9419692&do=blog&id=3182617