SQL database servers and web interface managers¶
Mariadb SQL database server¶
Mariadb is one of the most popular database servers. Made by the original developers of MySQL.
Command:
| Text Only | |
|---|---|
Author: @armbian
Status: Stable
Database access configuration is done at first install: - create root password - create database - create normal user - create password for normal user
- Database host:
<your.IP>
- Install directory:
/armbian/mariadb - Site configuration directory:
/armbian/mariadb/config
| Bash | |
|---|---|
Mariadb remove¶
Command:
| Text Only | |
|---|---|
Author: @armbian
Status: Stable
Mariadb purge with data folder¶
Command:
| Text Only | |
|---|---|
Author: @armbian
Status: Stable
phpMyAdmin web interface manager¶
Phpmyadmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.
Command:
| Text Only | |
|---|---|
Author: @armbian
Status: Stable
The web interface is accessible via port 8071:
- URL:
https://<your.IP>:8071 - Server: IP from server you are connecting to. If you have installed MariaDB via this tool, then this is
<your.IP> - Username: defined at SQL server install (MariaDb)
- Password: defined at SQL server install (MariaDb)
- Install directory:
/armbian/phpmyadmin - Site configuration directory:
/armbian/phpmyadmin/config
| Bash | |
|---|---|
phpMyAdmin remove¶
Command:
| Text Only | |
|---|---|
Author: @armbian
Status: Stable
phpMyAdmin purge with data folder¶
Command:
| Text Only | |
|---|---|
Author: @armbian
Status: Stable