mysql 5.6.12.tar.gz_LInux安装Mysql5.6.12

MYSQL 5.6安装

解决依赖包：

yum -y install gcc gcc-c++ ncurses-devel perl cmake

创建Mysql用户和组：

groupadd mysql

useradd -r -g mysql mysql

新建mysql所需要的目录：

mkdir /usr/local/mysql mysql的安装目录

mkdir /data/mysqldb mysql的数据目录

解压安装mysql：

tar zxvf mysql-5.6.12.tar.gz

cd mysql-5.6.12

cmake \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_INNOBASE_STORAGE_engine=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DMYSQL_DATADIR=/data/mysqldb \

-DMYSQL_TCP_PORT=3306 \

-DENABLE_DOWNLOADS=1

make && make install

修改mysql所属用户和组：

cd /usr/local/mysql

chown -R mysql:mysql .

cd /data/mysqldb

chown -R mysql:mysql .

初始化数据库：

cd /usr/local/mysql

scripts/mysql_install_db --user=mysql --datadir=/data/mysqldb

复制配置文件;

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

复制mysql启动文件并且配置PATH变量：

cp support-files/mysql.server /etc/init.d/mysqld

vim /etc/profile

PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH

export PATH

source /etc/profile

设置mysql开机自启动：

service mysqld start

chkconfig --level 35 mysqld on

设置mysql 管理密码：

mysqladmin -u root password 'QiAnHaIxFb@admin20170421#y!'

授权开发账户只读权限：

GRANT Select ON *.* TO 'dev'@'116.204.67.3' IDENTIFIED BY "2017@dev#SS!!//"

授权备份账户：

create user backup@'127.0.0.1';

grant select on *.* to backup@'127.0.0.1';

grant show view on *.* to backup@'127.0.0.1';

grant lock tables on *.* to backup@'127.0.0.1';

grant trigger on *.* to backup@'127.0.0.1';

程序用户：

iptables防火墙设置：

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

/etc/rc.d/init.d/iptables save

/etc/init.d/iptables status