Linux安装Mysql
一、下载
下载地址:Mysql官网下载地址
1、查看mysql是否已经安装
# 查看mysql是否安装
rpm -qa | grep mysql
# 查看mariadb是否安装
rpm -qa | grep mariadb
# mariadb 已经安装,则删除
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
2、下载 mysql
# 若无wget,则使用root用户安装
yum install wget
# 下载mysql
wget https://mirror.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/mysql-5.7.30-1.el6.i686.rpm-bundle.tar
二、安装 mysql
1、解压mysql
tar xvf mysql-5.7.30-1.el6.i686.rpm-bundle.tar -C /opt/software/mysql/
2、安装顺序
commons -> libs -> client -> service
# 非root用户需要加 sudo
rpm -ivh mysql-community-common-5.7.30-1.el6.i686.rpm
rpm -ivh mysql-community-libs-5.7.30-1.el6.i686.rpm
rpm -ivh mysql-community-client-5.7.30-1.el6.i686.rpm
rpm -ivh mysql-community-server-5.7.30-1.el6.i686.rpm
注意:
- 若出现如下错误:
warning: mysql-community-libs-5.7.30-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
- 则在命令后加语句 --force --nodeps,如
sudo rpm -ivh mysql-community-server-5.7.30-1.el6.i686.rpm --force --nodeps
3、查看是否安装成功
rpm -qa | grep mysql
4、启动mysql服务
# 启动MySQL
sudo systemctl start mysqld
# 从mysql的日志中查找临时密码
sudo cat /var/log/mysqld.log | grep password
三、修改mysql的密码
validate_password=off
2、重启mysql服务
# 重启mysql,关闭密码策略
sudo systemctl restart mysqld
3、更改密码
alter user'root'@'localhost' identified by'123456';
四、允许远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; //允许所有访问
FLUSH PRIVILEGES; //刷新生效