centos7.2安装mysql
程序员文章站
2022-05-27 18:57:01
...
centos7.2安装mysql
Step1.检测系统是否安装mysql
yum list installed | grep mysql
Step2.删除系统自带的mysql及其依赖
yum -y remove xxxxxx
Step3.安装Yum Repo
# 由于CentOS 的yum源中没有mysql,需要到mysql的官网下载yum repo配置文件
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
Step4.安装MySQL
yum install mysql-server
Step5.启动msyql
systemctl start mysqld
Step6.获取安装时的临时密码
grep 'temporary password' /var/log/mysqld.log
Step7.登录成功后修改密码
mysql -u root -p
set password=password("newpassword");
exit;
Step8.设置安全选项
mysql_secure_installation
Step9.mysql启动关闭命令
systemctl stop mysqld #关闭MySQL
systemctl restart mysqld #重启MySQL
systemctl status mysqld #查看MySQL运行状态
systemctl enable mysqld #设置开机启动
systemctl disable mysqld #关闭开机启动
Step10.开启远程控制
# 数据库名.表名 如果写成*.*代表授权所有的数据库
grant all privileges on 数据库名.表名 to 创建的用户名(root)@"%" identified by "密码";
例如: grant all privileges on *.* to [email protected]"113.64.243.2" identified by "123456789";
#刷新刚才的内容
flush privileges;
Step11.配置默认编码为utf8
vi /etc/my.cnf
#添加
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
Step12.其他默认配置文件路径
配置文件:/etc/my.cnf
日志文件:/var/log//var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pid
数据文件: /var/lib/mysql
参考博客:https://blog.csdn.net/u010375456/article/details/90313296
上一篇: centos7.2下安装mysql
下一篇: mysql离线部署