open Euler 数据库

最新推荐文章于 2024-09-13 21:40:38 发布

周湘zx

最新推荐文章于 2024-09-13 21:40:38 发布

阅读量252

点赞数 2

分类专栏：云原生高级文章标签：数据库服务器 linux

本文链接：https://blog.csdn.net/weixin_68256171/article/details/141034649

版权

云原生高级专栏收录该内容

25 篇文章 1 订阅

订阅专栏

数据库安装前提——软件仓库成功搭建

1、下载软件包

[root@server_node ~]# dnf install mariadb-server -y

# 若下载有冲突，则用 "rpm -qa | grep selinux" 查看冲突软件，再用 "rpm -e 软件 --nodeps" 删除

2、启动

[root@server_node ~]# systemctl enable --now mariadb

3、安全初始化

[root@server_node yum.repos.d]# mysql_secure_installation

4、普通用户远程登录

MariaDB [(none)]> CREATE USER zz@'%' identified by 'zx';
MariaDB [(none)]> CREATE DATABASE bbs;
MariaDB [(none)]> GRANT ALL ON bbs.* TO zz@'%';
MariaDB [(none)]> SHOW GRANTS FOR zz@'%';
+---------------------------------------------------------------------------------------------------+
| Grants for zz@%                                                                                   |
+---------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `zz`@`%` IDENTIFIED BY PASSWORD '*6CF62B3B5BBDE0E472D2D487CBBAAA924A77E249' |
| GRANT ALL PRIVILEGES ON `bbs`.* TO `zz`@`%`                                                       |
+---------------------------------------------------------------------------------------------------+
2 rows in set (0.008 sec)

[root@server_node ~]# systemctl set-default multi-user.target # 默认开启时无图形

[root@server_node ~]# systemctl set-default graphical.target # 有图形

5、数据库密码破解

# 法一：直接暴力，但站在企业角度不可用
[root@server_node ~]# rm -rf /var/lib/mysql/*

# 法二
[root@server_node ~]# systemctl stop mariadb
# 跳过MySQL的授权表
[root@server_node ~]# mysqld_safe --skip-grant-tables&
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> alter user root@localhost identified by 'zx';

[root@server_node ~]# ps aux | grep mariadb
[root@server_node ~]# killall -9 mysqld_safe            # kill -9 进程id
[root@server_node ~]# systemctl start mariadb