Jin
08-07-2005, 09:50 AM
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.
http://img.photobucket.com/albums/v452/JINdustries/mysql1.png
Click on "MySql Databases" and you should see this screen,
http://img.photobucket.com/albums/v452/JINdustries/MYSQL2.png
of course you wont see the databases that are already there as they are mine xD
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,
http://img.photobucket.com/albums/v452/JINdustries/MYSQL3.png
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,
http://img.photobucket.com/albums/v452/JINdustries/MYSQL4.png
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.
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.
http://img.photobucket.com/albums/v452/JINdustries/mysql1.png
Click on "MySql Databases" and you should see this screen,
http://img.photobucket.com/albums/v452/JINdustries/MYSQL2.png
of course you wont see the databases that are already there as they are mine xD
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,
http://img.photobucket.com/albums/v452/JINdustries/MYSQL3.png
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,
http://img.photobucket.com/albums/v452/JINdustries/MYSQL4.png
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.