centos7 装mysql5.6_Centos7安装并配置mysql5.6

Centos7安装并配置mysql5.6

下载安装mysql-5.6.39-linux-glibc2.5-x86_64.tar.gz

创建一个管理数据库的新用户，例如：mysql 并创建所属组

groupadd mysql

useradd -g mysql mysql

将下载的压缩包放到 /usr/local/ 目录下

mv 源文件 /usr/local/

解压安装包

tar -zxvf mysql-5.6.39-linux-glibc2.5-x86_64.tar.gz

进入/usr/local/目录，更给解压文件名

mv mysql-5.6.39-linux-glibc2.5-x86_64 mysql

创建/etc/my.cnf 文件

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

# *** default location during install, and will be replaced if you

# *** upgrade to a newer version of MySQL.

[mysql]

default-character-set=utf8

socket=/var/lib/mysql/mysql.sock

[mysqld]

skip-name-resolve

port = 3306

#设置3306端口

socket=/var/lib/mysql/mysql.sock

# 设置mysql的安装目录

basedir=/usr/local/mysql

# 设置mysql数据库的数据的存放目录

datadir=/usr/local/mysql/data

# 允许最大连接数

max_connections=200

# 服务端使用的字符集默认为8比特编码的latin1字符集

character-set-server=utf8

# 创建新表时将使用的默认存储引擎

default-storage-engine=INNODB

lower_case_table_name=1

max_allowed_packet=16M

default-time-zone = '+08:00'

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

# basedir = .....

# datadir = .....

# port = .....

# server_id = .....

# socket = .....

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

#指定日志

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

更改/etc/my.cnf权限为644,默认my.cnf权限不能为777。

更改文件的所属者

chown -R mysql:mysql ./

创建socket、日志，pid文件。

为socket文件创建软连接(不创建安全初始化会报错)

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

安装数据库

./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ 安装数据库

可能出现的问题：报错

FATAL ERROR: please install the following Perl modules before executing

./scripts/mysql_install_db:Data::Dumper

解决方法： yum -y install autoconf //此包安装时会安装Data:Dumper模块

重新安装数据库

设置开机启动脚本，并添加执行权限。

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

chmod +x /etc/rc.d/init.d/mysqld

将mysqld服务加入到系统服务

chkconfig --add mysqld

检查mysqld服务是否已经生效

chkconfig --list mysqld

可以尝试启动mysql

service mysqld start

将mysql的bin目录加入PATH环境变量，编辑 ~/.bash_profile文件

vim ~/.bash_profile

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

安全初始化

/user/local/mysql/bin/mysql_secure_installation

连接数据库

mysql -uroot -p

默认禁止远程连接，可以打开。

mysql>GRANT ALL PRIVILEGES ON *.* TO 'your username'@'%' IDENTIFIED BY 'your password' WITH GRANT OPTION;

(%代表全部连接地址，也可以指定IP地址远程连接。)