Geek Love


I went to install a copy of MovableType 2.21 tonight. I’ve been reading the instructions, and I was all ready to do it. Until it came time to set up the MySQL database. Uh, help? Anyone? Our server uses Cpanel, but beyond that I don’t have a clue about how to set up the MySQL database. So if you have any suggestions I would love to hear them! I was working on a fresh new site for someone else, so there aren’t any files to get in my way. After I tackle that one, the upgrade to my sites is coming. After I back up all the sites. First I need some MySQL tips! Anyone? Bueller? Bueller?

By Christine

Christine is an Avenger of Sexiness. Her Superpower is helping Hot Mamas grow their Confidence by rediscovering their Beauty. She lives in the Heights in Houston, Texas, works as a boudoir photographer, and writes about running a Business of Awesome. In her spare time, she loves to knit, especially when she travels. She & her husband Mike have a food blog at Spoon & Knife.

14 replies on “Help.”

I just setup MT 2.21 yesterday using a MySQL database. I can walk you through the process, but I’m actually unfamiliar with CPanel. I’ve seen a few demos and I think they give you a view of your users and databases, and offer administration through PHPMyAdmin. If that’s the case, it should be relatively simple.

If you want to email me to give me a better sense of what CPanel offers, feel free and I can help ya out! In the meantime, I’ll see if I can find a CPanel demo somewhere out there to see if I can figure out how they manage MySQL.

I think when (my) Mike set ours up a while back (for his stuff, not mine) that he didn’t actually do it himself through the CPanel. HostingMatters had to do it for him and then you can manage it through the control panel. I think. I’m not on my machine with CPanel bookmarked (did I mention the PIECE OF DOOKIE died on me?) so I’ll have to ask him when he wakes up in a few hours.

Though, hopefully, you’ve already gotten help by now.

In Cpanel, go to “Manage MySQL”

You’ll see Db: and then a text box and then Add Db button. Type in the name of the database you want.

Your database name should then be user_databasename so if your user name is blahblah, your database name would be something like blahblah_databasename

Your username/password should be the same as your FTP/cpanel username/password, although you can setup another one if you’d like under Users. After adding a user, you need to Add User to Db. Keep in mind the username is going to be similar to the above blahblah_username if you create a user, it should be your plain ftp/cpanel username if you don’t create a user.

Your hostname should be localhost.

I can’t offer any real advice, but I can reassure you that I set up the mySQL stuff on a blogomania site with zero problem. Very easy. The instructions were just a little fuzzy, if I recall.

Jason, I don’t know *jack* about MySQL. I was told by several people though that for the latest MT, I didn’t need to know anything – just set it up and then you don’t touch it again. So I figured I would be ok. HA! Not.

Lynda’s instructions look just like what I was needing last night, so I’ll try it at lunch today. Hopefully that’s it and I’ll be all set… Yeah!

Thanks to EVERYONE for your tips! And if you have any other ideas, let me know!

I’ve got a few things that use mySQL on my suite but I have not used it for my Blog. I upgraded and like the trackback, but I didn’t see the advantage of it versus all the trouble it would take to set it up for MT.

If it ain’t broke, I don’t fix it. And even if it is broke, I usually won’t fix it then either.

Let us know how it goes.

See — that’s exactly why I was leaving it to you. Even reading all of the directions above, it’s still Greek to me. Me senses a tutorial in the works when you finish up…

Would it help everybody if I posted the very detailed instructions that I gave Christine to do this? Its complete with examples of how a normal CPanel should do things. I can do that when I get home and have the email in front of me 🙂

And Promo – I’ve noticed that my rebuilding goes faster with the MySQL version – so that might be enough of a reason for you to change over. 🙂

Woo, thank you Kristine! I’m glad the instructions made it over to ScriptyGoddess.

When I first upgraded to 2.2 and saw the new MySQL capability, I asked some friends about it. They said if I didn’t know what I was missing by not using MySQL, it was probably better to stick with the Berkeley DB. I took their word for it, but does anybody know what the reasons are for using MySQL on an MT blog? I figure they wouldn’t have made it available if it weren’t a helpful feature, but I’m not sure what it’s helpful for.

I’m with Meredith. I, in my ignorant glory, have no idea what the advantages of a MySQL db would be. Other than the faster rebuilding that Kristine with a k mentioned, but my site rebuilds fast enough for me, so I need a better reason. Can I use it to telepathically post my entries? Now that’s a good reason! (Kidding.)

Hi guys’ great tips!!i’m new to database’s but also trying to setup some basic things in phpmyadmin so if anybody got any ideas where a newby can start pl let me know.Ive created one in cpanel and all but need to now get data entry and retrieving purpose….pl help!!

Comments are closed.