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教程
发布评论