Movable Type with MySQL in 10 minutes
Since my first take at Movable Type in 5 minutes I learnt a few things. One of them is, don’t go with the flat file DB stuff (Berkeley). So here’s what to do for an MT installation with DBD::mysql:
- Download it
- Untar and move it to the directory under your server root where you want it to be
- Change mt.cfg
Changes in mt.cfg
- Let CGIPath point to the URL where your blog resides (this is the URL)
- Uncomment the DataSource line, you don’t need it
-
ObjectDriver DBI::mysql Database your_db_name DBUser your_db_user_name
The User should of course exist.
Edit the mt-db-pass.cgi so that it contains the password for your DB user.
You might have to install DBD::mysql. For this, launch perl -MCPAN -e shell (as root). Go through the initialization process (if not already done). Then issue a install DBD::mysql.
If you stumble into the following error message:
ld: cannot find -lz
Just install a package like zlib-devel with your favorite packet manager.
Invoke http://www.your-site.com/mt/mt-load.cgi to initialize.
If successful, delete the init script you just invoked (not deleting it presents a serious security hole).
To log in go to http://www.your-site.com/mt/mt.cgi (initial author name Melody and password Nelson).
Then visit http://www.movabletype.org/docs/mtinstall.html for troubleshooting 