archive | mysql RSS feed for this section

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

04 Feb 2010 0 Comments

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
databases, mysql, tips & tricks
, , , , , , ,

List of cPanel / WHM Inbound and Outbound Ports

27 Jan 2010 1 Comment

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
apache, cpanel, mysql, tips & tricks, tools, unix, whm
, , , , , , , , , ,

Enabling remote access to a MySQL Database Server

16 Jun 2009 0 Comments

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
databases, mysql, tips & tricks, tools, unix
, , , , , ,

Displaying MySQL CLI query output vertically

11 Apr 2009 0 Comments

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
databases, mysql, tips & tricks, tools
, , , , , , , , , , , , ,

Changing the default MySQL root (or other user) password

16 Feb 2009 0 Comments

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

Read more
databases, mysql, tips & tricks, unix
, , , , , , ,

MySQL 5, PHP 5 and Apache2 configuration on OS X 10.5.* (Leopard)

28 Jan 2009 25 Comments

Apple’s OS X 10.5.* (Leopard) comes with Apache2 and PHP5 preinstalled, but the PHP5 module is disabled by default. This tutorial demonstrates how to enable it and install MySQL, the MySQL Query Tools and phpMyAdmin.

Read more
apache, apple, databases, mysql, php, unix
, , , , , , , , ,

Afrigator