OWNCLOUD - CREATING A DATABASE

enter image description here

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.

CREATING YOUR OWNCLOUD DATABASE - STEP BY STEP

enter image description here

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.

enter image description here

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

enter image description here

Put in a name for your Database...

enter image description here

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

enter image description here

Now Create The User...

enter image description here

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

enter image description here

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

enter image description here

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...

enter image description here

...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.

enter image description here

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

enter image description here

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

enter image description here

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
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!

Drop The Box. Own The Cloud - Part 2 [Creating A Database]

OWNCLOUD - CREATING A DATABASE

CREATING YOUR OWNCLOUD DATABASE - STEP BY STEP