锐捷网络技能大赛-云平台部分-CentOS部分10-[Mariadb]

淡淡的烟草味﹌ 2022-11-21 03:38 137阅读 0赞

# 锐捷网络技能大赛-云平台部分-CentOS部分10-\[Mariadb\] #

**声明：写这些比赛的文章只是便于有些地区上进同学学习，博主本人只是出于好心，因此，博主没有对个人服务的义务，更何况一分钱都得不到，之所以这样讲是因为某些加我问问题的同学态度恶劣，因此我删除了很多地方我本人的联系方式，这个比赛本身和我一点关系都没有，只与你自己个人学习能力有关，看不看得懂和我一点关系都没有，懂的人自然都懂，我尽力了，你们随意！**

--------------------

**实在解决不了当然我也可以提供一些付费业务**  
原因1：太多人问我  
原因2：有些同学素质没那么高尚

--------------------

## Mariadb ##

#### 2019年A卷 ####

配置mariadb服务，修改mariadb配置文件，实现以下需求：

*  服务仅监听在192.168.1XX.33的IP地址上
 *  关闭数据库域名解析功能
 *  innodb开启独立表空间模式
 *  数据库存储位置为/data/database
 *  wordpress数据库授权wordpress用户能够通过192.168.1XX.0网段的主机执行所有操作。

[root@serverB ~]# systemctl restart mariadb
    [root@serverB ~]# cd /data/database
    [root@serverB ~]# chmod 777 /data/database
    [root@serverB database]# cp -rp /var/lib/mysql/* /data/database
    [root@serverB database]# ll
    总用量 28700
    -rw-rw---- 1 mysql mysql    16384 9月   8 00:25 aria_log.00000001
    -rw-rw---- 1 mysql mysql       52 9月   8 00:25 aria_log_control
    -rw-rw---- 1 mysql mysql 18874368 9月   8 00:25 ibdata1
    -rw-rw---- 1 mysql mysql  5242880 9月   8 00:25 ib_logfile0
    -rw-rw---- 1 mysql mysql  5242880 9月   8 00:15 ib_logfile1
    drwx------ 2 mysql mysql     4096 9月   8 00:15 mysql
    drwx------ 2 mysql mysql     4096 9月   8 00:15 performance_schema
    drwx------ 2 mysql mysql        6 9月   8 00:15 test
    [root@serverB database]# systemctl restart mariadb.service
    [root@serverB ~]# vim /etc/my.cnf
    [root@serverB ~]# cat !$
    cat /etc/my.cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mariadb according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    #添加下面[mysqld]和[client]节
    [mysqld]
    bind-address=192.168.110.33
    skip_name_resolve=ON
    innodb_file_per_table=ON
    datadir=/data/database
    socket=/data/database/mysql.sock
    
    [client]
    socket=/data/database/mysql.sock
    #
    # include all files from the config directory
    #
    !includedir /etc/my.cnf.d
    
    [root@serverB ~]# mysql -u root -p
    Enter password: 
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 8
    Server version: 5.5.60-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]> CREATE DATABASE wordpress;
    Query OK, 1 row affected (0.00 sec)
    
    MariaDB [(none)]> CREATE USER 'wordpress'@'localhost' IDENTIFIED BY '123456';
    Query OK, 0 rows affected (0.00 sec)
    
    MariaDB [(none)]> GRANT ALL ON wordpress.* to wordpress@'192.168.110.%' IDENTIFIED BY '123456';
    Query OK, 0 rows affected (0.00 sec)
    
    MariaDB [(none)]> FLUSH privileges;
    Query OK, 0 rows affected (0.00 sec)
    
    MariaDB [(none)]> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    | test               |
    | wordpress          |
    +--------------------+
    5 rows in set (0.00 sec)
    #修改默认密码
    MariaDB [(none)]> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    MariaDB [mysql]> UPDATE user SET password=password('123456') WHERE user='root';
    Query OK, 4 rows affected (0.00 sec)
    Rows matched: 4  Changed: 4  Warnings: 0
    
    MariaDB [mysql]> flush privileges;
    Query OK, 0 rows affected (0.00 sec)
    
    [root@serverB ~]# systemctl restart mariadb
    
    [root@serverB wordpress]# mysql -u root -p
    Enter password: 
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    [root@serverB wordpress]# mysql -u root -p
    Enter password: 
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 8
    Server version: 5.5.60-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjk1NjQy_size_16_color_FFFFFF_t_70_pic_center]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNjk1NjQy_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/7dd6ea1fa46f4410b0590135098b12c1.png