How to make a MYSQL Database

[Jin]

This is a quick additional guide to making a MYSQL database for my Vbulletin Guide in "Forum Design".

There are many ways to make a MYSQL database, including using Command Prompt, but the easiest way is to use Cpanel, which is a common control panel for your entire web hosting.

First I suggest you log into your Cpanel,

what most people dont realise is that you dont need to go to your Webhosts site to log into Cpanel, just simply visit yourdomain.com/cpanel/ EG. "www.example.com/cpanel/"

Log in first of all,

You should be displayed with a screen very similar to this, some features may vary depending upon your web host.



Click on "MySql Databases" and you should see this screen,



of course you wont see the databases that are already there as they are mine

Now you must add a database to do this where it says "Db" enter a name and click "Add database"

Your database now has been made but you need to add a user to it,



To add a user enter a username and a password under the section "Users", don't make the password too complex as you will need to remember this for Vbulletin config files and other things,



Now you have added a user it will be displayed above where you inputted the details and your database will also be at the top, you must now configure the permissions for the account, this is done easily.

Where you added the database name there will be a series of drop down menu's and check box's the permissions will differ depending on what you are doing but most commonly it is set to "All".

In the first drop down menu select the user you will add to the database, in this case it is "_test" then in the second drop down menu select the database this menu will be added to, I made a database called "_Test"

Now select the check box called "All" and then click "Add user to Db"

It will be now done, if you have made this database for Vbulletin, these details are the "Database title", "database username" and Database Password" in the config.php file


Please refrain from asking me why I have edited out certain parts of the screenies such as URL's, it is because the verbal content of my site is not somewhat acceptable on Habboxforum or Habbohotel or due to the large number of users and database details I have removed some so not to confuse you.

[Rix]

Not hard to do but if you don't have cpanel it can be hell

[Jin]

Not hard to do but if you don't have cpanel it can be hell

eugh the CMD method is just annoying and stupid

[splintercell!]

thats good but you could have added the basics of mysql and how to create tables and stuff but well done +rep

[-JT-]

thats good but you could have added the basics of mysql and how to create tables and stuff but well done +rep

something i have no clue about lol

[Tommy]

mysql always makes my head hurt... especially when there is something wrong and its a pain finding out what.

[splintercell!]

The tutorials make it sound confusing but I just learned bits by fidling around and now can do some stuff..

[Tomm]

i dont use cpanel as I have got a server that I have to manage myself so it is hell to make a database useing the MySQL server software via remote control

[ED::]

good post +rep :eusa_clap :eusa_clap

[Rix]

tom it is hard as i used to have a sever and ahh thats was annoying