Archive

Posts Tagged ‘mysql’

Optimize MySQL for speed and memory use

October 11th, 2009 Jacken No comments
Jamison Judd

Jamison Judd

I found this great shell script to test your MySQL server. You need to have your MySQL server up and running a while before running the test to get valid data. With all the possible setting variations this is can be a handy tool.

Get MySQL Performance tuner here.

MAMP WordPress and Error establishing a database connection

March 20th, 2009 Jacken 4 comments

I?ve installed MAMP on my Mac to do some changes to my blog. I tried to set the WordPress wp-config.php file to connect to localhost:8889, but got an error that It could not connect to the database. After replacing localhost:8889 to 127.0.0.1:8889 it works. My quick guess is that permissions for the root user is set to allow connections 127.0.0.1, but not localhost. Anyway, it works now.

My wp-config.php file looks like this:

define('DB_NAME', 'wordpress');
/** MySQL database username */

define('DB_USER', 'root');

/** MySQL database password */

define('DB_PASSWORD', 'root');

/** MySQL hostname */

define('DB_HOST', '127.0.0.1:8889');