Creating a MySQL Database

MySQL databases are essential for storing and managing data in various web applications. This guide provides step-by-step instructions on how to create a MySQL database using your control panel.

Step 1: Log in to Webuzo

1. Access your Webuzo account using your login credentials.
2. After successful login, you will be redirected to the Webuzo dashboard.

Step 2: Creating a MySQL Database

1. Scroll down your Webuzo dashboard to the "Database" section.
2. Look for the "Add Database" option within this section and click on it.
3. On the Create Database page, enter the database name.
4. After entering the database name, click on the "Create" button to create the database.

Step 3: Creating a MySQL User and Granting Access

1. In your Webuzo search bar, enter "Add Database User" and click on the corresponding option.
2. Choose a username for the MySQL user and enter it in the "New User" field.
3. Create a secure password for the MySQL user and enter it in the password field. You can use the Password Generator tool provided for better security. Remember to save this password.
4. Once the username and password are set, click on the "Create" button.

Step 4: Assigning User to Database and Granting Privileges

1. In your Webuzo search bar, enter "Add User To Database" and click on the corresponding option.
2. Select the MySQL user you created from the 'User' drop-down menu.
3. Choose the database to which you want to assign the user.
4. Select the privileges you wish to grant to the user. For full access, you can grant all privileges.
5. Click on the "Submit Changes" button to assign the user to the database and apply the privileges.

Step 5: Confirming User Privileges

1. After making the changes, you will get a confirmation message indicating Database Privileges Updated.

By following these steps, you can successfully create a MySQL database, create a MySQL user, and assign the user to the database with appropriate privileges in Webuzo. This enables you to manage and store data effectively for your web applications.

If you encounter any issues or need further clarification, please contact us.