mysql8.0.15的最简单安装

查看和删除linux上的sql

find / -name mysql
rpm -qa|grep -i mysql

rqm -e 要移除的rpm包

1.下载yum包
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

2.安装下载下来的包
yum localinstall mysql80-community-release-el7-1.noarch.rpm -y

3.查看包是否存在
yum search mysql-community-server

4.安装服务端
yum install mysql-community-server -y
5.查看linux中的mysql是否存在
ps -ef |grep mysql
6.开启mysql
systemctl start mysqld
7.查看密码   记住要先启动，才能查看密码
cat /var/log/mysqld.log | grep password  会出现密码   H#!9mQbplGDh       Qlr#<fyt+4xc
8.登录mysql
mysql -uroot  -p
9.设置密码长度
set global validate_password.policy=0;
set global validate_password.length=0;
10.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'
11.为mysql创建一个库并指定字符集
create database dev_xwplay DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

12.为mysql创建用户并指定密码
create user 'zyxh'@'%' identified by 'zyxh123';
13.修改所创建用户的密码
ALTER USER 'zyxh'@'%' IDENTIFIED WITH mysql_native_password BY 'zyxh123';
14.刷新，使设置生效
flush privileges;
15.为链接工具授权
grant all privileges on *.* to 'zyxh'@'%' with grant option;