archive | databases RSS feed for this section

Importing or Exporting comma-separated (CSV) and other text-based files to / from MySQL databases

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.

Read more

List of cPanel / WHM Inbound and Outbound Ports

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.

Read more

Funny easter eggs built into Wolfram|Alpha

Wolfram|Alpha is the computational knowledge engine developed by Dr. Stephen Wolfram; its developers added several easter eggs to the public release.

Read more

Enabling remote access to a MySQL Database Server

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

Read more

Exporting your iPhone’s SMS Message Database to a CSV file

SMS messages on the iPhone are stored in a SQLite database, and if you need to back up your messages you can do so using one of these methods.

Read more

Displaying MySQL CLI query output vertically

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

Read more

Changing the default MySQL root (or other user) password

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

Read more
Afrigator