1、安装

(1)查看原系统是否安装mysql

yum list installed mysql*

(2)查看现有安装包

 yum list mysql*

(3)安装mysql服务端

yum install mysql-devel(可以tab补全)

yum install mysql-server(可以tab补全)

(4)安装mysql客户端(可选)

yum install mysql

2、配置文件

(1)设置字符和引擎

vi /etc/myf.d/mysql-serverf
在[mysqld]下添加

character_set_server=utf8

default-storage-engine=INNODB

3、启动和关闭

(启动)service mysqld start

mysql -u root -p(刚安装完没有设置密码,直接回车)

(关闭)service mysqld stop

4、设置开机自启

 systemctl enable mysqld

 systemctl daemon-reload

5、开启远程登录

(1)use mysql;

(2)添加可以远程的用户:

update user set host='%' where user='root';

(4)给用户root设置密码:

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

(4)select host,user from user;

更多推荐

redhat8安装mysql教程