侧边栏壁纸
博主头像
落叶人生博主等级

走进秋风,寻找秋天的落叶

  • 累计撰写 143977 篇文章
  • 累计创建 28 个标签
  • 累计收到 9 条评论
标签搜索

目 录CONTENT

文章目录

LINUX 安装 MYSQL

2024-04-03 星期三 / 0 评论 / 0 点赞 / 5 阅读 / 2661 字

安装成功的样子:[root@locahost mysql]# mysql -u root -pEnter password: Welcome to the MySQL monitor. Comman

安装成功的样子:

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

广告 广告

评论区