If you need to import data from CSV or other text-based files to a MySQL database or vice-versa, you can use the LOAD DATA or SELECT INTO OUTFILE statements explained in this post.

This post lists Inbound and Outbound Ports used by the cPanel and WHM software that should be opened if you’re running WHM behind a firewall.

By default, remote access to the MySQL database service is disabled. If you need to enable remote access, you can follow these steps.

The MySQL CLI is a great tool to test queries, but output containing many columns usually breaks onto new lines, rendering the results unreadable.

In new MySQL installations, the default root password is set to ” (nothing), which poses a huge security risk on production servers.