MySQL databases are essential for many web applications, including content management systems and ecommerce platforms. Here's how you can create and manage MySQL databases in cPanel:
Step 1: Log in to cPanel
First, log in to your cPanel account. This is typically done by adding /cpanel to the end of your domain name in your web browser (e.g., www.yourdomain.com/cpanel).
Step 2: Access MySQL Databases
Once you're logged in, look for the 'Databases' section on your cPanel home screen and click on 'MySQL Databases'.
Step 3: Create a New Database
On the MySQL Databases page, you'll see a form under the 'Create New Database' heading. Enter a name for your new database and click 'Create Database'. You'll see a confirmation message when the database has been created successfully.
Step 4: Create a Database User
Scroll down to the 'MySQL Users' section and find the 'Add New User' form. Enter a username and password for the new user. You can use the 'Password Generator' button to generate a strong password. Click 'Create User' to create the new user.
Step 5: Add User to the Database
Now, you need to give your new user permission to access your new database. Scroll down to the 'Add User To Database' section. Select the user and the database from the dropdown menus and click 'Add'.
Step 6: Set Database Privileges
You'll now see a list of privileges. If you want the user to have full access to the database, check the box next to 'ALL PRIVILEGES'. Otherwise, select the individual privileges as needed. Click 'Make Changes' to save your selections.
Step 7: Manage Your Databases
You can manage your databases at any time from the MySQL Databases page. Here, you can check a database, repair a database, or delete a database. You can also modify user privileges or delete users from databases.
Remember, managing databases is a powerful action, so always be careful when deleting or modifying databases or users. If you're unsure about something, don't hesitate to reach out to our support team. We're here to help!