To install or use application that relies on a database of MySQL, you should follow these steps:
- Login to your cPanel, search, and click the tool MySQL Databases.
- Create a new database by entering the name in the field of the New Database and clicking the Create Database.
- Create a new user through entering Username and Password and clicking on Create User.
- Look for selecting Add User To Database and enter your new user you created in the new database you created and click Add.
- On the next screen, select ALL PRIVILEGES and click Make Changes.
With these steps, you created a new database, a new user and gave the user full access and processing of new database.
The base and the user you create, are prefixed with your username to access the cPanel. Name of the database and user name, is the full type name cPanelUsername_DatabaseNameorUser.
To install an application or to change the configuration by connecting to your database, use data in the following format:
- Host: localhost
- Database Name: cPanelUsername_DatabaseName
- Database Username: cPanelUsername_DatabaseUser
- Password: your Password