Tag Archives: Mysql

Can’t connect to local MySQL server through socket…error.

April 21, 2007 by aaron
I recently moved my /home folder to its own partition, but in doing so, I broke MySQL. The full error I got was: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) To fix this you need to create the file and make sure that MySQL has access to it. (All commands need to be run as root) Create the directory (if it doesn’t already exist). sudo mkdir /var/run/mysqld/ Create the file by “touching” it.
Read More ⟶

Mysql Search and Replace.

April 31, 2007 by aaron
I’ve been getting ready for WordPress 2.3, so in preparation I’ve started cleaning up my database. My first order of business was to clean up the tags database. Over time I’ve used several different methods of separating words: all spaces, hyphens and underscores have all been used which really makes the nice names ugly. Fixing this was easy, I just used the MYSQL replace command: UPDATE table SET field =
Read More ⟶

Can’t connect to local MySQL server through socket…error.

April 21, 2007 by aaron
I recently moved my /home folder to its own partition, but in doing so, I broke MySQL. The full error I got was: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) To fix this you need to create the file and make sure that MySQL has access to it. (All commands need to be run as root) Create the directory (if it doesn’t already exist). sudo mkdir /var/run/mysqld/ Create the file by “touching” it.
Read More ⟶

Mysql Search and Replace.

April 31, 2007 by aaron
I’ve been getting ready for WordPress 2.3, so in preparation I’ve started cleaning up my database. My first order of business was to clean up the tags database. Over time I’ve used several different methods of separating words: all spaces, hyphens and underscores have all been used which really makes the nice names ugly. Fixing this was easy, I just used the MYSQL replace command: UPDATE table SET field =
Read More ⟶