How to create a MySql database

I am going to show you how to create a MySQL Database. I am going to use C panel, open up, put up a root domain manager you use in this case, so I am using C panel, but yours maybe different if you have a different provider than my lunar pages.

This is the MySQL account, click on it to open. Then you type the name of your database and use test DB, click create, and then go back where you were. Now we have created our database, we are going to add a new user to it, and I am going to use the name Bob to it and Bob is going to get a password, now of course I will just do this for you, erase that for we create this. So for my security and create user and go back.

Then you have to add, see the database over here is my test database with my username in front of it. I am going to add Bob to it. I am going to give it all the privileges, so the way these are created this is your username goes in front of underline, and then the name of your database, is the username, underline and the user. I am going to add the database, go back and I am done.

The database that I used with things like blogs, the word press blog is the one that I use and the first thing you have to do when you get that loaded up is to re-configure the wpconfig.php file. Three things you have to change on here, is the username, database name and the password and the very first one here is the DB name and the syntax is username, underline, and the name of your database. In this case, username_testDB, and the syntax is the same for the user. Username_Bob, and then the password is just the password itself. You save this to your server, and then you can install your word press blog.


Transcription by: Scribe4you Transcription Services