Centos 7安装MySQL5.6

安装步骤

确保之前未安装；若存在则要卸载

// 查看主机是否已经安装了mysql（如果存在则要卸载）
rpm -qa|grep mysql
// 卸载命令
rpm -e --nodeps "上面检索出的mysql安装包"

下载mysql的yum源

wget -P /usr/software http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
// 验证是否下载成功
ll /usr/software/

安装下载好的yum源

cd /usr/software/
rpm -ivh mysql-community-release-el6-5.noarch.rpm
ll /etc/yum.repos.d

使用yum安装MySQL服务器

yum search mysql
yum install -y mysql-community-server

启动MySQL服务并查看状态

service mysqld start
service mysqld status

修改MySQL密码

// mysql5.6 安装完成后，它的 root 用户的密码默认是空的，我们需要及时用 mysql 的 root 用户登录（第一次直接回车，不用输入密码），并修改密码。
mysql -u root

mysql> use mysql;
mysql> update user set password=PASSWORD("这里输入root用户密码") where User='root';
mysql> flush privileges;

远程连接设置

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;

遇到的问题

查看mysql服务器状态，发现是正常启动的，但就是无法连接MySQL，报如下错误

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

解决方法就是在/etc/my.cnf里面添加一个[client]

// 要保证[mysqld]和[client]终端socket路径一样
[mysqld]
#
# 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
#
# 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
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


[client]
socket = /var/lib/mysql/mysql.sock