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!