MANAGING DATABASE USERS

MANAGING DATABASE USERS

To access MySQL databases, you must first create at least one user. The following procedures describe how to manage MySQL database users using cPanel.

Creating a database user

To create a MySQL database user, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Add New User, type the MySQL username in the Username text box.
3. In the Password text box, type the user password.
4. In the Password (Again) text box, retype the user password.
   You can click Password Generator and cPanel generates a random, strong password for you.
5. Click Create User.

Changing a user's password

You can change a database user's password. You may want to do this for security reasons (changing passwords periodically is a good security practice), or you may need to do this if you forget the password.

To change a MySQL user's password, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Current Users, locate the user for which you want to change the password, and then click Set Password.
3. In the Password and Password (Again) text boxes, type the new password.
   You can click Password Generator and cPanel generates a random, strong password for you.
4. Click Change Password. The new password takes effect immediately.

Renaming a user

To rename a MySQL user, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Current Users, locate the user that you want to rename, and then click Rename.
3. In the text box, type the new name, and then click Proceed.

Deleting a user

When you delete a user, the user and its database permissions are deleted.

To delete a MySQL user, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Current Users, locate the user that you want to delete, and then click the red X icon.
3. Click Delete User to confirm the deletion.

MANAGING DATABASES

After you create a database user, you are ready to create a database and associate the user with the new database.

Creating a database

To create a MySQL database, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Create New Database, type the name of the database in the New Database text box.
3. Click Create Database.
   When you create a database, your username is added to the database name. For example, if your username is username, and you create a database named database, the actual MySQL database name is username_database.

Adding a user to a database

To add a MySQL user to a database, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Add User to Database, select the user that you want to add in the User list box.
3. In the Database list box, select the database.
4. Click Add.
5. Click the check boxes to grant the user specific privileges, or click the ALL PRIVILEGES check box to grant the user all permissions to the database.
6. Click Make Changes.

Checking and repairing a database

You can check MySQL databases for errors or possible corruption. If a database check reveals problems, you can repair the database as well.

To check and repair a database, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. To check a database:
   • Under Modify Databases, select the database in the Check DB list box.
   • Click Check DB.
3. If a database check indicates problems with a database, you can repair it:
   • Under Modify Databases, select the database in the Repair DB list box.
   • Click Repair DB.

Removing a user from a database

When you remove a user from a database, the user can no longer access the database.

To remove a MySQL user from a database, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Current Databases, locate the user that you want to remove, and then click the red X icon.
3. Click Delete User from Database to confirm the deletion.

Deleting a database

Before you delete a database, make sure that you have a backup copy if you want to save any information that it contains.

When you delete a database, its associated users are not deleted. However, all permissions users have for that database are deleted.

To delete a MySQL database, follow these steps:

1. In the Databases section of the cPanel home screen, click MySQL® Databases.
2. Under Current Databases, locate the database that you want to delete, and then click Delete Database.
3. Click Delete Database to confirm the deletion.

Managing a MySQL database in PHPMyAdmin

1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
2. Now let’s learn how to manage a database with phpMyAdmin.
3. Click the "phpMyAdmin" icon.
   
4. This is the phpMyAdmin main page. It is from here that you can manage all MySQL databases that exist in your hosting account.
   
5. In the top left corner, you’ll see an entry with your account user name. Click the "plus sign" to its left.
   
6. You’ll now see a list of databases in your account. Click the one you want to manage.
   
7. You can now start managing your database. You can manage tables, add or delete entries, and perform queries among other things.
   

Creating a database in cPanel using the MySQL Database Wizard

Creating a database in cPanel using the MySQL Database Wizard

1. Log into your cPanel.
2. Click the MySQL Database Wizard under the Databases heading.
   
3. Next to New Database enter a name for your database and click Next Step.
   
4. Next to Username enter a username.Enter a password next to Password, enter it again for Password (Again) and then click Create User.
   
5. On the next page, you'll assign privileges for the user to the database. Check the box next to All Privilegesand then click Next Step.
   

Congratulations, now you know how to successfully create a database!

How to add a new subdomain and change its settings

How to add a new subdomain and change its settings

Subdomain

 

The subdomain is an extension of the primary domain that the user can create independently through his control panel (cPanel). The subdomain is used if you want to set up a new, independent web site on the same hosting, but you don’t need a different domain from the primary one. If the main domain is domain.mk, you will recognize the subdomains as a supplement to the main domain, for example: subdomain1. domain.mk, subdomain2.domain.mk, etc. You can access the subdomain through subdomain.domain.mk or domain.mk/sudomain. Additionally, for each created addon domain a new subdomain is automatically created.

 

