CentOS6.7安装mysql-5.5.49-优快云博客

本文详细介绍了在CentOS 6.7环境下手动安装MySQL 5.5.49的过程，包括安装环境配置、依赖包安装、创建用户及组、数据库数据目录设置、源码编译安装、环境变量配置、数据库初始化及启动等步骤。

1、安装环境

    [root@node80 ~]# cat /etc/redhat-release
    CentOS release 6.7 (Final)
    [root@node80 ~]# uname -r
    2.6.32-573.el6.x86_64
    [root@node80 ~]# grep “node80” /etc/hosts    #host指向
    192.168.0.80    node80

2、安装依赖包

    [root@node80 ~]# yum install cmake  ncurses-devel -y

--------------------------------------------cmake源码安装方式
    mkdir /home/tools
    cd /home/tools
    wget www.cmake.org/files/v2.8/cmake-2.8.0.tar.gz
    tar -zxvf cmake-2.8.0.tar.gz
    cd cmake-2.8.0
    ./configure
    gmake
    gmake install
--------------------------------------------------------------

3、创建用户和组以及创建数据库数据目录

    [root@node80 tools]#useradd mysql -s /bin/nologin -M
    [root@node80 tools]#mkdir /data
    [root@node80 tools]#chown -R mysql.mysql /data

4、开始安装mysql-5.5.49

    [root@node80 home]# mkdir /home/tools && cd /home/tools
    [root@node80 tools]# wget  http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.49.tar.gz
    [root@node80 tools]# tar -zxvf mysql-5.5.49.tar.gz
    [root@node80 tools]# cd mysql-5.5.49
     [root@node80 tools]#cmake \
     -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5.49 \
     -DMYSQL_DATADIR=/data \
     -DMYSQL_UNIX_ADDR=/usr/local/mysql5.5.49/tmp/mysqld.sock \
     -DDEFAULT_CHARSET=utf8 \
     -DDEFAULT_COLLATION=utf8_general_ci \
     -DEXTRA_CHARSETS=all \
     -DENABLED_LOCAL_INFILE=1 \
     -DWITH_INNOBASE_STORAGE_ENGINE=1 \
     -DWITHOUT_FEDERATED_STORAGE_ENGINE=1 \
     -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
     -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
     -DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
     -DWITH_FAST_MUTEXES=1 \
     -DWITH_ZLIB=bundled \
     -DENABLED_LOCAL_INFILE=1 \
     -DWITH_READLINE=1 \
     -DWITH_EMBEDDED_SERVER=1 \
     -DWITH_DEBUG=0; 
     [root@node80 tools]# make
     [root@node80 tools]#make install

5、安装完成，接下去继续配置

    [root@node80 tools]#ln -s /usr/local/mysql5.5.49  /usr/local/mysql
    [root@node80 tools]#/bin/cp /home/tools/mysql-5.5.49/support-files/my-innodb-heavy-4G.cnf /etc/my.cnf
    [root@node80 tools]#/bin/cp /home/tools/mysql-5.5.49/support-files/mysql.server /etc/init.d/mysqld
    [root@node80 tools]#chmod +x /etc/init.d/mysqld
    [root@node80 tools]#chkconfig --add mysqld
    环境变量修改
    [root@node80 tools]#echo 'export PATH=/usr/local/mysql/bin:$PATH' >>/etc/profile
    [root@node80 tools]#source /etc/profile
    [root@node80 tools]#echo $PATH
    文件目录权限配置
    [root@node80 tools]#chown -R mysql.mysql /usr/local/mysql
    [root@node80 tools]#chmod -R 1777 /tmp
    初始化数据库
    [root@node80 tools]#cd  /usr/local/mysql/scripts
    [root@node80 tools]#./mysql_install_db --basedir=/usr/local/mysql --datadir=/data/ --user=mysql
    启动数据库
    [root@node80 tools]#/etc/init.d/mysqld start
    [root@node80 tools]#netstat -lntup | grep 3306
    增加root密码
    [root@node80 tools]#/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
    [root@node80 tools]#/usr/local/mysql/bin/mysqladmin -u root -h node80 password 'new-password'