Linux 安装MySQL8.0.20

Linux 安装MySQL8.0.20

步骤

1.下载

进入目标文件下使用:

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

此文件下载后是 .xz 格式文件需要先使用 tar -xvf 解压

2.重命名此文件 为mysql-8.0.20

3.创建mysql 数据文件夹 : mkdir data (可以是随意文件)

4.创建用户组以及用户和密码:

groupadd mysql

useradd -g mysql mysql

5.授权用户 :
chown -R mysql.mysql /usr/local/mysql-8.0

6.编辑my.cnf文件:

vi /etc/my.cnf

[mysqld]
bind-address = 0.0.0.0
user=mysql
port=3306
basedir=/opt/mysql/mysql-8.0
datadir=/opt/mysql/data/mysql
socket=/opt/mysql/data/mysql/mysql.sock
character_set_server=UTF8MB4
server-id = 1
pid-file=/opt/mysql/data/mysql/mysql.pid
log-error=/opt/mysql/data/mysql/mysql.err
symbolic-links=0
explicit_defaults_for_timestamp=true

说明:

basedir: mysql 安装目录
datadir: data 路径
socket: 这个mysql.sock应该是mysql的主机和客户机在同一host上的时候，使用unix domain socket做为通讯协议的载体,单机配置的时候建议先注释掉

7.初始化基础信息:

./mysqld --user=mysql --basedir=/opt/mysql/mysql-8.0/ --datadir=/opt/mysql/data/mysql/ --initialize

8.如果

报错

./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

解决:出现该问题首先检查该链接库文件有没有安装使用 rpm -qa|grep libaio命令进行核查 运行该命令后发现系统中无该链接库文件

报错

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

解决:

有可能是 my.cnf 配置文件中设置了 [mysqld] 的参数 socket ，而没有设置[client]的参数socket

可以先注释掉,如果需要见

https://www.jb51.net/article/174244.htm

9.yum install libaio-devel.x86_64安装

10.再执行7步骤没有输出后表示初始化成功

11. 授权以及添加服务

  chmod +x /etc/init.d/mysql

  chkconfig --add mysql

12. 启动mysql

service mysql start

13. 查看启动状态

service mysql status

Starting MySQL...                                          [  OK  ]

14.登陆mysql

mysql -->  mysql -uroot -p

[root@i mysql-8.0]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.20

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

此时已经安装好了

15. 修改root密码

初始密码在 data-->mysql.err 文件中

进入MySQL下

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

16.执行 flush privileges; 使密码生效

17.选择mysql数据库 use mysql;

18.修改远程连接并生效,退出

update user set host='%' where user='root';

flush privileges;

　exit;