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

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

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

安装MySQL

rpm -qa 
rpm -qa | grep mysql
rpm -qa | grep mariadb
1
2
3

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

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

注意：安装这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
1
2
3
4
5
6
7

systemctl status mysqld
systemctl start mysqld

systemctl enable mysqld

netstat -tunlp
netstat -tunlp | grep mysql
ps -ef | grep mysql
1
2
3
4
5
6
7
8

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

注意：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;
1
2
3
4
5
6
7
8

show databases;
1