MySQL Settings
Database creation and configuration, using MySQL as an example. SQLite and Postgres are no longer supported in the core and will require a plugin for use. Oracle requires the MT Enterprise pack.
Creating a MySQL database
These instructions are for creating a MySQL database via command line on the server. (Your web host may have a GUI for database management. Instructions for using phpMyAdmin to setup a database.)
The following steps require admin access to MySQL on the server.
Log into MySQL
$ mysql -u root -pTo create a database named “mt”:
mysql> create database mt;Warning: As of Movable Type 5, Japanese is only supported with UTF-8. UTF-8 is the default character code for published blogs. To specify “UTF-8” as the character set when creating a database named “mt”:
mysql> create database mt character set utf8;If using Japanese language, the PublishCharset config directive must be set to
UTF-8, otherwise text may appear garbled.Create a database user
Create the user “mtuser” with the password “mtpasswd”:
mysql> grant all on mt.* to mtuser@localhost identified by 'mtpasswd';Creating a Database that uses phpMyAdmin
Database Configuration
Configure the database in the mt-config.cgi file which is found in the MT application directory.
A sample database configuration in mt-config.cgi using the sample values from Creating a MySQL database above. DBHost, DBPort, and DBSocket are advanced configuration options and typically only used in larger installations.
ObjectDriver DBI::mysql
Database mt
DBUser mtuser
DBPassword mtpasswd
# DBHost mysql.sixapart.com # advanced config
# DBPort 6789 # advanced config
# DBSocket /path/to/mysql.sock # advanced config
Read documentation on each database config directive:
