centos7 服务器 MySQL 安装

安装MySQL 折磨了我良久，shi试过很多方法，终于装好了，我把我认为最简单的方法写一下

 

1.配置YUM源

    在MySQL官网中下载YUM源rpm安装包：http://dev.mysql.com/downloads/repo/yum/ 

# 下载源码安装包
# wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
# 安装源码
# yum localinstall mysql57-community-release-el7-8.noarch.rpm

# 这是MySQL-5.7.23 的版本，需要其他版本到官网找到下载地址即可

    检查是否安装成功

# yum repolist enabled | grep "mysql.*-community.*"

    

    安装成功

2.安装MySQL

# yum install mysql-community-server

3.启动MySQL服务器

# systemctl start mysqld

    查看启动状态

# systemctl status mysqld

● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2018-08-10 22:19:15 EDT; 12s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 29544 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 29461 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 29546 (mysqld)
    Tasks: 27
   CGroup: /system.slice/mysqld.service
           └─29546 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Aug 10 22:19:08 localhost.localdomain systemd[1]: Starting MySQL Server...
Aug 10 22:19:15 localhost.localdomain systemd[1]: Started MySQL Server.

    若出现一下代码，则启动成功

4.设置开机启动

# systemctl enable mysqld
# systemctl daemon-reload

5.修改root默认密码

    获得临时密码

# grep 'temporary password' /var/log/mysqld.log

    进入 MySQL并修改密码

# mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 

# 或者

mysql> set password for 'root'@'localhost'=password('123456');

 

如果遇到

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

这种情况 或者忘记密码

 

解决方法如下：

# 停止 MySQL
# systemctl stop mysqld.service

# 配置无密码登录
# vi /etc/my.cnf

# 在末尾加上 skip-grant-tables 
# 保存退出

# 启动 MySQL
# systemctl start mysqld.service

# 登录
# mysql -u root
# 没有 -p

# 修改密码
# use mysql;
# update mysql.user set authentication_string=password('123456') where user='root' ;

    最后把 skip-grant-tables  注释掉或者删掉

 

参考：https://www.cnblogs.com/lgqboke/p/6873734.html

          https://blog.csdn.net/keepd/article/details/77151006