redHat7.6安装MySQL8.0
2019-11-21 本文已影响0人
心如苍井_空如水
一：源码安装
1.在官网下载好后将下载的MySQL上传到服务器
[root@localhost ynxx]# ll
总用量 756624
drwxr-xr-x. 7 10 143 245 7月 4 19:37 jdk1.8.0_221
-rw-r--r--. 1 root root 195094741 11月 21 00:28 jdk-8u221-linux-x64.tar.gz
-rw-r--r--. 1 root root 579686400 11月 21 00:36 mysql-8.0.18-1.el8.x86_64.rpm-bundle.tar
2.解压
[root@localhost ynxx]# tar xf mysql-8.0.18-1.el8.x86_64.rpm-bundle.tar
[root@localhost ynxx]# ll
总用量 1322740
drwxr-xr-x. 7 10 143 245 7月 4 19:37 jdk1.8.0_221
-rw-r--r--. 1 root root 195094741 11月 21 00:28 jdk-8u221-linux-x64.tar.gz
-rw-r--r--. 1 root root 579686400 11月 21 00:36 mysql-8.0.18-1.el8.x86_64.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 12307740 9月 23 15:19 mysql-community-client-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 22301616 9月 23 15:19 mysql-community-client-debuginfo-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 615256 9月 23 15:20 mysql-community-common-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 2893980 9月 23 15:20 mysql-community-debuginfo-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 20198496 9月 23 15:20 mysql-community-debugsource-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 2090236 9月 23 15:20 mysql-community-devel-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 1462400 9月 23 15:20 mysql-community-libs-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 2020228 9月 23 15:20 mysql-community-libs-debuginfo-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 54321732 9月 23 15:21 mysql-community-server-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 20898836 9月 23 15:21 mysql-community-server-debug-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 93294068 9月 23 15:21 mysql-community-server-debug-debuginfo-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 190301696 9月 23 15:21 mysql-community-server-debuginfo-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 142439684 9月 23 15:22 mysql-community-test-8.0.18-1.el8.x86_64.rpm
-rw-r--r--. 1 7155 31415 14521988 9月 23 15:22 mysql-community-test-debuginfo-8.0.18-1.el8.x86_64.rpm
二：二进制安装
参考地址：https://blog.csdn.net/vkingnew/article/details/81267223
将下载好的二进制文件上传到服务器，可以看到这个版本采用了tar.xz的打包压缩方式
[root@localhost /]# cd mysql/
[root@localhost mysql]# ls
mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz
解压
[root@localhost mysql]# tar -xJvf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz
mysql-8.0.18-linux-glibc2.12-x86_64/bin/
mysql-8.0.18-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-8.0.18-linux-glibc2.12-x86_64/bin/myisamchk
mysql-8.0.18-linux-glibc2.12-x86_64/bin/myisamlog
。。。。。。。以下省略
[root@localhost mysql]#
移动 到mysql下
[root@localhost /]# mv /mysql/mysql-8.0.18-linux-glibc2.12-x86_64/ /usr/local/mysql
[root@localhost /]# cd /usr/local/mysql
[root@localhost mysql]# ls
bin docs include lib LICENSE LICENSE.router man README README.router run share support-files var
配置参数文件
[root@localhost /]# vi /etc/my.cnf
[root@localhost /]# cat /etc/my.cnf
[mysqld]
server-id = 1
port = 3306
mysqlx_port = 33060
mysqlx_socket = /tmp/mysqlx.sock
datadir = /data/mysql
socket = /tmp/mysql.sock
pid-file = /tmp/mysqld.pid
log-error = error.log
slow-query-log = 1
slow-query-log-file = slow.log
long_query_time = 0.2
log-bin = bin.log
relay-log = relay.log
binlog_format =ROW
relay_log_recovery = 1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect ='SET NAMES utf8mb4'
innodb_buffer_pool_size = 1G
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
log_timestamps = SYSTEM
lower_case_table_names = 1
default-authentication-plugin =mysql_native_password
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
创建目录授权等
[root@localhost /]# mkdir -p /data/mysql
[root@localhost /]# groupadd mysql
[root@localhost /]# useradd mysql
useradd：mysql 组已经存在 - 如果您想将此用户加入到该组，请使用 -g 参数。
[root@localhost /]# useradd -g mysql mysql
[root@localhost /]# chown -R mysql:mysql /data/mysql/
[root@localhost /]# chmod -R 775 /data/mysql/
初始化数据库
官方推荐使用--initialize，在错误日志中生成难以输入的临时密码
[root@localhost /]# usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize
[root@localhost /]# cat /data/mysql/error.log | grep -i password
2019-11-21T11:07:18.200635+08:00 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 3g&W7SqLT9iR #密码
设置启动文件和环境变量：
[root@localhost /]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
启动数据库
[root@localhost /]# /etc/init.d/mysql start
Starting MySQL.. SUCCESS!
编辑配置
[root@localhost /]# vi /etc/profile.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin
让配置生效
[root@localhost /]# source /etc/profile.d/mysql.sh
查看版本
[root@localhost /]# mysqld --version
/usr/local/mysql/bin/mysqld Ver 8.0.18 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
登录，密码为空不用输入直接回车
[root@localhost /]# /usr/local/mysql/bin/mysql -p -S /tmp/mysql.sock
Enter password: 3g&W7SqLT9iR
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.18 MySQL Community Server - GPL
Copyright (c) 2000, 2019, 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.
mysql>
查看版本
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.18 |
+-----------+
1 row in set (0.00 sec)
.更改密码：
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.02 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
登录
[root@localhost /]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.18 MySQL Community Server - GPL
Copyright (c) 2000, 2019, 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.
mysql>
20191121111743.png
连接报错，没有开放远程登录
开放远程登录
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set host = '%' where user ='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
20191121111924.png
mysql 停止
[root@localhost /]# /etc/init.d/mysql stop
Shutting down MySQL... SUCCESS!
注意：登录后，操作报错，要重置密码。
错误
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
修改，即可
ALTER USER USER() IDENTIFIED BY '12345678'
