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: However, this instruction actually calls mariadb.service (use find to find the specific directory) to start mariadb. Modify the mariadb.service configuration as follows: [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. #Execute the mysqld execution script and do a security check. This file restricts root startup 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 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! You may also be interested in:
|
<<: How to extend Vue Router links in Vue 3
>>: Vue mobile terminal determines the direction of finger sliding on the screen
1. Introduction to LVM When we manage Linux disks...
Each web page has an address, identified by a URL...
Achieve results html <h2>CSS3 Timeline</...
MySQL handles GROUP BY and DISTINCT queries simil...
This article shares with you how to use Vue to ch...
Table of contents 1. Software and system image 2....
Some time ago, the project needed to develop the ...
Table of contents 1. let keyword 1.1 Basic Usage ...
The operating environment of this tutorial: Windo...
Preface Let’s take a look at the final effect fir...
Table of contents Scenario Requirements glibc ver...
The previous three articles introduced common bac...
1. Rounded Corners Today's web designs are con...
The img tag in XHTML should be written like this:...
This article example shares the specific code of ...