Setting up your MySQL database and user

June 8, 2009  | 
Leave a comment

As taken from The WordPress MU Manual

Image of database

Before you can install WPMU you first need to create a MySQL database and user on your domain using your cPanel.

In simple terms your MySQL database stores all blog information including files, blog posts and comments and is backed-up almost constantly by your hosting company to ensure no data is lost.

1. Log into cPanel using your account details supplied by your hosting company.

NOTE: Appearance of cPanel does vary slightly depending on what theme your hosting company uses.
Image of Cpanel

2. Scroll down to the Database section of cPanel and click on MySQL Databases

Image of MySQL database

3. Create a database by entering the name WPMU and clicking create database

Image of create database

4. Once the database has been created click on the Go Back link.

Note: the name of your database and user are both given the default prefix of your domain name. This is to ensure it has a unique name from other databases when it is stored on your host’s servers.

Image of go back

5. Next create a new user by adding their username and password then click Create User.

Image of creating user

6. Once the user has been created click on the Go Back link

Image of go back user

7. Now add your user to your database by scrolling down to Add User to Database and click on Add.

Image of add user to database

8. On the Manage User Privileges page select All Privileges.

Image of priveleges

See Next: Installing WordPress MU

Featured Plugin - Start Your Own Powerful Membership Site

If you're thinking about starting a paid, or just private, membership site then this is truly the plugin you've been looking for. Easy to use, massively configurable and ready to go out of the box!
Find out more

Featured Plugin - Every great SEO tweak you need, in one snazzy bundle

Fully integrated with the SEOMoz API, complete with automatic links, sitemaps and SEO optimization of your WordPress setup - this is the only plugin you need to help you rank your site number 1 on Google - nothing else compares.
Find out more

Featured Plugin - WordPress + Google Maps = Perfect

Simply insert google maps into posts, sidebars and pages - show directions, streetview, provide image overlays and do it all from a simple button and comprehensive widget.
Find out more

Featured Plugin - Start your own Quora / StackOverflow / Yahoo Q&A site

It's now incredibly easy to start your own Q&A site using nothing more than WordPress - The Q&A plugin simply and brilliantly transforms any site, or page, into a perfect support or Q&A environment.
Find out more

Featured Plugin - Add bottom corner (or anywhere else) chat to your site

No javascript required, no third part chat engine, just fully featured chat right in your own database on your own WP sites - couldn't be easier.
Find out more

Featured Plugin - Host sites, get paid, just like WordPress.com

If you've ever wondered how you could offer a paid site management and hosting service, then this is the plugin for you. Offer a freemium or paid service, for any niche you like, it's powered Edublogs.org to success already!
Find out more

Featured Plugin - Turn any WordPress page into a fully featured wiki!

To get a wiki up and running you used to need to install Mediawiki and toil away for days configuring it... not any more! This plugin gives you *all* the functionality you want from a wiki, in WordPress!!!
Find out more

Featured Plugin - Open an Online Store with MarketPress

Out of all the WordPress ecommerce plugins available, this has got to be the winner - easy to configure, powerful functionality, multiple gateways and more. A simply brilliant plugin!
Find out more

Featured Plugin - Send beautiful html email newsletters, from WordPress!

Now there's no need to pay for a third party service to sign up, manage and send beautiful email newsletters to your subscriber base - this plugin has got the lot.
Find out more
Click on a tab to select how you'd like to leave your comment

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe without commenting