MySQL

How To Install and Secure phpMyAdmin with Apache on a CentOS 7 Server — step-by-step Linux tutorial on Progressive Robot

How To Install and Secure phpMyAdmin with Apache on a CentOS 7 Server

While many users require access to a database management system like MySQL or MariaDB, not all users feel comfortable interacting with the SQL prompt on a daily basis. In this guide, we’ll discuss how to install and secure phpMyAdmin, a web management interface for MySQL and MariaDB, on a CentOS 7 server. We will leverage the Apache web server for this guide.

Read more
How To Use Mytop to Monitor MySQL Performance — step-by-step Linux tutorial on Progressive Robot

How To Use Mytop to Monitor MySQL Performance

Mytop is an open source, command line tool used for monitoring MySQL performance. It was inspired by the Linux system monitoring tool named top and is similar to it in look and feel. Mytop connects to a MySQL server and summarizes the information in a useful format. Using mytop, we can monitor (in real-time) MySQL threads, queries, and uptime as well as see which user is running queries on which database, which are the slow queries, and more.

Read more
How To Install MySQL on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Install MySQL on Ubuntu 18.04

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. This tutorial will explain how to install MySQL version 5.7 on an Ubuntu 18.04 server.

Read more
CHAT