Linux中mysql的安装

1.linux新版中，自带了数据库mariadb

rpm  -qa | grep -i  mariadb       #  i为忽略大小写  

2.卸载mariadb

rpm -e mariadb-libs-5.5.68-1.el7.x86       

3.查看有无mysql

  [root@localhost ~]# rpm -qa|grep -i mysql
  [root@localhost ~]# find / -name mysql   #在根目录下进行查找

4.利用wget 下载 mysql的rpm

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

5.在线安装

yum -y install mysql57-community-release-el7-11.noarch.rpm

6.查看一下安装效果

yum repolist enabled | grep mysql.*

7.直接安装服务

yum install mysql-community-server

8.启动mysql服务

systemctl start  mysqld.service

9.查看状态

systemctl status mysqld.service

10.查看安装的默认密码

grep "password" /var/log/mysqld.log

11.登录

mysql -uroot -p   单独输入登录的原始密码

12.修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root@123';

13.从window电脑通过mysql的客户端连接 linux上的mysql

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Root@123' WITH GRANT OPTION;
## 使修改生效
FLUSH PRIVILEGES;  

14.开机自启

systemctl enable mysqld
systemctl daemon-reload