New year & new blog

The new year is here and I have moved my (so far quite silent) blog to use WordPress and MySQL 5.5 GA.

Since I am using Ubuntu I downloaded a compressed tar archive. I installed it in a custom directory and for starting I wrote a little upstart script.

$ cat /etc/init/mysql-5.5.conf
start on startup
stop on shutdown

env basedir=/opt/mysql/mysql-5.5
env defaults=/etc/mysql-5.5/my.cnf

script
        cd $basedir
        $basedir/bin/mysqld_safe --defaults-file=$defaults
end script

In wp-config.php I have set:

define('DB_HOST', 'localhost:/var/run/mysqld-5.5/mysqld.sock');

This lets me use a non default location for the socket too.

Posts from old blog

This entry was posted in MySQL, MySQL 5.5, Ubuntu, Upstart, Wordpress. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>