安装iptables-
安装wget
安装gcc
安装pcre-devel
安装zlib-devel
安装openssl-devel
防火墙配置
下载安装文件
安装cmake
安装mysql
配置mysql
启动mysql
Starting MySQL. SUCCESS!
配置user
注意:在初始化数据库的时候出现下面的错误
[quote] FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db:[/quote]
解决方法 :安装autoconf库
安装完autoconf库,再运行/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql 问题消失!!!
yum install iptables-services
安装wget
yum install wget -y
安装gcc
yum install gcc gcc-c++ ncurses-devel perl -y
安装pcre-devel
yum -y install pcre-devel
安装zlib-devel
yum -y install zlib-devel
安装openssl-devel
yum -y install openssl openssl-devel
防火墙配置
vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
/bin/systemctl restart iptables.service
下载安装文件
wget http://dev.mysql.com/get/archives/mysql-5.6/mysql-5.6.23.tar.gz
wget http://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz
安装cmake
tar zxf cmake-3.1.1.tar.gz
./configure
make && make install
安装mysql
tar zxf mysql-5.6.23.tar.gz
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
make && make install
配置mysql
cat /etc/passwd --查看用户列表
cat /etc/group --查看用户组列表
groupadd mysql --创建组
useradd -g mysql mysql --创建用户
chown -R mysql:mysql /usr/local/mysql --修改权限
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --初始化数据库
mv /etc/my.cnf /etc/my.cnf.bak --备份默认my.cnf
启动mysql
cp support-files/mysql.server /etc/init.d/mysql
chmod a+wrx /etc/init.d/mysql
chkconfig mysql on
service mysql start
Starting MySQL. SUCCESS!
配置user
vi /etc/profile
PATH=/usr/local/mysql/bin:$PATH
export PATH
source /etc/profile --立即生效
mysql -uroot --首次登录
SET PASSWORD = PASSWORD('123456'); --修改密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; --配置远程访问
flush privileges;
注意:在初始化数据库的时候出现下面的错误
[quote] FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db:[/quote]
解决方法 :安装autoconf库
yum-y install autoconf //此包安装时会安装Data:Dumper模块
安装完autoconf库,再运行/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql 问题消失!!!