We will show you here how you can get the MySQL/MariaDB server started date on a CentOS server. This can be useful for server statistics etc. 1. Use the select now() - interval variable_value second from information_schema.global_status where variable_name='Uptime'; command…
To manage a MySQL/MariaDB database from web you can use the well-known phpMyAdmin script (available from cPanel, from Softaculous etc). But what happens if you want to use a Windows/Linux/Mac program to manage your databases? We will list here some…
cPanel allows you to easily manage your databases and users. Steps to add a new cPanel database: Log in to cPanelLook for MySQL® Databases (DATABASES section)Look for Create New Database section. Enter your desired database name and click the Create Database…
With the cPanel MySQL Database Wizard, you can easily create a database and set up a user for it. How to use the cPanel MySQL Database Wizard: Log in to your cPanel accountGo to MySQL Database Wizard (DATABASES section)Step1. Enter…
phpMyAdmin is a PHP web script that allows you to manage databases.cPanel includes phpMyAdmin. Also, you can install phpMyAdmin from Softaculous. But if for any reason, you can't access it in cPanel or Softaculous, you can just set it up…
The commands from this post will work on MySQL and MariaDB server. It's a good idea to perform database maintenance from time to time. One thing is to do is to optimize the tables. We have two options: 1. OPTIMIZE…
