How to check MariaDB server version

Question: I am on a VPS server where MariaDB server is running. How can I find out which version of MariaDB server it is running? There are circumstances where you need to know the version of your database server, e.g., when upgrading the database or patching any known server vulnerabilities. There are a few ways […]
Continue reading…

 

How to install phpMyAdmin on CentOS

Question: I am running a MySQL/MariaDB server on CentOS, and I would like to manage its databases via web-based interface using phpMyAdmin. What is a proper way to install phpMyAdmin on CentOS? phpMyAdmin is an open-source PHP application designed as a web-based MySQL/MariaDB database administration tool. While there exist lightweight database management tools such as […]
Continue reading…

 

How to back up MySQL or MariaDB databases remotely via ssh

Question: I want to back up a MySQL (MariaDB) database running on a remote server. Is there a way to back up and dump a remote MySQL (MariaDB) database over SSH? mysqldump is a command-line utility for backing up MySQL (MariaDB) databases. In order to back up a remote database, you can send mysqldump command […]
Continue reading…