安裝成功的樣子：

[[email?protected] mysql]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 18130

Server version: 8.0.19 MySQL Community Server - GPL

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.

mysql>

mysql> show databases

-> ;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| zabbix |

+--------------------+

5 rows in set (0.00 sec)

mysql>

版本說明

系統：Redhat linux 7.6

數據庫：mysql-community-8.0.19

YUM 安裝方法

有三種方法安裝，源碼，RPM，YUM，超級方便是 YUM

安裝官方的YUM源

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

yum update

使用第三方的YUM源

[mysql80-community]

name=MySQL 8.0 Community Server

baseurl=http://mirrors.ustc.edu.cn/mysql-repo/yum/mysql-8.0-community/el/7/x86_64/

enabled=1

gpgcheck=0

安裝命令

yum install mysql-server

安裝后的配置工作

創建Mysql賬戶

groupadd mysql

useradd -g mysql mysql

啟動MySQL

systemctl start mysqld

查看初始化密碼

最后面那個亂亂的字符串

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

2020-03-28T12:50:12.584472Z 5 [Note] [MY-010454] [Server] A temporary password is generated for [email?protected]: %T;#X7MYdT,U

登錄MySQL

mysql -u root -p

修改初始化密碼

密碼一定要大小寫字母+數字+符號，如：Aa-123456789

ALTER USER [email?protected] IDENTIFIED BY ‘newpassword‘;

遠程設置

use mysql;

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

原文：https://blog.51cto.com/12641643/2486426

總結

以上是生活随笔為你收集整理的linux mysql安装_LINUX 安装 MYSQL的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。