Posts Tagged ‘Mysql’
What to do in MySQL if ‘host_name’ is blocked
Wednesday, November 12th, 2008If you get the following error, it means that mysqld has received many connect requests from the host ' that have been interrupted in the middle:host_name‘
Host 'host_name' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
(more...)
Make Wordpress Load Much Faster
Wednesday, October 29th, 2008If 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.
Recover MySQL Database root password
Sunday, October 26th, 2008By 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.
Install MySQL on FreeBSD via Ports Collection
Monday, September 1st, 2008- Login to the FreeBSD system as root, or su - root to get to super user environment.
- Enter the following commands at FreeBSD command line interface (CLI) (Wait till each command to finish processing before running the next command):
- (more…)
