MySQL笔记（1）安装MySQL5.6

知识来源《PHP与MySQL程序设计》第四版

yum 安装MySQL

禁用selinux：

sudo sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

重启服务器后，查看selinux 状态：sestatus

临时关闭selinux 重启后失效：setenforce 0

禁用firewalld

systemctl stop firewalld

systemctl disable firewalld

systemctl status firewalld

查看是否安装过MySQL

rpm -qa | grep mysql

卸载mariadb

rpm -qa | grep mariadb

rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

安装MySQL（http路径中el7 表示用于centos7 -5表示mysql5.6.*版本）

cd /usr/local/

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum install -y mysql-server

rpm -qa | grep mysql

systemctl enable mysqld.service

systemctl start mysqld.service

systemctl status mysqld

mysql -V  

# mysql -V
mysql  Ver 14.14 Distrib 5.6.51, for Linux (x86_64) using  EditLine wrapper

# rpm -qa | grep mysql
mysql-community-release-el7-5.noarch
mysql-community-common-5.6.51-2.el7.x86_64
mysql-community-libs-5.6.51-2.el7.x86_64
mysql-community-server-5.6.51-2.el7.x86_64
mysql-community-client-5.6.51-2.el7.x86_64

mysql -u root -p            # 5.6不需要密码 回车后自动进入MySQL

设置MySQL密码

SET PASSWORD FOR root@localhost=PASSWORD('1^#@$#213123');

systemctl restart mysqld

重新登录mysql mysql -u root -p1^#@$#213123

如果MySQL登录不上提示密码错误，可以做如下操作

参考链接：https://blog.csdn.net/vv19910825/article/details/82979563

vi /etc/my.cnf

在[mysqld]下面添加一行skip-grant-tables

systemctl restart mysqld

mysql -u root -p ###提示输入密码，直接回车即可登录进去

use mysql;

update user set password=password("你的新密码") where user="root";

flush privileges;

quit

把skip-grant-tables注释掉，重启MySQL，然后用新设置的密码登录