CentOS6.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'