MySQL的安装、启动和基础配置
发布时间:2019-09-06 19:54
# 安装mysql社区版本yum源 yum -y install http://repo.mysql.com/yum/mysql-5.6-community/el/7/x86_64/mysql-community-release-el7-5.noarch.rpm # 找到community社区版本的mysql包 yum search mysql |grep community # 使用yum安装下列 yum -y install mysql-community-server.x86_64 mysql-community-client.x86_64 mysql-community-server.x86_64 mysql-community-client.x86_64 安装方式二:
# 下载离线包
yumdownloader mysql-community-server.x86_64 mysql-community-client.x86_64 mysql-community-libs.x86_64 mysql-community-common.x86_64
yum -y install mysql-community-client-5.6.41-2.el7.x86_64.rpm mysql-community-server-5.6.41-2.el7.x86_64.rpm mysql-community-common-5.6.41-2.el7.x86_64.rpm mysql-community-libs-5.6.41-2.el7.x86_64.rpm
操作mysql相关常用shell命令
# 启停服务
systemctl {start|stop|restart|status} mysqld.service
systemctl start mysqld.service
# 查看服务状态
systemctl status mysqld.service
# 安全初始化
/usr/bin/mysql_secure_installation
# 停系统防火墙
systemctl stop firewalld.service
# 查看强制访问控制状态
getenforce
# 关闭强制访问控制策略
setenforce 0
登陆和初始化密码
# 创建root远程登陆密码
mysql -h 127.0.0.1 -u root -p
mysql grant all privileges on *.* to root@ % identified by root 
mysql flush privileges;
服务热线
在线咨询