Instructions for creating a subdomain

 

Step 1: Log in to your cPanel account (domain_name/cpanel) with the appropriate username and password.

Step 2: In the Domains section, click on Subdomains.

Step 3:

- In the newly opened window in the Subdomain section, enter the name of the subdomain you want to create.
- If you have more active domains on your hosting, from the Domain drop-down menu, select the domain you will use to create the subdomain.
- In the Document Root section, set the path where you want to create the folder on the subdomain, where your web site will be set up. The example given in the image, the folder on the subdomain proba.mkhost.com.mk is placed in the public_html folder. If you do not fill the Document root field, it will automatically be filled and the subdomain folder will be in the home directory (/).
- Click on the Create button

By doing this, the procedure for creating a subdomain is completed.
Have in mind that, after creating a specific subdomain, you should wait to refresh DNS zones (sometimes it may not be available immediately online). Our suggestion is to create the subdomain first (without first accessing it in a browser), wait 5 minutes after creation, and then access it.

Setting certain changes to a created subdomain 

Certain changes can be made to an existing subdomain. To change the path, first find the subdomain in the Subdomains -> Modify a Subdomain section, and in the Document Root section, click on the edit icon..

 

In the newly opened window, enter the new path. Then, click the Change button.



If you want to redirect the subdomain to another domain, click the Manage Redirection button and enter the link to which you want the subdomain to be redirected, then click on the Save button.

Creating FTP Accounts and linking

To create a new additional FTP account:

1. Go to Home > FTP Accounts.
2. On the FTP Accounts tab, click Create FTP Account.
3. Specify the FTP account name in the appropriate field.
4. Specify the Home directory by clicking  and select the directory required. Alternatively, you can specify the path in the input field.
5. Type the new password into the New password and Confirm password boxes.
6. Specify what FTP user can do with files and folders, and how much disk space on the server he or she can occupy:
   • To limit the amount of disk space, clear the Unlimited check box next to the Hard disk quota box, and type the amount of disk space in megabytes.
   • To allow the FTP user to view the contents of the home directory and download files from it, select the Read permission check box.
   • To allow the FTP user to create, view, rename and delete directories in the home directory, select the Write permission check box.
     If
     you do not grant any permissions, a connection to the FTP account will 
     be made, but the contents of the home directory will not be shown to the
     user.
7. Click OK. A new FTP account will be added

Installing your cPanel SSL Certificate

How to manage SSL hosts and the shared certificate in WHM

  

1) Go to SSL/TLS in the menu.

2) Click Manage SSL Hosts.

3) If you have any Installed SSL Hosts or certificates, you can delete each one using its Delete button. Or, you can share an SSL host's certificate by selecting it in the menu, then pressing Share.

The SSL certificate we chose has now been set as the shared certificate. Now, any user on the server can access their account through that domain. For example, the user mysite3's account could be accessed through the shared SSL host as such:https://www.demo123.com/~mysite3/

4) Return to the previous page.

5) To disable the Shared Certificate, click Disable.

The SSL certificate is no longer shared.

T 

Modify an Account via WHM

1. Log into your WHM
2. Click "Modify an Account" in the left menu under the "Account Functions" header
3. Choose the account in question by either clicking the main domain name or the username, and then click "Modify"
   
4. Make your desired changes and then click "Save"
   

Resetting a cPanel password

Resetting a cPanel password

1. Log into your WHM interface.
2. Click on the Account Functions option in the left hand menu.
3. Click on the Password Modification tool. This can be done either from the left menu or the main panel.
4. Select the account you wish to change the password for by highlighting it in the list.
5. Enter the new password in the Password field. Optionally, you can have the WHM generate a random password using the Password Generator button.
   NOTE: Be sure to write down the password as you will not be able to see it after leaving this page.
6. Click on the Change Password button to save the new password.

Now the cPanel user can use the new password to access their cPanel. WHM does not automatically notify anyone of the new password so you will need to let the cPanel manager know the new password if it is someone other than yourself.

How to view Bandwidth Usage

How to view Bandwidth Usage

To view bandwidth usage for each of your cPanel accounts:

1. Log into your WHM
2. Click "View Bandwidth Usage", which is under the "Account Information" heading in the left menu
3. A list of your accounts will be listed, and the bandwidth usage for the current month can be seen under "Xfer (in Megs)". You can also view usage for other months by clicking the "Last Month" and "Next Month" links.

UNInstall FrontPage Extensions via WHM

