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. Problem Description Today I need to check the ...
I am writing a small program recently. Because th...
I recently bought a Tencent Cloud server and buil...
1. Introduction Elasticsearch is very popular now...
IP masquerading and port forwarding Firewalld sup...
Linux server hosts file configuration The hosts f...
Table of contents nonsense Functions implemented ...
By default, the MyISAM table will generate three ...
Table of contents Preface 1. The significance of ...
Introduction Recently I found that there is an AR...
1. Parent components can use props to pass data t...
How to reset the initial value of the auto-increm...
After the previous two chapters, do you have a ne...
The editor also shares with you the corresponding...
A distinct Meaning: distinct is used to query the...