Linux安装Mysql
1、查看是否有mariadb
若存在,将其删除;否则会和Mysql冲突。
rpm -qa | grep mariadb
删除命令
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
2、上传MySQL并解压
tar -zxvf 安装包名 目录
使用rpm安装,存在依赖关系,需要按一定的顺序安装
rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
yum install net-tools
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
3、启动mysql
systemctl status mysqld 查看服务状态
systemctl start mysqld 启动mysql
systemctl enable mysqld 开机启动mysql,避免每次开机启动
netstat -tunlp 查看已经启动的服务
netstat -tunlp | grep mysql
ps -ef | grep mysql 查看进程
4、登录数据库,查阅临时密码
查阅临死密码
cat /var/log/mysqld.log | grep password
mysql -u -p 进入mysql
修改密码,开放访问权限
set global validate_password_length=4; 设置密码长度最低位数
set global validate_password_policy=LOW; 设置密码安全等级
set password=password(''); 设置密码
开启访问权限
grant all on *.* to 'root'@'%' identified by 'root';
flush privileges;