CenterOS7环境下安装Mysql
下载Mysql
https://dev.mysql.com/downloads/mysql/5.5.html?os=31&version=5.1
检查系统是否自带Mysql
rpm -qa | grep mysql
如果有,删除掉
rpm -e --nodeps mysql的名称
检查是否自带mariadb
rpm -qa|grep mariadb
有就删除掉
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
通过工具(xshell)将mysql安装包上传到/usr/local
将其解压到Mysql目录下
tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql
rpm安装
/var/run/yum.pid 已被锁定 解决办法
rm -f /var/run/yum.pid
yum install glibc.i686
安装之前先安装需要的依赖,否则会报依赖错误
yum install libaio
按顺序进行安装
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
数据库初始化
mysqld --initialize --user=mysql
查看日志文件
cat /var/log/mysqld.log
注意:红色标记的是生成mysql的临时密码
启动mysql数据库
systemctl start mysqld.service
进入Mysql数据库(用临时密码)
mysql -uroot -p
修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; //新密码
管理mysql
启动mysql服务
systemctl start mysqld.service
停止mysql服务
systemctl stop mysqld.service
重启mysql服务
systemctl restart mysqld.service
查看mysql服务当前状态
systemctl status mysqld.service
设置mysql服务开机自启动
systemctl enable mysqld.service
停止mysql服务开机自启动
systemctl disable mysqld.service
重新安装时要删掉以下目录
rm -fr /var/lib/mysql
远程连接Mysql服务器
开启mysql的远程访问
添加一个用户供其远程连接访问
GRANT ALL PRIVILEGES ON *.* TO 'myxq'@'%' IDENTIFIED BY '1234' WITH GRANT OPTION;
flush privileges;
退出重启systemctl restart mysqld
开放端口
开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重新载入
firewall-cmd --reload
查看
firewall-cmd --zone= public --query-port=3306/tcp
删除
firewall-cmd --zone= public --remove-port=3306/tcp --permanent
重启防火墙服务
systemctl restart firewalld.service
开启与关闭防火墙
systemctl stop firewalld.service 停止firewall
systemctl start firewalld 启动
systemctl status firewalld 查看状态
systemctl restart firewalld.service 重新启动防火墙
重启防火墙时遇到 Failed to start firewalld.service: Unit firewalld.service is masked
执行:systemctl unmask firewalld.service
再从新启动systemctl start firewalld
systemctl disable firewalld.service 禁止firewall开机启动
firewall-cmd --reload 重回加载防火墙