Ubuntu x64 编译安装mysql

OS:Ubuntu 11.04 x64 手动安装mysql 5.5.17

什么是mysqlnd?

mysqli、mysql、pdo_mysql的区别。

从mysql.com下载,有rpm安装包但没有deb包。则Ubuntu需要编译安装。
下载Linux – Generic 2.6 (x86, 64-bit), Compressed TAR Archive
参考 | 下载地址

安装过程:
sudo apt-get install libaio1
sudo apt-get remove mysql-common mysql-server mysql-client
sudo rm -rf /etc/mysql/
tar -zxvf mysql-5.5.17-linux2.6-x86_64.tar.gz
sudo mv ./mysql-5.5.17-linux2.6-x86_64 /usr/local/mysql
sudo groupadd mysql
sudo useradd -r -g mysql mysql
cd /usr/local/mysql
sudo chown -R mysql .
sudo chgrp -R mysql .
sudo /usr/local/mysql/scripts/mysql_install_db –user=mysql
sudo chown -R root .
sudo chown -R mysql data
sudo cp support-files/my-medium.cnf /etc/my.cnf
sudo cp ./bin/mysql /usr/bin/
sudo cp support-files/mysql.server /etc/init.d/mysql
sudo /etc/init.d/mysql start
./bin/mysqladmin -u root password ’1′
sudo /etc/init.d/mysql restart
mysql -uroot -p1

添加mysql服务,配置开机启动mysqld:
sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
sudo update-rc.d mysql defaults