一、查看版本
mysqld -v
显示“-bash: mysqld: 未找到命令”表示未安装
二、安装mysql
1、安装Yum Repository
wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm
2、使用rpm来安装MySQL
rpm -ivh mysql80-community-release-el8-1.noarch.rpm
3、安装mysql
yum -y install mysql-server
三、启动服务
systemctl start mysqld.service
四、开机启动
systemctl enable mysqld.service
五、初始化mysql
mysql_secure_installation
回车
设置密码
确认密码
y
y
y
y
六、创建远程用户
1、进入mysql
mysql -u root -p
2、创建用户
create user ‘snakeyi’@’%’ identified by ‘12345678’;
3、用户授权
grant all privileges on . to ‘snakeyi’@’%’ with grant option;
4、刷新系统权限
flush privileges;
5、其它命令
①、查看MYSQL数据库中所有用户
SELECT DISTINCT CONCAT(‘User: ”’,user,”’@”’,host,”’;’) AS query FROM mysql.user;
②、查看数据库中具体某个用户的权限
show grants for ‘snakeyi’@’%’;
常用命令
服务状态：systemctl status mysqld.service
启动服务：systemctl start mysqld.service
停止服务：systemctl stop mysqld.service
重启服务：systemctl restart mysqld.service
开机启动：systemctl enable mysqld.service