Mariadb – User called thesql in fresh mariadb install on debian

debianmariadb

I just installed MariaDB 10.4 on Debian 10.
In addition of root, there is a user called mysql.

Can I remove this user ?
What is the purpose of this account ?

Thanks.

Best Answer

MariaDB is a fork of MySQL, and as such it uses the latter name for many important things, including its command line tool mysql, daemon binarymysqld, and the user IDmysql` under whose authority the daemon runs. As mentioned in the comments, most Linux daemons run as their own dedicated user IDs for improved security.

Do not delete the user mysql.

Related Solutions

MySql/MariaDB cannot change default datadir on Debian 9.1 server

You must set ProtectHome=false in the systemd config file in order to move your datadir to the /home directory.

According to Debian policy rules, you should set this option value in a custom file like /etc/systemd/system/mariadb.service.d/YOUR_CUSTOM_FILE.conf containing:

[Service]

# Prevent accessing /home, /root and /run/user
ProtectHome=false

Then reload systemctl daemon:

systemctl daemon-reload

After that you should be able to change MariaDB datadir from /var/lib/mysql to /home/mysql.

Mysql – How to log into a fresh MariaDB install

Turned out I had to run mysql_install_db before I was able to do anything - although when trying to log in before that everything seemed to work...

Best Answer

Related Solutions

MySql/MariaDB cannot change default datadir on Debian 9.1 server

Mysql – How to log into a fresh MariaDB install

Related Question