MySQL

MySQL is an open-source relational database management system. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data.

It’s free and open-source software under the terms of the GNU License, and is also available under a variety of proprietary licenses.

www.mysql.com

Different Ways to Check MySQL version in cPanel or Linux

By far MySQL is the most popular Relational database management system and knowing which MySQL version you are running can be important in some situations. Here are different ways to check the version of the MySQL server installed on your WHM/...

Cover Image by MilesAndryPrower on DeviantArt

MySQL Database Vulnerability Scanning

Here is how to check MySQL databases for malware: Open up PHPMyAdminLook for anything ‘weird’ It’s that simple. What’s ‘weird’ you ask? Well, anything that’s ‘not supposed to be in the database’. What to look for? Here are some examples of items...

How to change MySQL root Password in CyberPanel

To change MySQL root password in CyberPanel we need to update it’s configuration. CyberPanel stores MySQL root password into two files: /etc/cyberpanel/mysqlPassword/usr/local/CyberCP/CyberCP/settings.py mysqlPassword File contains the MySQL...

Backup MySQL with mysqldump

mysqldump command line tool is without doubt the most well known way to backup a MySQL database or multiple databases.

Cover Image by MilesAndryPrower on DeviantArt

☑ Optimize a MySQL database

If you have deleted a large part of your table or updated many variable length rows, you should consider running the optimize command. If you want to quickly generate the optimize commands for every table in you database, executing the...

SQL to Mongo correspondence table

This list is the PHP version »SQL to Mongo correspondence table (there is a more general version in the official MongoDB manual). SQL queryMongo query statementCREATE TABLE USERS (a Number, b Number)Implicit creation, or MongoDB::createCollection() ...