26 lines
871 B
Markdown
26 lines
871 B
Markdown
###### 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:
|
|
|
|
```mysql title="MariaDB"
|
|
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>
|