People who use phpMyAdmin may find using command line difficult as using wrong syntax can lead to anything, while using command line is the most secure and reliable way where phpMyAdmin fails due to scripts limits. First, login to server using SSH like: ssh username@hostname (and use -p flag if using any port). Before we […]
MariaDB is one of the best relational databases and we can use it on Debian Linux to host databases for apps, blogs, and websites. In this article we’ll learn installing MariaDB and securing it on Debian. 1. Refresh the system once. sudo apt update 2. Install MariaDB server. sudo apt install mariadb-server 3. Secure it. […]
Many times you must have been facing the issues that are caused due to a slow running database. In such cases when the database is running slow, several queries will line up, the backlogs will grow at pace and users would be refusing connections. What do most management boards do in such a condition? The […]