Centos7编译安装MySQL5.5

2331

关闭防火墙              

1 2	Systemctl stop firewall Setenforce 0

检查是否安装过MySQL        

1 2 3 4

rpm -qa |grep mysql [iyunv@localhost~]# rpm -qa|grep mariadb   centos7默认数据库 mariadb-libs-5.5.44-1.el7_1.x86_64 [iyunv@localhost~]# rpm -e --nodeps mariadb-libs-5.5.44-1.el7_1 强制卸载

安装编译代码所需要的包      

1	[iyunv@localhost ~]# yum -y install make gcc-c++ cmake bison-devel ncurses-devel libaio libaio-devel perl-Data-Dumper net-tools

解压并安装             

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

[iyunv@localhost ~]# tar zxf mysql-5.5.17.tar.gz [iyunv@localhost ~]# cd mysql-5.5.17/ [iyunv@localhost mysql-5.5.17]# cmake \ > -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ > -DMYSQL_DATADIR=/usr/local/mysql/data \ > -DSYSCONFDIR=/etc \ > -DWITH_MYISAM_STORAGE_ENGINE=1 \ > -DWITH_INNOBASE_STORAGE_ENGINE=1 \ > -DWITH_MEMORY_STORAGE_ENGINE=1 \ > -DWITH_READLINE=1 \ > -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \ > -DMYSQL_TCP_PORT=3306 \ > -DENABLED_LOCAL_INFILE=1 \ > -DWITH_PARTITION_STORAGE_ENGINE=1 \ > -DEXTRA_CHARSETS=all \ > -DDEFAULT_CHARSET=utf8 \ > -DDEFAULT_COLLATION=utf8_general_ci [iyunv@localhost mysql-5.5.17]# make && make install

创建MySQL用户组和用户

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

[iyunv@localhost mysql-5.5.17]# groupadd mysql [iyunv@localhost mysql-5.5.17]# useradd -g mysql mysql 修改mysql目录权限 [iyunv@localhost mysql-5.5.17]# chown -R mysql:mysql /usr/local/ 进入安装路径，执行初始化脚本，创建系统自带的库和表 [iyunv@localhost  mysql-5.5.17]#   scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql 启动mysql 拷贝文件 [iyunv@localhost mysql-5.5.17]# cp support-files/mysql.server /etc/init.d/mysql [iyunv@localhost mysql-5.5.17]# chkconfig mysql on              #开机启动 [iyunv@localhost mysql-5.5.17]# service mysql  start        #启动mysql Starting MySQL... SUCCESS! Netstat -lnp|grep 3306                   #检查端口 设置环境变量 vim /etc/profile 加入如下内容 PATH=/usr/local/mysql/bin:$PATH export PATH