setting up MySQL database
Because there is the new option of using MySQL to store your Movable Type database, I wrote up a short tutorial for how to get MySQL ready for the conversion. This is particularly for people who are using CPanel (I’m using version 4) as their control panel on their server.
Get into your CPanel. (usually by going to http://yourdomain.com/cpanel)
Click Manage MySQL (from Databases box at the bottom of the screen) Scroll down to where it says
Db: _____________ [add]
I entered “mt” (without the quotes). This created me a database called love_mt - yours will add your username onto the front of mt.
Click Add.
Now scroll down to where it says Users.
I entered “kristine” and a password. This created me a user called love_kristine.
Click Add User.
Now scroll back up to where it has two drop down boxes with a button that says [Add User to Db]
Drop down the select boxes to select your database and username - mine shows love_mt and love_kristine.
Click Add User to Db.
Now your MySQL database is set up and ready to use for MT.
You should download your mt.cfg from your mt directory (see step 9 of upgrading instructions) and here’s what my additional lines look like:
ObjectDriver DBI::mysql
Database love_mt
DBUser love_kristine
You’ll also edit the mt-db-pass.cgi file and put ONLY your password in it - you don’t need the words database_password in the file. (I did that wrong the first few times in the beta and couldn’t figure out why it didn’t work 
)
July 23rd, 2002 at 7:59 pm
Since :christine: asked so nicely, I wrote up a tutorial on setting up the MySQL database to use MySQL for
July 24th, 2002 at 11:42 am
Thanks, Kristine! It was easy to do, with your instructions.
July 24th, 2002 at 6:52 pm
Hi Kristine! I get a message saying “No tables found in database.” Do you have any idea what that is about?
July 25th, 2002 at 1:36 pm
Thanks! I just had to do this last week, and was hoping I did it right. Wish I’d seen this then! At least I did manage to get without any help, but with lots of confusion.
July 26th, 2002 at 9:29 am
If you’re upgrading to MT 2.2 and going with the MySQL conversion option (which I think you should, just on
July 26th, 2002 at 3:55 pm
Nice! Worked for me thanks ladies.
July 27th, 2002 at 5:24 pm
I finished the upgrade indoors, it was a little too dark out there to follow upgrade instructions. After I came
July 30th, 2002 at 4:16 am
“Done copying data from Berkeley DB to MySQL! All went well.” Easy-pleasey thanks to your directions. THANK YOU!
July 30th, 2002 at 10:57 am
This might just be thr prompting I need to get off my bottom and switch to using MySQL!
July 30th, 2002 at 1:26 pm
*laughs* Love Kristine! That’s a good one!
August 1st, 2002 at 11:21 pm
Thanks so much! Exactly perfectly what I needed.
August 13th, 2002 at 4:39 pm
Tchaa. I spent *ages* wondering how to get this going (my web hosters have a 7 day question/response cycle time, which doesn’t make for very dynamic support conversations).
Fixed in a finger click - thanks!
August 16th, 2002 at 3:03 pm
Does anyone know the set-up using Dreamhost’s interface? This is, of course, a pre-question, as I’m attempting to work through what I have to enable MySql. Wish me luck!
August 16th, 2002 at 3:27 pm
I looked up dreamhosts’ site and found that they probably aren’t using cpanel like my host is. But I did find this: How do I add users to my database? and How do I add a new MySQL database? . I don’t see where you add a user to a database , but I bet if you do these things, the option is in the same place.
Wishing you luck!!!
August 24th, 2002 at 6:36 pm
I reinstalled a fresh copy of Movabletype this afternoon, and decided to try using the mySQL way of doing it
September 13th, 2002 at 7:45 pm
does anyone know how phpwebhosting.com works :o)
October 15th, 2002 at 11:21 pm
I did it - I moved to MySQL - it was pretty painless. Now, does this mean I can delete
August 4th, 2003 at 5:03 pm
A link to this article needs to be in the resources for the MT support forum. So many people have problems setting up MT because they miss the simple step of adding the new user to the db. Of course if this was noted more clearly in the CPanel, no one would have any problems using mySQL period.
August 30th, 2003 at 7:48 pm
hey kristine, so apparently i’m not using the cpanel because when i type in “mydomain.com/cpanel” i get a 404 file not found error from my server.
everything seems to be setting up fine for my MT except for the database…..
i’m installing on my own server via mac osx server software, but the database bit is kicking my butt right now, and since i dont use the cpanel (apparently), i’ll guess i’ll keep searching for the solution somewhere on the web….
September 12th, 2003 at 8:33 am
So I follow your instructions.. uploaded the 2 edited files…is that it.. do I need to run anything.. or does it just start using MySQL now?
How can I tell if it works?
I just pasted my 3 lines of MySQL script into the top of mt.cfg.. is this right
any advice appreciated.. thx
September 26th, 2003 at 12:18 pm
WOW. I can’t thank you enough for this! It solved my problem, and was super easy to follow and execute! THANKS!!
October 1st, 2003 at 10:54 am
Does anyone know where Dreamhost went? I can’t log-ina nd their site isn’t working!
Or do I just need ALOT more coffee?
October 1st, 2003 at 12:17 pm
I got this email from them today:
Attention all DreamHost customers,
Happy Birthday To Us! Due to a problem renewing our dreamhost.com domain
registration, it lapsed today.
This means that until the root DNS servers update showing dreamhost.com as
being renewed, all dreamhost.com subdomains will be down.
We have already put up a working copy of the Web Panel at
https://panel.dreamhost.net
We also have a working email box for support. This is support@dreamhost.net
Because DNS is a decentralized system, these problems will sporadically affect
all of you, but sometimes in different ways.
ALL CUSTOMER WEBSITES THAT ARE NOT SUBDOMAINS OF DREAMHOST.COM ARE
UNAFFECTED.
When trying to access your server using Telnet, FTP, or SSH, be sure you use
yourdomain.com, NOT server.dreamhost.com (as it won’t work).
For a brief period of time this evening, mail was bouncing for some people.
This has been fixed (the MX records have been changed to use dreamhost.net).
The root servers next update tomorrow at noon (eastern time). DNS servers often
cache information, so it may take up to one day for some service providers to see our
domain again.
Complicating matters is Verisign’s recent decision to automatically resolve any
non-existent (or expired) domains to an IP they control. This is why mail was
bouncing (instead of deferring), and is why for some people dreamhost.com (and it’s subdomains) may seem to resolve to Verisign. As soon as dreamhost.com’s all sorted out tomorrow at noon this will stop.
We will keep you updated as the situation progresses, and rest assured we are
all drinking plenty of coffee.
Again these are up and working!:
https://panel.dreamhost.net
support@dreamhost.net
Happy DreamHost “Dude, Where’s My Domain?” Team!
October 1st, 2003 at 12:26 pm
THANKS! I haven’t gotten that yet!!!
November 6th, 2003 at 6:48 pm
No, did not work!
Loading initial data into system…
An error occurred while loading data:
Connection error: Access denied for user: ‘myname@localhost’ (Using password: YES)
January 23rd, 2004 at 11:21 am
Hi.. Your instructions are EXTREMELY helpful! THANKS! However.. CPanel doesn’t hold record of my database(s) correctly.. Any ideas?
May 23rd, 2004 at 12:58 am
Instead of going around and stabbing at databases in the dark, as I’ve been known to do, I figured it’s best to just read the instructions. Here’s a link for…