But don’t worry. It is easy to set it up.
The quickest and easiest way to set up your database is to let your host do it for you. Not all web hosts have this option, which is another reason to use Omnis.com. Since I use Omnis, I am going to show how to do it with them, but whoever your host is, the process will be similar.
Once you have purchased your domain and hosting plan, login to your Control Panel. It will look something like this:
There are two ways to install MySQL. The quick way, and the best way.
The Quick Way to Install MySQL
The quickest and easiest way to install MySQL on your host and WordPress at the same time, is to use their “Install Popular Scripts” option.
After you click on it, click “Install Packages” for the domain on which you want to install MySQL and WordPress. In my case, it will be GraceBlogger.com:
Click “Install” on the WordPress package, and in just a few short seconds, it installs your SQL Database and WordPress, and you are ready to go!
The Best Way to Install MySQL
Not all hosts have the option to install MySQL and WordPress with a script. Even if they do, you may not want to use it. Why? Because by doing it yourself, you can set up some extra security precautions, name your database, and choose your own password. I prefer to do all these things, and since not all hosts have the easy install scripts, let me show you the longer and more detailed route on setting up your MySQL database, and installing WordPress.
We will set up the database in the rest of this post, and then install WordPress in the next post.
First, from your control panel homepage, select the MySQL Manager.
From within the Manager, you will want to create a new database.
Give your database a name, and make sure you have full editing rights. Click “Finish” and your database will be created.
It will give you the user name and password so you can login to the database. You will not need to login in right now, but print this page off, or copy this information somewhere, because you will need this information for your WordPress installation.
That’s all there is to it! Easy, right?
You have successfully installed a MySQL database on your website.
In the next post, we will look at installing WordPress and connecting it your database. Don’t worry, it is even easier than setting up the database!