mysql安装配置

配置YUM源 下载mysql源安装包 wget http://dev.mysql.com/get/mysql57-community-release-el7- 8.noarch.rpm 安装mysql源 yum localinstall mysql57-community-release-el7-8.noarch.rpm 检查mysql源是否安装成功 yum repolist enabled | grep "mysql.*-community.*" 出现类似图中所示说明导入成功 安装配置 MYSQL 安装 mysql yum install mysql-community-server 启动MySQL服务 systemctl start mysqld查看MySQL的启动状态 systemctl status mysqld 设置开机启动 systemctl enable mysqld && systemctl daemon-reload 修改root密码 找到root默认密码 grep ‘temporary password‘ /var/log/mysqld.log 登录 mysql mysql -uroot -p 修改 root 密码 set password for ‘root‘@‘localhost‘=password(‘G00dl^ck‘); 修改生效 flush privileges; 配置远程登录 更新用户 update user set host = ’%’ where user = ’root’; 用户授权 grant all privileges on *.* to root@‘%‘ identified by "G00dl^ck"; 授权生效 flush privileges;至此,可使用客户端远程连接 mysql 进行数据相关管理,推荐开发管理工具 Navicat

mysql安装配置

标签：oca   安装 mysql   lis   div   word   cal   com   mct   ora