CentOS上安装mysql5.5安装

mysql5.5下载

下面官方网站下载mysql5.5

http://dev.mysql.com/downloads/mysql/

mysql5.5安装

1.cmake安装

cmake代码安装必要工具

$ yum install cmake

2.mysql安装

$ 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

3-3 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)