I have problems setting up the MySQL database for my application

AA-00346

Setting Up MySQL Database in cPanel

What This Guide Will Help You Do

This guide will walk you through creating a MySQL database for your website or application using cPanel. We'll use simple language and show you exactly where to click. By the end of this guide, you'll have:

  • A new MySQL database created
  • A database user with the right permissions
  • All the connection information your application needs

Before You Start

What You'll Need:

  • Your iFastNet hosting account login details
  • The name you want to give your database (we'll help you choose)
  • About 10-15 minutes of time

Don't Worry If:

  • You've never used cPanel before
  • You don't know much about databases
  • You're feeling overwhelmed - we'll go step by step!

Step 1: Getting Into Your cPanel

You can access your cPanel in two different ways. Choose whichever is easier for you:

Option A: Through Your iFastNet Client Area (Recommended for Beginners)

  1. Open your web browser and go to: https://ifastnet.com/portal/clientarea.php
  2. Log in using the username and password you received when you signed up for hosting
  3. Find your hosting service in the list (it will show your domain name)
  4. Click on your hosting service to open it
  5. Look for a button that says "Login to cPanel" and click it
  6. cPanel will open in a new tab - you're now inside your hosting control panel!

Option B: Direct cPanel Login

  1. Open your web browser and type: https://yourdomain.com/cpanel
    • Replace "yourdomain.com" with your actual website address
    • For example: https://myawesomesite.com/cpanel
  2. Enter your cPanel username and password
    • These might be different from your iFastNet client area login
    • If you don't know them, use Option A above
  3. Click "Log in"

Can't Get In? Get Help!

If you can't access cPanel:

  1. Go to: https://support.ifastnet.com/login.php
  2. First time here? Click "Register" to create a support account
  3. Already registered? Log in with your support account details
  4. Click "Create New Ticket" and explain you can't access cPanel
  5. Include your domain name in the ticket

Step 2: Finding the Database Section

Once you're in cPanel, you'll see lots of icons and options. Don't worry about most of them right now!

  1. Scroll down until you see a section called "Databases"
  2. Look for an icon called "MySQL Databases" - it might have a database or cylinder icon
  3. Click on "MySQL Databases"

Can't Find It? Look for these other possible names:

  • "MySQL Database Wizard"
  • "Database Wizard"
  • "Databases"

Step 3: Creating Your Database

Now you're in the database creation area. Let's create your database:

Choosing a Database Name

  1. Look for a box labeled "New Database Name" or "Create New Database"
  2. Think of a name for your database. Good examples:
    • If it's for a blog: myblog or blog2025
    • If it's for a store: mystore or shop
    • If it's for a general website: website or main

Important Naming Rules:

  • Use only letters, numbers, and underscores (_)
  • Don't use spaces or special characters like @, #, $
  • Keep it simple and easy to remember
  • Most hosting adds a prefix automatically (like username_myblog)
  1. Type your chosen name in the box
  2. Click "Create Database"

Success! You should see a message saying your database was created. Write down the full database name (including any prefix) - you'll need this later.

Step 4: Creating a Database User

Your application needs a "user account" to access the database. Let's create one:

  1. Scroll down to find "MySQL Users" or "Add New User"

  2. Look for "Username" box and type a username. Good examples:

    • admin
    • dbuser
    • appuser
    • Same name as your database

  3. Look for "Password" box and create a strong password:

    • Use at least 8 characters
    • Mix letters, numbers, and symbols
    • Don't use obvious passwords like "password123"
    • Write this password down! You'll need it later

  4. Look for "Password (Again)" or "Confirm Password" and type the same password

  5. Click "Create User"

Success! You should see a message confirming the user was created. Write down the username (including any prefix).

Step 5: Connecting the User to the Database

Now we need to give your user permission to use the database:

  1. Scroll down to find "Add User to Database" section
  2. Look for two dropdown menus:
    • One for selecting a user
    • One for selecting a database
  3. Select your newly created user from the first dropdown
  4. Select your newly created database from the second dropdown
  5. Click "Add" or "Submit"

Setting Permissions

You'll now see a page asking about permissions:

  1. Look for "ALL PRIVILEGES" checkbox and click it
    • This gives your user full access to the database
    • For beginners, this is the safest and easiest option
  2. Click "Make Changes" or "Add User to Database"

Success! Your user now has access to your database.

Step 6: Getting Your Connection Information

Your application will need specific information to connect to the database. Let's gather it:

Information You Need to Collect:

Write down these details exactly as they appear:

  1. Database Name: The full name including prefix (like username_myblog)
  2. Database Username: The full username including prefix (like username_admin)
  3. Database Password: The password you created
  4. Database Host: Usually localhost (this is the server address)
  5. Database Port: Usually 3306 (this is standard for MySQL)

Where to Find This Information:

  1. Go back to the MySQL Databases main page
  2. Scroll down to see "Current Databases" - your database name is listed here
  3. Scroll down to see "Current Users" - your username is listed here
  4. The host is almost always localhost
  5. The port is almost always 3306

Step 7: Testing Your Database (Optional but Recommended)

Let's make sure everything works:

  1. In cPanel, look for "phpMyAdmin" (usually in the Databases section)
  2. Click on phpMyAdmin
  3. You should see your database listed on the left side
  4. Click on your database name
  5. If it opens without errors, everything is working!

What to Do Next

For Website Applications:

Look for a setup page or configuration file in your application where you need to enter:

  • Database host: localhost
  • Database name: your_full_database_name
  • Database username: your_full_username
  • Database password: your_password

Common Configuration Files:

  • WordPress: wp-config.php
  • Joomla: configuration.php
  • Custom applications: Often called config.php or database.php

Troubleshooting Common Problems

Problem: "Database already exists"

Solution: Choose a different database name. Each database name must be unique.

Problem: "Access denied" when testing

Solution:

  • Double-check you gave the user ALL PRIVILEGES
  • Verify the username and password are correct
  • Make sure you added the user to the database

Problem: Can't find phpMyAdmin

Solution:

  • Look in the "Databases" section of cPanel
  • Some hosts put it under "Advanced" or "Tools"
  • Not critical - your database still works without testing it

Problem: Application can't connect

Solution:

  • Verify you're using localhost as the host
  • Check that all connection details are typed exactly right
  • Make sure there are no extra spaces when copying/pasting

Getting Help

When to Contact Support:

  • You can't access cPanel after trying both methods
  • You get error messages during database creation
  • Your application still can't connect after following all steps
  • You need to delete a database and start over

How to Contact Support:

  1. Go to: https://support.ifastnet.com/login.php
  2. New to support? Click "Register" to create an account
  3. Already have an account? Log in
  4. Click "Create New Ticket"
  5. Include in your ticket:
    • Your domain name
    • What you're trying to do
    • What error message you're seeing (if any)
    • What steps you've already tried

Quick Reference Card

Save this information for your application setup:

Database Host: localhost
Database Port: 3306
Database Name: [write your full database name here]
Database Username: [write your full username here]
Database Password: [write your password here]

Important Security Tips

  1. Keep your database password private - never share it publicly
  2. Use a strong password - weak passwords can be hacked
  3. Only give database access to applications that need it
  4. Don't use your cPanel password as your database password

Conclusion

Congratulations! You've successfully created a MySQL database in cPanel. You now have:

  • ? A working database
  • ? A user account with proper permissions
  • ? All the connection information your application needs

Your application should now be able to connect to the database using the information you've collected. If you run into any issues during your application setup, the connection details you've gathered are what most applications need to work properly.

Remember: Creating a database is just the first step. Your application will use this database to store information like user accounts, posts, products, or whatever data your website needs. The database acts like a filing cabinet where your application can save and retrieve information.