CentOS7+安装MySQL

• CentOS7.x 安装 MySQL服务个人觉得并没有太大的差别，不明白为什么会有人碰到这么多的问题（当然安装mysql的方式很多，这里是一种比较简单切成功率非常高的一种），下面我将自己安装流程罗列下来：

mysql版本：mysql5.7.x

步骤：

1. 卸载CentOS7自带的MariaDB

	yum remove mariadb*

备注：如果已经安装mysql，需要卸载原来的服务

2. 进入/usr/local/src/路径

	cd /usr/local/src/

3.安装MySQL(依次执行下列命令)

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql57-community-release-el7-8.noarch.rpm 
yum -y install mysql-server

3. mysql相关文件

（1）配置文件：/etc/my.cnf
（2）日志文件：/var/log/var/log/mysqld.log
（3）服务启动脚本：/usr/lib/systemd/system/mysqld.service
（4）socket文件：/var/run/mysqld/mysqld.pid

• 修改 vim /etc/my.cnf(下面是我的配置文件)

[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
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server_id = 1
expire_logs_days = 3
 
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

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

4. 启动mysql服务

• centos6：service mysqld restart
  centos7: systemctl start mysqld.service
• 获取启动日志中的随机密码

grep "password" /var/log/mysqld.log

上图中冒号后的就是随机密码

• 使用获取到密码登录mysql

mysql -u root -p

• 修改mysql密码（必须修改；mysql不同版本有不同的密码规则，5.7.x 必须包含 数字字母符号）

 alter user 'root'@'localhost' identified by 'XXXXXX';    
 flush privileges

XXXXXX 就是设置的密码
flush privileges 刷新权限

• 如果需要远程访问mysql

grant all on *.* to 'root'@'%' identified by 'xxxxxx'  with grant option;

root 设置的用户名
xxxxxx 该用户密码

以上就是本人安装5.7.x 的流程，安装过n次，记忆中不曾出过问题