Posts Tagged ‘Mysql’

MySQL Cheatsheet

Thursday, November 13th, 2008

What to do in MySQL if ‘host_name’ is blocked

Wednesday, November 12th, 2008

If you get the following error, it means that mysqld has received many connect requests from the host 'host_name that have been interrupted in the middle:

Host 'host_name' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
(more...)

Make Wordpress Load Much Faster

Wednesday, October 29th, 2008

If you are suddenly receiving a lot of request within a short period of time because you’ve been linked by a large site like Digg or Slashdot, your hosting solution might not be able to handle the load.

This article should help your to prepare your WordPress blog for such a case or if you’re just using a slow webhost and want to improve the general performance.

(more…)

Recover MySQL Database root password

Sunday, October 26th, 2008

By default, MySQL Server will be installed with root superuser without any password. You can connect to MySQL server as root without requiring password or by keying in blank password. However, if you have set the password for root and forget or unable to recall the password, then you will need to reset the root password for MySQL.

(more…)

Install MySQL on FreeBSD via Ports Collection

Monday, September 1st, 2008
  1. Login to the FreeBSD system as root, or su - root to get to super user environment.
  2. Enter the following commands at FreeBSD command line interface (CLI) (Wait till each command to finish processing before running the next command):
  3. (more…)
Pages: 1 2 3 Next