Linux服务器安装Mysql

Linux服务器安装Mysql

1、下载Mysql安装包

下载地址：https://dev.mysql.com/downloads/

• 选择 Mysql Communlty Server
  
• 选择 Mysql 版本其中 Select Os Version 要根据安装的linux内核版本决定
  

2、安装 Mysql

• 创建 Mysql 安装包存放路径并上传下载好的 Mysql 安装包到该目录

$ mkdir /usr/local/mysql_warp

• 解压安装包

$ cd /usr/local/mysql_warp
$ tar -xvf mysql-8.0.35-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql_warp

• 使用rpm安装
  必须按照顺序执行命令，否则会出现依赖错误的报错

$ rpm -ivh mysql-community-common-8.0.35-1.el7.x86_64.rpm
$ rpm -ivh mysql-community-client-plugins-8.0.35-1.el7.x86_64.rpm
$ rpm -ivh mysql-community-libs-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.35-1.el7.x86_64.rpm

• 安装时报错处理方案

mysql-community-libs-8.0.35-1.el7.x86_64.rpm 报错

warning: mysql-community-libs-8.0.35-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
    mariadb-libs is obsoleted by mysql-community-libs-8.0.25-1.el7.x86_64

解决方案

$ rpm -q mariadb-libs  ##会打印出具体包名
$ rpm -e 打印出的包名 ##可能会报错，如果报错执行下一步否则
$ yum remove postfix ##运行后再次执行上一步

执行完上述操作再次安装 mysql-community-libs-8.0.35-1.el7.x86_64.rpm

mysql-community-devel-8.0.35-1.el7.x86_64.rpm报错

warning: mysql-community-devel-8.0.35-1.el7.x86_64.rpm: Header V3 DSA/SHA256 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
pkgconfig(openssl) is needed by mysql-community-devel-8.0.25-1.el7.x86_64

解决方案

$ yum install openssl-devel -y

执行完上述操作再次安装 mysql-community-devel-8.0.35-1.el7.x86_64.rpm

mysql-community-server-8.0.35-1.el7.x86_64.rpm 报错

warning: mysql-community-server-8.0.35-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
    /usr/bin/perl is needed by mysql-community-server-8.0.35-1.el7.x86_64
    perl(Getopt::Long) is needed by mysql-community-server-8.0.25-1.el7.x86_64
    perl(strict) is needed by mysql-community-server-8.0.35-1.el7.x86_64

解决方案

$ yum list perl
$ yum install -y perl.x86_64
$ yum list libaio
$ yum install -y libaio*

执行完上述操作再次安装 mysql-community-server-8.0.35-1.el7.x86_64.rpm

3、配置Mysql

• 配置mysql忽略表名大小写敏感

$ vim /etc/my.cnf
## 在 my.cnf 文件的 [mysqld]下面添加
## lower_case_table_names=1

• 启动 Mysql

$ systemctl start mysqld

• 查看mysql初始密码

$ cat /var/log/mysqld.log | grep password

• 登录 mysql 服务

$ mysql -u root -p  

• 初始化root密码（不初始化不能进行其他操作）

alter user 'root'@'localhost' identified by '密码';

• 设置root用户可远程登录

use mysql;（选择数据库）
select host, user, plugin from user;（查看权限）
update user set host='%' where user='root';（设置root用户远程登录）
flush privileges;（刷新权限）

• 设置 Mysql服务开机自启

$ systemctl enable mysqld