【Linux虚拟机】Cent OS 下安装 MySQL 流程

Docker固然好用，不过以前刚入门的时候还没学到docker，而且了解一下传统的安装方法也是不错的；

资料来源于 黑马程序员，主从复制 mysql安装步骤，这里做一个笔记整理

安装MySQL

rpm -qa 
rpm -qa | grep mysql
rpm -qa | grep mariadb

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

mkdir /usr/local/mysql
tar -zxvf mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar.gz -C /usr/local/mysql

注意：安装这6个软件包要cd到mysql目录下

rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
yum install net-tools
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm

systemctl status mysqld
systemctl start mysqld

systemctl enable mysqld

netstat -tunlp
netstat -tunlp | grep mysql
ps -ef | grep mysql

cat /var/log/mysqld.log
cat /var/log/mysqld.log | grep password

注意：mysql中的命令一定要加分号

mysql -uroot -p

set global validate_password_length=4;
set global validate_password_policy=LOW;
set password = password('root');

grant all on *.* to 'root'@'%' identified by 'root';
flush privileges;

show databases;