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

LINUX 安装 MYSQL

上一篇:python连接SQLServer数据库,执行给定的查询SQL语句,并返回查询结果数据


下一篇:idea怎么设置自己的名字和时间