Knowledgebase

Follow these steps to create a new MySQL database in the Aviums Host control panel:

Step 1: Log Into Your Aviums Host Account

1. Visit Aviums Host: Open your web browser and go to the Aviums Host website.
2. Sign In: Enter your username and password to log into your account.

Step 2: Access the Control Panel

1. Navigate to the Control Panel: Once logged in, locate and click on the Control Panel or cPanel link from your account dashboard.

Step 3: Locate the Database Section

1. Find MySQL Databases: In the control panel, look for the Databases section. This is where you manage your databases.
2. Click on MySQL Databases: Select MySQL Databases to open the database management interface.

Step 4: Create a New Database

1. Create New Database: In the MySQL Databases section, you will see a field labeled Create New Database.
2. Enter Database Name: Type in your desired name for the new database (e.g., mywebsite_db).
3. Click Create: Press the Create Database button. You should see a confirmation message that your database has been created successfully.

Step 5: Create a Database User

1. Add New User: Scroll down to the MySQL Users section within the same database management interface.
2. Fill User Details:
   • Username: Enter a username for the database user.
   • Password: Create a strong password for the user.
3. Click Create User: Once you’ve filled out the information, click the Create User button.

Step 6: Assign User to Database

1. Add User to Database: Scroll down to the Add User to Database section.
2. Select User and Database:
   • In the first dropdown, select the user you just created.
   • In the second dropdown, select the database you created earlier.
3. Click Add: Click the Add button to assign the user to the database.
4. Set Privileges: You will see a list of privileges you can grant. For most uses, select All Privileges to allow full access to the database, and then click Make Changes to apply.

Step 7: Access Your Database

1. Open phpMyAdmin: To manage your new database, look for the phpMyAdmin option in the control panel under the Databases section.
2. Select Your Database: In phpMyAdmin, click on the name of the database you created to manage its tables, import data, and perform queries.