mysql5.5下载
下面官方网站下载mysql5.5
http://dev.mysql.com/downloads/mysql/
mysql5.5安装
1.cmake安装
cmake代码安装必要工具
$ yum install cmake
$ tar zxvf mysql-5.5.33.tar.gz
$ cd mysql-5.5.33
$ cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=true \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_READLINE=ON
$ make
$ make test
$ make install
$ cd /usr/local/
$ ln -s /usr/local/mysql5.5 mysql
$ vi /etc/profile
#mysql path
export PATH=$PATH:/usr/local/mysql/bin;
$ source /etc/profile
3.mysql配置于初始化
3-1 my.cnf配置
$ cd /usr/local/src/mysql-5.5.33/support-files/
$ cp my-large.cnf /etc/my.cnf
$ vi /etc/my.cnf
[mysqld]
user=root
3-2 my.cnf配置
$ /usr/local/mysql/scripts/mysql_install_db --user=root --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
3-3 mysql启动文件配置
cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql
chkconfig --add mysql
chkconfig --list mysql
$ service mysql start
$ service mysql stop
4.mysql登陆
$ mysql -uroot
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)