[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‘;