SUBSCRIBER QUESTIONS PART 2
———————————-
Question: How do you set up a database in mysql?
Tony
——————————————
ANSWER:
In order to create a database in MySQL, you need to login into your CPanel. Usually, this is the URL of your domain and then a :2082. So the full URL to your CPanel would be www.yourdomain.com:2082/ and then you need to enter the access details for your CPanel. In most cases, these are the same details you would be using to access your domain via FTP.
Step1:
After logging in, you are on the overview page where you find can links to dozens of items. You just need to locate the one which says “MySQL Databases”. Click on the link. You will now see an overview about the databases which already have been created. In your case, there will be nothing, yet.
In order to create your first database, you give your new database a name. This name should be related to the script you want to install. e.g. if you want to install AdSpyPro on your server and you want to create the database for it, call the database e.g. adspypro. So you enter this where it says “New database” and then you click the “Create database” button. Voila, your first database has been created…
Step2:
But in order to make it work for most scripts, you also need to add a username and give this user a password. This is done, where it says: “Current users” and then you can see the fields “username” and “password”. Just enter the details which you want to use there and click on “create user”.
Step 3:
Add the user to the database. In the section “Add users to database”, you choose the username which you”ve just created from the dropdown menu. The same goes for the database which has a dropdown menu next to the username. You need to make sure that the checkbox “All privileges” is checked and then you just need to click on the button “Add user to database”. That”s it.
When entering the details into some kind of config file for the script you want to install, it wants to have the username and database usually in a different form. It will add the ftp username in front of it. So this becomes yourdomai_username and yourdomai_database when entering the details into the file which connects to the database (usually a file called install.php, config.php or something similar). You will find this in the installation instructions for the software you want to install.
Leave a Reply