知识来源《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,然后用新设置的密码登录