Some website scripts require you to add a mysql database before you can use the script. If you're using cpanel it is very easy to create a mysql user account. Login to your web hosting cpanel account webpage then go down to where it says "Databases" or you can do a search on "MySQL" and it will show up in the result.
For this test i created the new database in a vps hosting account from Virpus Networks.
Now click on the icon that says "MySQL Databases".
Is going to take 5 simple steps to create a new database.
1. Create a new database name.
2. Create a mysql username.
3. Generate a password.
4. Create the user for the database.
5. Add the user to the database.
Create new database...
Now create a new database name that will identify the script you are installing. When you are done click on the "Create Database" button to create the database name.
Now the db name has been added. Copy the db name to a file or write it down on a piece of paper because you're going to need it later for the database information when installing your script.
Now click on the Go Back link to return to the previous screen.
Add new user...
In the username box create a username that will connect to the db. Now click on the generate password button to generate a good password.
If you would like your password with or without Uppercase, Lowercase, Numbers, Symbols check or uncheck the box or boxes you like. If you would like a long password generate or short change the number in the box where it says password length. If you don't like the password that is showing in the box click on the regenerate password to scroll through to a password that you might like. If you're creating your own password make it a good that is very strong by checking the password strength bar in green.
Once you are done selecting your password click the user password botton to add the password to the username.
Now that the user name is created and the password has been generated. Click on the create user button to create the user for the database.
Copy the user name & password to a file or write it down on a piece of paper because you're going to need it later for the database information when installing your script.
Add user to database...
You need to connect the user to the database by selecting the user name and database name from the drop down list. Don't worry about this if you have only one user / one database. If you have more than one user name / database name make sure that you select the correct user name with the correct database name before clicking the add button.
After you know which user name to connect to the database name click the add button to continue.
Now you need to decide what privileges to give to the user to have access to when connecting to the database. Checkmark the boxes of the privileges you want user to have. Some scripts will require to have all privileges because the script will insert, drop, update, delete, create tables in order for the script to work.
Once you are done selecting the privileges to give to the user click on the make changes button to continue.
The user has now been added to the database. Copy the user name & database name to a file or write it down on a piece of paper because you're going to need it later for the database Information when installing your script.
By now you should have db username, db name, db password:
Username: nbserver_dbuser
Database: nbserver_dbtest
Password: {.Y23}M}LBAB -->> Do not use this example password.
Now click on the Go Back link to return to the previous screen.
You are not done creating a mysql database for your script.
