documentation/Examples/Debian/Install MariaDB.md

871 B

About

https://mariadb.org/ — A free and open source alternative to MySQL

Procedure
  1. Run apt install mariadb-server to install MariaDB Server

  2. Run mysql_secure_installation to perform the intial setup

  3. Enter the MariaDB shell via running mysql -u root -p and supplying your password

  4. Run the following query to enable the root user for all hosts:

    grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
    

Congratulations, you can now connect to the local database through other applications, such as Python scripts and Adminer.

Sources

https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-ubuntu-20-04

https://community.flexera.com/t5/Software-Vulnerability-Manager/How-to-grant-root-account-remote-access-to-MariaDB/ta-p/4967