-
cPanel
-
- Mailing Lists
- Default Address
- Autoresponders
- Forwarders
- Email Accounts
- Spam Filters
- Track Delivery
- Global Email Filters
- Email Filters
- Address Importer
- Encryption
- Email Disk Usage
- Calendar Delegation
- BoxTrapper
- Configure Greylisting
- Email Routing
- Filter Incoming Emails by Domain
- Email Deliverability
- Authentication (SPF and DKIM)
- Show Remaining Articles (4) Collapse Articles
-
-
WHM
-
- SSH Password Authorization Tweak
- Apache mod_userdir Tweak
- SMTP Restrictions
- Compiler Access
- Configure Security Policies
- Password Strength Configuration
- cPHulk Brute Force Protection
- Security Questions
- Manage External Authentications
- Two-Factor Authentication
- ModSecurity™ Vendors
- ModSecurity Configuration
- Manage root’s SSH Keys
- Manage Wheel Group Users
- Host Access Control
-
- Terminate Accounts
- Quota Modification
- Modify an Account
- Change Site’s IP Address
- Create a New Account
- Manage Account Suspension
- Upgrade/Downgrade an Account
- Limit Bandwidth Usage
- Force Password Change
- Email All Users
- Reset Account Bandwidth Limit
- Password Modification
- Skeleton Directory
- Rearrange an Account
- Raw Apache Log Download
- Modify/Upgrade Multiple Accounts
- Web Template Editor
- Unsuspend Bandwidth Exceeders
- Show Remaining Articles (3) Collapse Articles
-
- Articles coming soon
-
- Articles coming soon
MySQL Databases
Log in to your cPanel>> Database>> MySQL Database
In order to start, log into cPanel and click on the MySQL Databases menu in the Databases section:
Once there, find the Create New Database section, then simply indicate name of the future database and click on the Create Database button:
The database is created and ready to use. Now, in order to be able to fill and maintain the database, MySQL User should be created and assigned to the database with correct privileges.
To create a MySQL User, find the section called MySQL Users > Add New User and choose the username you wish to assign to your database. Once done, choose a secure password for MySQL User and type it into the corresponding fields:
It is highly recommended to use the built-in Password Generator to create a secure password as shown below:
Make sure that you save the password, as you will need it to maintain the Database in the Future.
After the password is chosen, simply click on the Create User button to finish the process:
Now you have both MySQL Database and MySQL User created. Now we need to assign MySQL User to the database and set proper privileges. To do this, find the Add User To Database section and make sure that you choose the correct Database and User correspondingly. Once done, simply click on the Add button:
In the next window you will need to set correct privileges to the MySQL User. In this example, we shall grant all privileges to be able to maintain our MySQL Database without any restrictions, so you simply need to choose the All Privileges option and click on the Make Changes button:
NOTE: It is important to remember that multiple MySQL Users with different sets of privileges can be assigned to the same MySQL Database.
Once finished, you will get the message stating that the MySQL User was successfully added to the Database:
To check this, you can simply go back to the MySQL Databases menu and check the Current Databases section: