Setting up your MySQL database and user

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 - WordPress Ecommerce Shopping Cart Plugin

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

Featured Plugin - WordPress Appointments Plugin

Take, set and manage appointments and client bookings without having to leave WordPress. Appointments+ makes it easy.
Find out more

Featured Plugin - WordPress Google Maps Plugin

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 - WordPress Q&A Site Plugin

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 - WordPress Wiki Plugin

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 - WordPress Newsletter Plugin

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

Featured Plugin - WordPress Infinite SEO Plugin

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 Facebook Plugin

Would you like to add Facebook comments, registration, 'Like' buttons and autoposting to your WP site? Well, The Ultimate Facebook plugin has got that all covered!
Find out more

Featured Plugin - WordPress Membership Site Plugin

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

Participate