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

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

Why you shouldn’t use SELECT * ( ALL ) in MySQL

Simple Answer: You will never use a index this way. Lets look at the following examples: EXPLAIN SELECT * FROM `wp_posts`; +—-+————-+———-+——+—————+——+———+——+——+——-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows |...

Cover Image by MilesAndryPrower on DeviantArt

MySQL Select Statements

The SELECT statement is used to select or fetch data from a your MySQL Database. It’s the most common type of query issued to a database. There are many ways to query a database, but were going to focus on the SELECT statement itself...

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() ...