Summary:
The MySQL Database Wizard is a simplified, step-by-step tool that guides you through the entire process of setting up a database. Unlike the manual method, the wizard ensures you don't skip critical steps like creating a user or assigning the necessary privileges. It is the most efficient way to get your database ready for applications like WordPress or OpenCart.
Steps to use the Wizard:
Log in to your cPanel.
Under the Databases section, click on MySQL Database Wizard.
Step 1: Create a Database: Enter a name for your database and click Next Step.
Step 2: Create Database User: Enter a username and a strong password. Click Create User.
Step 3: Add User to Database: Check the box ALL PRIVILEGES to give the user full control over the database.
Step 4: Complete the Task: Click Make Changes. Your database is now ready to use.
Tip for Thamara Users:
Always remember that your full database and username include your cPanel username as a prefix (e.g.,
thamara_dbname). When configuring your website's configuration file (likewp-config.php), make sure to use the full name provided at the end of the wizard to avoid connection errors.