o remove FrontPage extensions, complete the following steps. 

1. Login To WHM
2. In the search bar located in the top left, search for 'FrontPage'
   
   
   
3. Click on 'Uninstall FrontPage Extensions'
4. At the bottom of the page, ensure there is a tick in the 'Uninstall Microsoft® FrontPage Extensions.' option
   
   
5. Click the blue 'Uninstall' button
6. You will receive confirmation that FrontPage has been uninstalled
   
   
7. Once it has been removed, it will no longer show up in WHM
   
   
   
8. You will now be able to update WHM, and it is highly recommended that you do so, to update search for 'Upgrade' in the search bar
   
   
   
9. To update the server ensure the 'Force a reinstall even if the system is up to date' box is ticked, then click on 'Click to Upgrade'
   
   

The server will now be updated, with Frontpage extensions removed.

How to install FrontPage Extensions on an account in WHM

Now let's learn how to manage FrontPage extensions.

FrontPage extensions should only be installed in accounts where FrontPage will be the program used to create the website. If FrontPage will not be used, do not install the FrontPage extensions.

1) Click FrontPage here.

From here you can install (or uninstall) FrontPage extensions into any account in your reseller plan.

Also be aware that your customers can do this with their own accounts themselvesfrom their cPanel control panel.

2) Click the install FrontPage extensions link.

3) Select mynewtestdomain.com as the account for which we want to install the FrontPage extensions.

4) Then click install.

That's it! FrontPage extensions have been installed in the mynewtestdomain.com account.

Remember that once FrontPage extensions are installed, files should only be uploaded to that account using FrontPage and the HTTP uploading method. Using the FTP method may damage the extensions, and might require you to re-install them.

5) Click the uninstall FrontPage extensions link.

6) Select mynewtestdomain.com, then scroll down and click uninstall.

The FrontPage extensions have now been removed from this account.

7) Click the install FrontPage mail extensions link.

8) Click proceed.

We just installed the FrontPage mail extensions in any account that needed them.

Changing your cPanel account password

Changing your cPanel account password

To change your cPanel password, please follow these steps:

1. Login to your cPanel account here
2. Click on the avatar icon in the top-right corner of the page
3. Click on "Password & Security"
4. Enter the information needed
5. Click the "Change your password now!" button

Checking the space usage of the account

Step 1 — Checking the short summary of Disk Space Usage

Login to your cPanel and on the right hand side, you will see a short summary of your Disk Space Usage.

Step 2 — Checking Disk Space Usage statistics

Full details of your Disk Space Usage can be found by clicking on Disk Usage button under Files section of your cPanel.

Scroll down the page, then expand the folders with the > sign to the left of each folder. This will show exactly where your disk space is being used.

In order to remove unwanted files, click on the desired folder and File Manager will be opened in your browser.

Quota Modification for an account via WHM

Modify a cPanel accounts quota from WHM

 

This article will guide you on how to modify the disk quota of a domain from WHM. You can easily increase or decrease the disk quota for a domain created from WHM by following the below steps.

1. Login to WHM
2. Select the List Accounts option from Account Information under the WHM home.

3. Search for the domain for which you are planning to change the disk quota, click on the “+” right next to the domain.

4. Click on the Change Quota options under Actions section

5. You can edit the quota from the Quota Modification page, you can either set the quota to unlimited or set the value which you wish to set.

Terminate an Account via WHM

1. Once you are logged into WHM, you can search for the list of accounts in the search bar on the right-hand side of the page.
   
2. Search for a list of your accounts, by starting to type “List Accounts.” WHM will automatically bring that choice up for you to select and go to the Accounts page.
   
3. You will see a listing of the cPanel accounts on the List Accountspage.
   
4. Select the domain/url you want to delete by clicking the [+] next to the domain name.
   
5. Once the account is open, you will see many options for managing the account, including termination.
   
6. To delete the account, click Terminate Account.
   Termination is final and irreversible. Please take a backup of your files, email and any other information you wish to save to your local drive. For information on how to backup your cPanel account, please see our article Creating a Backup for a Site in cPanel.
   
7. An Account Selection page will open to confirm the domain and the users you are deleting.
   When an account is deleted, the DNS Zone is also deleted. If you are moving the site to a different server, click Keep DNS Zone so that it is not deleted.
   
8. A pop-up will appear to confirm that you want to delete the account. Click Proceed to begin the process.
   
9. The details of the deletion will show on the WHM page.
   
10. Once the account deletion is complete, you will receive an email to confirm that the account was deleted. It will also be deleted from your List Account page.