关于mysql:linux安装mysql

mysql安装包下载地址
https://dev.mysql.com/downloa…

1. centos默认会装置mariadb所以要先卸载一下，防止出现抵触
   rpm -qa | grep mariadb
   
   卸载：rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 –nodeps
   
   2.在usr/local下创立mysql目录
   cd /usr/local&mkdir&&mysql
   3.解压文件
   tar -xvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar
2. 装置
   rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm –nodeps –force
   rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm –nodeps –force
   rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm –nodeps –force
   rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm –nodeps –force
   5.初始化
   mysqld –initialize
   chown mysql:mysql /var/lib/mysql -R
   systemctl start mysqld.service
   systemctl enable mysqld

6.查看数据库明码
cat /var/log/mysqld.log | grep password
7.登录
mysql -uroot -p
而后输出查看的明码，这边我测试的话用复制过去的明码始终谬误要手动输出能力胜利！算是一个坑点。
8.批改明码
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’
9.近程拜访受权
create user ‘root’@’%’identified with mysql_native_password by ‘123456’;
grant all privileges on . to ‘root’@’%’ with grant option;
flush privileges;
10.重启mysql服务
service mysqld restart
11.凋谢端口
firewall-cmd –zone=public –add-port=3306/tcp –permanent
firewall-cmd –reload