一、安装前准备工作
1.下载MySQL安装包,上传到服务器
2. 检查是否已经安装过mysql:rpm -qa | grep mysql
有的话就卸载掉以前安装的mysql: rpm -e --nodeps xxx(xxx是搜索结果)
3. 安装依赖包 yum install libaio libaio-devel -y
4. 创建操作系统层的MySQL专用账户和用户组,均命名为mysql
groupadd mysql
useradd -g mysql mysql
5. 设置用户操作系统资源的限制
[root@localhost ~]#vi /etc/security/limits.conf
mysql soft nproc 2047
mysql hard nproc 16384
mysql soft nofile 1024
mysql hard nofile 65536
6. 创建安装路径,数据文件存放路径
mkdir /mysql
mkdir /data
chown -R mysql:mysql /mysql
chown -R mysql:mysql /data
7. 禁用selinux SELINUX=disabled
二、安装MySQL
1. 执行tar命令,解压下载好的MySQL至/mysql tar -xzvf mysql-5.6.28.tar.gz
2. 配置参数文件/etc/my.cnf
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
port=3306
basedir = /mysql
datadir = /data/
socket = /data/mysql.sock
expire_logs_days=2
max_binlog_size=10M
server-id=1binlog-format=ROW
log-slave-updates=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log-events=1
innodb_flush_log_at_trx_commit=1
sync_binlog=1
default-storage-engine = INNODB
lower_case_table_names=1
max_connections=2000
log-bin-trust-function-creators=1
[mysqld_safe]log-error=/data/log/mysqld.err
pid-file=/data/log/mysqld.pid
[client]
user=root
password="root"
socket = /data/mysql.sock
3. 初始化数据库
cd /mysql
scripts/mysql_install_db --user=mysql --basedir=/mysql --datadir=/data/mysqldata
4. 启动数据库
bin/mysqld_safe --user=mysql &
5. 配置PATH路径
vi /etc/profile
export PATH=$PATH:/mysql/bin
6. 配置MySQL自启
cp support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list mysqld
7. 修改并删除匿名用户
mysql> update mysql.user set password=password('root') where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> delete from mysql.user where user='';Query OK, 2 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)