09.01.06
more than one-click
One click-install/upgrade on dreamhost is a pretty nice feature, but from time to time, it might take a little more than one-click.
For example, if you use one-click upgrading MediaWiki 1.6.x to 1.7.x, you’ll see problems if you don’t run MediaWiki config again. And if you use the one-click install to install WordPress, it doesn’t work well with utf-8. Here’s a mini how-to to let you install wordpress and use utf-8 properly on dreamhost.
- Go to Goodies-> One-Click Installs under Dreamhost Control Panel, choose WordPress. Fill-in all necessary information(url, database name, host, username, password) then click “Install it for me now” button (picture1).
- Don’t rush to your blog url yet, go Goodies-> Manage MySQL first (you might see the new db doesn’t have a host name, but don’t add host or there might be unexpected errors. Just wait ten minutes, sometimes longer, and check again, wait until the host name you set comes up), then click phpmyadmin. (picutre2)
When it prompts, input the database username/password you just set, entering phpmyadmin interface, select you db (picture3), and choose operation in the right frame. I wonder why dreamhost prefer Swedish, but anyway, we need to set collation to utf_general_ci. (picture4). - Finally, edit /wp-includes/wp-db.php. Insert
mysql_query("SET NAMES 'UTF8'");before$this->select($dbname);(line #56 in 2.0.4), then it’s done. Now you can goto your blog url and finish install. And don’t forget to fix wp-db.php again when you upgrade your wordpress.
And now you can use utf-8 correctly on you blog.
Additional Information: If you install your blog before setting the collation, you can still fix the problem, but you’ll need to set collation to utf-8 in each table, since the tables are already created with Swedish collation.
