用mysql先装mysql再装,LINUX 安装 MYSQL

安装成功的样子：

[root@locahost 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 root@localhost: %T;#X7MYdT,U

登录MySQL

mysql -u root -p

修改初始化密码

密码一定要大小写字母+数字+符号，如：Aa-123456789

ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';

远程设置

use mysql;

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