How To Create a Database
This guide will help you create a database for Clientexec. Depending on your server configuration, there are multiple ways of doing this. This tutorial will show how to create a database through cPanel, how to manually create one via PHPMyAdmin and how to create one in Plesk.
Login to your cPanel.
Navigate to the MySQL® Database Wizard.
Create your database name.
Click Next Step.
Create your database's username and password.
Click Create User.
Click ALL PRIVILEGES.
Click Next Step.
Your database has now been created. Be sure to notate the information you entered as it will be asked for during the installation process.
Navigate to PHPMyAdmin.
Click Databases.
Specify a database name, then click Create.
The database has been created; it should instantly appear in the list below the creation section. Click Check Privileges to the far right.
Click Add User.
Fill in the database user information. On the Host tab, unless the server configuration is different, Local can be selected which will autofill the field with localhost. Click Check All on the Global Privileges area.
Click Add User.
You have successfully created a database and created a database user with full access to our database.
Note: we are using Service Provider View for these instructions.
Login to your Plesk.
Go Domains and select the Website where you wish to install Clientexec.
Select Databases.
Click the Add Database button.
Fill out the information for your new Database.
Database Name: enter the name for your new Clientexec database.
Related Sites: in the dropdown, select the domain where your Clientexec will be hosted.
Database Username: create a username for your database.
Password: create a Password for your database.
Confirm Password: confirm the password you created.
Press the OK button.
Your database has now been created. Be sure to notate the information you entered as it will be asked for during the installation process.
Method 1 - cPanel Database Creation
Login to your cPanel.
Navigate to the MySQL® Database Wizard.
Create your database name.
Click Next Step.
Create your database's username and password.
Click Create User.
Click ALL PRIVILEGES.
Click Next Step.
Your database has now been created. Be sure to notate the information you entered as it will be asked for during the installation process.
Method 2 - PHPMyAdmin Database Creation
Navigate to PHPMyAdmin.
Click Databases.
Specify a database name, then click Create.
The database has been created; it should instantly appear in the list below the creation section. Click Check Privileges to the far right.
Click Add User.
Fill in the database user information. On the Host tab, unless the server configuration is different, Local can be selected which will autofill the field with localhost. Click Check All on the Global Privileges area.
Click Add User.
You have successfully created a database and created a database user with full access to our database.
Method 3 - Plesk Database Creation
Note: we are using Service Provider View for these instructions.
Login to your Plesk.
Go Domains and select the Website where you wish to install Clientexec.
Select Databases.
Click the Add Database button.
Fill out the information for your new Database.
Database Name: enter the name for your new Clientexec database.
Related Sites: in the dropdown, select the domain where your Clientexec will be hosted.
Database Username: create a username for your database.
Password: create a Password for your database.
Confirm Password: confirm the password you created.
Press the OK button.
Your database has now been created. Be sure to notate the information you entered as it will be asked for during the installation process.
Updated on: 24/06/2023
Thank you!