MariaDB under Linux starts with the root user (recommended)

MariaDB under Linux starts with the root user (recommended)

Recently, due to the need to test security products, I wanted to adjust the startup user of mariadb to root. After some twists and turns, I finally succeeded!

Note: Starting MySQL as root is a very dangerous behavior, which is equivalent to giving the database operation user (database administrator or hacker) a channel to directly operate the system through MySQL!

In fact, the official does not allow root boot, so in the normal boot mode, root boot will return a startup failure and prompt in /var/log/mariadb/mariadb.log

Please consult the Knowledge Base to find out how to run mysqld as root!

Ok, let's get to the point, about how to start Mariadb:

Most people will do this: systemctl start mariadb

However, this instruction actually calls mariadb.service (use find to find the specific directory) to start mariadb.

Modify the mariadb.service configuration as follows:

# vi `find /usr -name 'mariadb.service' `

[Unit]

slightly

[Service]

Type=simple

User=mysql is changed to User=root here || the startup user of the service

Group=mysql is changed to Group=root || startup group of the service

#Script to initialize mysql library files. If the mysql directory is not empty, it will prompt "Database Mariadb is probably initialized in /var/lib/mysql already, nothing is done". If you see this message when troubleshooting, you can ignore it.

ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n

#Execute the mysqld execution script and do a security check. This file restricts root startup

ExecStart=/usr/bin/mysqld_safe --basedir=/usr Add the parameter --user=root here

The following is omitted. . .

#systemctl demon-reload
#systemctl restart mariadb

PS: The same operation method supports starting MySQL with other users.

BUT The permissions or ownership of the two directories /var/lib/mysql /var/log/mariadb need to be adjusted.

Summarize

The above is the editor's introduction to the way to start mariadb under Linux using the root user. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • MariaDB database installation problems and solutions under Linux (binary version installation)
  • MariaDB 10 automated installation and deployment on Linux servers
  • How to Reset MySQL or MariaDB Root Password in Linux
  • Basic operation tutorial for migrating database from MySQL to MariaDB under Linux
  • Detailed example of installing MariaDB database on Linux

<<:  How to extend Vue Router links in Vue 3

>>:  Vue mobile terminal determines the direction of finger sliding on the screen

Recommend

Linux disk management LVM usage

1. Introduction to LVM When we manage Linux disks...

How to insert a link in html

Each web page has an address, identified by a URL...

CSS3 timeline animation

Achieve results html <h2>CSS3 Timeline</...

MySQL group query optimization method

MySQL handles GROUP BY and DISTINCT queries simil...

Vue implements a shopping cart that can change the shopping quantity

This article shares with you how to use Vue to ch...

VMware installation of Centos8 system tutorial diagram (command line mode)

Table of contents 1. Software and system image 2....

Sample code for generating QR code using js

Some time ago, the project needed to develop the ...

Based on JavaScript ES new features let and const keywords

Table of contents 1. let keyword 1.1 Basic Usage ...

Nodejs plug-in and usage summary

The operating environment of this tutorial: Windo...

WeChat Mini Program Basic Tutorial: Use of Echart

Preface Let’s take a look at the final effect fir...

Centos6.5 glibc upgrade process introduction

Table of contents Scenario Requirements glibc ver...

MySQL database operation and maintenance data recovery method

The previous three articles introduced common bac...

9 Practical CSS Properties Web Front-end Developers Must Know

1. Rounded Corners Today's web designs are con...

Things to note when writing self-closing XHTML tags

The img tag in XHTML should be written like this:...

jQuery plugin to achieve image comparison

This article example shares the specific code of ...