scriptygoddess

23 Jul, 2002

setting up MySQL database

Posted by: kristine In: How to's

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 :) )

27 Responses to "setting up MySQL database"

1 | Ashley

July 24th, 2002 at 11:42 am

Avatar

Thanks, Kristine! It was easy to do, with your instructions.

2 | Maggie

July 24th, 2002 at 6:52 pm

Avatar

Hi Kristine! I get a message saying "No tables found in database." Do you have any idea what that is about?

3 | Katie

July 25th, 2002 at 1:36 pm

Avatar

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.

4 | Jessy

July 26th, 2002 at 3:55 pm

Avatar

Nice! Worked for me thanks ladies.

5 | robyn

July 30th, 2002 at 4:16 am

Avatar

"Done copying data from Berkeley DB to MySQL! All went well." Easy-pleasey thanks to your directions. THANK YOU!

6 | Shelagh

July 30th, 2002 at 10:57 am

Avatar

This might just be thr prompting I need to get off my bottom and switch to using MySQL! :)

7 | Electrin

July 30th, 2002 at 1:26 pm

Avatar

*laughs* Love Kristine! That's a good one! :)

8 | Martha

August 1st, 2002 at 11:21 pm

Avatar

Thanks so much! Exactly perfectly what I needed. :)

9 | Rich

August 13th, 2002 at 4:39 pm

Avatar

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!

10 | Mariann

August 16th, 2002 at 3:03 pm

Avatar

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! :)

11 | kristine

August 16th, 2002 at 3:27 pm

Avatar

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!!! :)

12 | Maggie

September 13th, 2002 at 7:45 pm

Avatar

does anyone know how phpwebhosting.com works :o)

13 | Rayne

August 4th, 2003 at 5:03 pm

Avatar

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.

14 | jessica

August 30th, 2003 at 7:48 pm

Avatar

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….

15 | sam

September 12th, 2003 at 8:33 am

Avatar

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

16 | Anonymous

September 26th, 2003 at 12:18 pm

Avatar

WOW. I can't thank you enough for this! It solved my problem, and was super easy to follow and execute! THANKS!! 😀

17 | Dianne

October 1st, 2003 at 10:54 am

Avatar

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?

18 | Michael Froomkin

October 1st, 2003 at 12:17 pm

Avatar

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!

19 | Di

October 1st, 2003 at 12:26 pm

Avatar

THANKS! I haven't gotten that yet!!!

20 | Anonymous

November 6th, 2003 at 6:48 pm

Avatar

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)

21 | Patrick

January 23rd, 2004 at 11:21 am

Avatar

Hi.. Your instructions are EXTREMELY helpful! THANKS! However.. CPanel doesn't hold record of my database(s) correctly.. Any ideas?

22 | kadyellebee

July 23rd, 2002 at 7:59 pm

Avatar

setting up MySQL database
Since :christine: asked so nicely, I wrote up a tutorial on setting up the MySQL database to use MySQL for

23 | ***Dave Does the Blog

July 26th, 2002 at 9:29 am

Avatar

MT and MySQL
If you're upgrading to MT 2.2 and going with the MySQL conversion option (which I think you should, just on

24 | Blah Blah Blog

July 27th, 2002 at 5:24 pm

Avatar

Now That Wasn't So Bad…
I finished the upgrade indoors, it was a little too dark out there to follow upgrade instructions. After I came

25 | Red Hair and Freckles

August 24th, 2002 at 6:36 pm

Avatar

mySQL
I reinstalled a fresh copy of Movabletype this afternoon, and decided to try using the mySQL way of doing it

26 | A Trip Inside Zaldor's World

October 15th, 2002 at 11:21 pm

Avatar

Pretty Painless!
I did it – I moved to MySQL – it was pretty painless. Now, does this mean I can delete

27 | Disarranging Mine

May 23rd, 2004 at 12:58 am

Avatar

mySQL setup
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…

Featured Sponsors

Genesis Framework for WordPress

Advertise Here


  • Scott: Just moved changed the site URL as WP's installed in a subfolder. Cookie clearance worked for me. Thanks!
  • Stephen Lareau: Hi great blog thanks. Just thought I would add that it helps to put target = like this:1-800-555-1212 and
  • Cord Blomquist: Jennifer, you may want to check out tp2wp.com, a new service my company just launched that converts TypePad and Movable Type export files into WordPre

About


Advertisements