<center>OWNCLOUD - CREATING A DATABASE</center>
===============================

<center>![enter image description here](http://i.imgur.com/OkixDyk.png)</center>

We want to create our database for our **ownCloud** storage set-up. We have to create a username and a password and then put in our database credentials, to create our database for our **ownCloud** and on our own server. 

You want to go into your cPanel and go to your **MySQL Database Wizard**. Here is where you will want to create your **database**. 

<center>CREATING YOUR OWNCLOUD DATABASE - STEP BY STEP</center>
-------------------------------

<center>![enter image description here](http://i.imgur.com/9b3XAN4.png)</center>


The best thing to do is to make sure that you put all of the credentials that you used on it to a notepad for you to remember exactly what your credentials are.

What I have done is I have already created my credentials, and I have put them in a notepad. 

<center>![enter image description here](http://i.imgur.com/ao2cNb3.png)</center>

Of course, you will want to make sure that you recall all of your credentials so that you can use them again later. 

What I'll do is I'll copy and paste all of my credentials for use to create the new database. 

Of course, I will blur out all of the information. 

Now Step 1: Create A Database

<center>![enter image description here](http://i.imgur.com/hedXrWt.png)</center>

Put in a name for your Database...

<center>![enter image description here](http://i.imgur.com/5jI6C9N.png)</center>

Now, you want to put in the user, the username, the password, put the password in again...

<center>![enter image description here](http://i.imgur.com/XAKePCQ.png)</center>

Now Create The User...

<center>![enter image description here](http://i.imgur.com/WltZdTz.png)</center>

You want to give “all privileges” to the user and click next step. 

<center>![enter image description here](http://i.imgur.com/QdgaRQW.png)</center>

It's will say that the website user was added to the database.

<center>![enter image description here](http://i.imgur.com/aEbzS1P.png)</center>

You want to make sure that you again copy all of your credentials here. The user and the database, and make sure that you will know what that is. 

You will want to return to your database...

<center>![enter image description here](http://i.imgur.com/LaNHuI7.png) </center>

...and add the user you created to database you created.  As you can see here as I scroll down, it allows us to add the user to the database.  We want to find the user that we just created, and we want to add that user to the database we just created and click the Add button. 

<center>![enter image description here](http://i.imgur.com/MiitTq7.png)</center>


Make sure that all privileges again is checked and click “make changes”. 

<center>![enter image description here](http://i.imgur.com/MbdBYdj.png)</center>

<center>![enter image description here](http://i.imgur.com/TDPx2gr.png)</center>

You have given the requested privileges on the database to the user, so we're good to go.

<center>![enter image description here](http://i.imgur.com/9t2sd9N.png)</center>

That's how you add your user to your database. 

In Part 3 of this series, we'll go ahead and put our new credentials for our database into our **ownCloud** in our new installation to create an admin account.

By the way, here are all of the lessons in the Drop The Box. Own The Cloud Series...

 - [Intro - ownCloud Installation](https://steemit.com/cloud/@sms/hello-all-drop-the-box-own-the-cloud-part-1) 
 - ownCoud Creating A Database
 - ownCoud Creating An Admin Account
 - Other ownCloud Installation Options
 - The ownCoud Community
 - ownCoud Amazon S3 Integration
 - ownCoud FTP Integration
 - ownCoud Google Drive Integration
 - ownCoud Dropbox Integration
 - Installing The ownCoud Desktop Application
 - The ownCloud Apps Section
 - ownCloud App Updates
 - Why your business needs its own cloud

All of these topics will be taught step-by-step so you can have your own cloud storage up and moving. See you in Part 3!