How to repair a MySQL database in cPanel

How to repair a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Click the MySQL Databases icon.

Now let’s learn how to repair a database.

Under Modify Databases, and in the Repair Database drop down box, select the database you want to repair.

Then click Repair Database.

That’s it! The database has been repaired.

This is the end of the tutorial. You now know how to repair a database in cPanel.

How to check a MySQL database for errors in cPanel

How to check a MySQL database for errors in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Click the MySQL Databases icon.

Now let’s learn how to check a database for errors.

Under Modify Databases, and in the Check Database drop down box, select the database you want to check.

Then click Check Database.

That’s it! The check has been completed, and no errors were found.

This is the end of the tutorial. You now know how to check a database for erros in cPanel.

How to delete a MySQL database user in cPanel

How to delete a MySQL database user in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Click the MySQL Databases icon.

Now let’s learn how to delete a database user.

Locate the Current Users section at the bottom of the page, and click the Delete icon next to the user you want to delete.

Then click Delete User to confirm.

That’s it! The database user has been deleted.

This is the end of the tutorial. You now know how to delete a database user in cPanel.

How to remove a user from a MySQL database in cPanel

How to remove a user from a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Click the MySQL Databases icon.

Now let’s learn how to remove a user from a database.

In the table of databases, locate the database you wish to remove a user from…

… then locate the specific user assigned to that database that you want to remove… and click the delete icon.

Click Revoke User Privileges from Database to confirm.

That’s it! The user has been removed from the database.

The user hasn’t been deleted… you can see it’s still listed in the list of current users.

It has simply been removed from that database.

This is the end of the tutorial. You now know how to remove a user from a database in cPanel.

How to change a MySQL database users password in cPanel

How to change a MySQL database users password in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Click the MySQL Databases icon.

Now let’s learn how to change a database users password.

Locate the user whose password you want to change, and click Set Password.

Enter and confirm a new password, then click Change Password.

That’s it! The database user’s password has been changed.

This is the end of the tutorial. You now know how to change a database user’s password in cPanel.

How to assign a user to a MySQL database in cPanel

How to assign a user to a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Click the MySQL Databases icon.

Now let’s learn how to assign a user to a database.

Under Add User To Database, select the user you want to add, and then select the database you want to add it to.

When ready, click Add.

Select the privileges you want to grant the user… in this case, let’s select All Privileges.

Then click Make Changes.

That’s it! The user has been assigned to the database.

You can see the user assigned to the database in the table of databases.

This is the end of the tutorial. You now know how to assign database users to databases in cPanel.

How to create a MySQL database user in cPanel

How to create a MySQL database user in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Click the MySQL Databases icon.

Now let’s learn how to create a MySQL database user.

Under Add New User, enter a username for the user you want to create, along with a password.

Then click Create User.

That’s it! The new database user has been created.

You can see the new database user listed at the bottom of the page.

This is the end of the tutorial. You now know how to create a MySQL database user in cPanel.

How to delete a MySQL database in cPanel

How to delete a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Now let’s learn how to delete a MySQL database.

Click the MySQL Databases icon.

Locate the database name you want to delete, and click the Delete Database link next to it.

Then click Delete Database to confirm.

That’s it! The MySQL database has been deleted.

This is the end of the tutorial. You now know how to delete a MySQL database in cPanel.

How to create a MySQL database in cPanel

How to create a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Now let’s learn how to create a MySQL database.

Click the MySQL Databases icon.

Enter a name for the new database, then click Create Database.

That’s it! A new MySQL database has been created.

This is the end of the tutorial. You now know how to create a MySQL database in cPanel.

The new database is listed on the databases page, under Current Databases.

How to create vacation messages in Direct Admin

How to create vacation messages in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to setup a vacation message

Scroll down…

Click the Vacation Messages link here

Click the Set Vacation Message link here

There are currently no vacation messages setup… let’s set one up now

Scroll down…

Choose the email address for which you want this vacation message setup

Type your vacation message in this box

Then set the Start and End dates, between which this vacation message will be active

When finished, click the Create button

Let’s delete the vacation message we just setup… click this check box

That’s it! The vacation message has been setup, and will be sent automatically to anyone who sends an email to this address during the vacation time

You can return to this screen at any time to modify existing vacation messages, create new ones, or delete them altogether

Then click the Delete Selected button

The vacation message has been deleted

Click the Home icon here

This is the end of the tutorial. You now know how to setup vacation messages so people who email you while you’re on vacation will be notified automatically

How to manage URL redirects in Direct Admin

How to manage URL redirects in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to create URL redirects from Direct Admin

Scroll down…

Click the Site Redirection link

Type in the URL of the page you want to redirect away from

This is the main redirect page, where you can create and delete URL redirects

Then enter the destination URL, or the page you want visitors to be redirected to

Click Save

Now let’s delete the URL redirect we just setup

That’s it! The URL redirect has been setup….. and is now listed here

Click the Home icon here

The URL redirect has just been deleted

This is the end of the tutorial. You now know how to setup URL redirects, and delete them, from your Direct Admin control panel

How to create a subdomain in Direct Admin

How to create a subdomain in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to create a subdomain

Click the Subdomain Management link here

Enter the prefix of the new subdomain here

The is the subdomain page where you can setup and remove subdomains for your hosting account

Let’s go ahead and create a new subdomain

Then click the Create button

To delete the subdomain, click this box here…

Success! The new subdoman has been created, and a folder of the same name has also been setup in your public_html directory… which is where you would upload your subdomain files

From this page, you can check your subdomain stats, and bandwidth usage, as well as view it’s usage logs and error logs

… and click this box if you also want the newly created folder and it’s contents removed…

Then click the Delete Selected button

The subdomain has been removed from the hosting account

Click the Home icon here

This is the end of the tutorial. You now know how to setup new subdomains and view their usage stats, as well as how to remove subdomains from your account

How to install an SSL certificate in Direct Admin

How to install an SSL certificate in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to install an SSL certificate in Direct Admin

Scroll down…

Click the SSL Certificates link

Scroll down…

Keep in mind that you can only install an SSL certificate into an account that uses a dedicated IP address; if this account did not have a dedicated IP address, then this page would have returned an error

Let’s start by creating a certificate request

To install an SSL certificate, we first have to create a certificate request, then take that request to an SSL certificate vendor to purchase a certificate

Enter the details of your company for the certificate

Scroll down…

When finished, click Save

The certificate request has been generated, and is located here; you must copy this request and use it in your SSL certificate vendor’s order form when purchasing your certificate

Once you’ve purchased your new SSL certificate, return to the SSL certificates screen

Scroll down…

We now have to paste our newly bought certificate below the Private Key shown below…. click here

Paste the new SSL cetificate here

Scroll up…..

You would then click the Save button to install the new SSL certificate

Click the Home icon here

This is the end of the tutorial. Remember that your account must be setup with a dedicated IP address in order for you to be able to install a dedicated SSL certificate for your domain

How to create spam filters in Direct Admin

How to create spam filters in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to create Spam Filters in Direct Admin

Scroll down…

Click the SPAM Filters link

Let’s go ahead and block email from a specific address

This is the main E-mail Filter (or spam filter) screen, where you can enter several different kinds of filters

You can block email from specific email addresses, from an entire domain, or emails containing specific words

You can also block emails that are too large, and/or enable the adult email filter which will block emails containing common adult phrases

Now let’s block email from an entire domain

The email address badguy@msn.com has been blocked

Now let’s enable the Adult Filter….. click here

The Adult Filter has been enabled

For any emails that match our filter criteria, let’s choose to send those emails to a spambox

Then click Save

Let’s remove the filters we just created…..

From this E-Mail Filters screen, we can also remove existing spam filters

Click the Home icon here

This is the end of the tutorial. You now know how to create email filters from Direct Admin, as well as remove them

How to change your password in Direct Admin

How to change your password in Direct Admin

Click the Change Password link

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to change our Direct Admin password

In order to change your Direct Admin password, you first must enter your existing password here

This is the Change Password main screen

Then enter your new password here

….. and again here

When finished, click Submit

That’s all there is to it! The password has been changed, and you now must use your new password when logging in to Direct Admin

Click the Home icon here

This is the end of the tutorial. You now know how to change your Direct Admin password. Remember that for security reasons, it’s a good idea to change your password often

How to password protect a directory in Direct Admin

How to password protect a directory in Direct Admin

Click Password Protected Directories

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to password protect a directory in our hosting account

There are currently no directories in this account, that are password protected

Let’s locate a directory to protect…. click here

Let’s password protect the Members directory in this hosting account… click the Protect link for the Members directory

Enter the Prompt for the login box that will appear when someone tries to access this directory

enter a username…

… and password

Then re-enter the password here

Click the Protection Enabled box to enable password protection for this directory

Click Save when finished

That’s it! The Member’s directory is now protected in that visitors will be prompted for a username and password before they can enter

Click the Home icon here

Click the Password Protected Directories link again

This link represents the directory we just protected. Let’s click the link to manage it

Scroll down…

… and here we see a list of users that have been created and given password access to this directory

We can update an existing user’s password by entering the username here, followed by the new password…..

… and we can also add new users to this directory by entering new usernames and assigning them passwords as well

Finally, we can delete existing users from having access to this directory by selecting them here and clicking delete

Here we can see that this directory has password protection enabled

This is the end of the tutorial. You now know how to password protect a directory in your hosting account, such that people will have to enter a username and password to enter it

How to create a POP email account in Direct Admin

How to create a POP email account in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s create a new POP email account

Scroll down…

Click the E-Mail Accounts link

There is already a POP email account listed… it is the main POP account that every hosting account comes with (username@domainname.com)

But we’re not going to use that account…. we’re going to create a new POP email account

Click the Create mail account link here

Here’s where you create a new POP email account

Enter the new email address you want to create here

Give the new account a password

Re-enter your password

If you want to put a size (or storage space) limit on this email account, enter it here

When finished, click the Create button

That’s it! The new POP email account has been created

Scroll down…

Click here when finished

Details of the new account are listed here. Be sure to pass this information on to whoever will be using this email account, so they can properly setup their email program to access it

Click the Home icon here

This screen shows all the POP email accounts in your hosting account, including the account we just created

From this screen you can create additional POP email accounts, delete existing ones, or change their passwords

This is the end of the tutorial. Don’t forget to setup your new POP email account in your favorite email program (i.e. Outlook, Outlook Express, Eudora, etc.)

How to create a Domain Pointer in Direct Admin

How to create a Domain Pointer in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to setup domain pointers

Scroll down…

Click the Domain Pointers link

This is the main Domain Pointers screen

A domain pointer allows you to point another domain name to your main account domain name, so that both domain names resolve to the same website

You can setup as many domain pointers as your account plan will allow, resulting in many domain names all pointing to the same website

Let’s setup a domain pointer now…. enter a domain name to be redirected to this account

Click the Add button

The domain name you enter must have it’s nameserver (or DNS) settings changed to the same DNS settings your main domain is set to….. this is done through your domain registrar

Now let’s delete the domain pointer we just created….. click here

The new domain pointer has been setup!

Then click Delete

The domain pointer has been deleted

Click the Home icon here

This is the end of the tutorial. You can return to this section and setup as many additional parked domains as your account plan will allow

Becoming Familiar and Navigating around in Direct Admin

Becoming familiar and Navigating around in Direct Admin

This demo assumes you’ve already logged in to Direct Admin

Now let’s familiarize ourselves with Direct Admin

Across the top of the main Direct Admin screen, there are icons available for easy access to the most popular tools

The Webmail icon will take you directly to your webmail application…..

The Password icon is a quick link to where you can change or reset your account password…..

The Help icon will take you to complete documentation on using Direct Admin…..

The Files icon takes you directly to File Manager

Let’s go take a look at the available Help documentation….. click the Help icon

… and the Logout icon is what you click when you are finished with Direct Admin. You should always logout when you are finished

Click the editing HTML link here

This is the main Help page, and it has dozens of helpful links for learning how to use Direct Admin

We get taken to a page that explains exactly how to edit HTML pages, complete with additional links you can click to get more information

Now click the Creating e-mail accounts link

Here’s a page that explain how to create email accounts

This help page is a terrific source of information on using Direct Admin

On the right of the screen is some general account information

You can see how much disk space you’ve used, and how much you have available to you…..

….. and same with Bandwidth (or data transfer), E-mails, FTP accounts and MySQL Databases

Scroll down…

Now back at the main Direct Admin page…..

Click the Server Information link here

… and if we scroll down…

Here we can see detailed information about the server…..

Scroll back to the top of the page…..

We can see if all the services in the server (Exim, MySQL, Apache, etc) are running properly

Click the Home icon

Now let’s take a look at the Installed Perl Modules….. click here

This page lists every Perl module that’s installed in the server. You may need to consult this page if you’re installing a script that needs a certain Perl module, and you’re unsure if it’s installed

Scroll down…

This list is very long…..

Click the Home icon here

This is the end of the tutorial. You should now be more familiar with navigating around in Direct Admin. To learn more about the various features of Direct Admin, you can return to the Help link on this main page

How to create a MySQL database in Direct Admin

How to create a MySQL database in Direct Admin

Click the MySQL Management link

This demo assumes you’ve already logged in to Direct Admin

Now let’s learn how to create a MySQL database

Let’s go ahead and create a new database… click this link

This is the main MySQL database screen where you can create new databases, or manage existing ones

Create a Database Name, and Database Username in the spaces provided

Then enter the database Username Password here…..

….. and again here

Then click the Create button

Scroll down…

The database has been successfully created

Now let’s return to the database page…. Click Here

Listed here are the values you’ll need if connecting to this database from a program or script

Let’s click on the database we just created

From this page you can create new databases, or modify existing ones

Now click the modify privileges link for this user

Let’s leave everything unchanged…. click the Save button

Although you’ll typically never have to modify any of these settings, this is where you would limit certain types of access for specific users

Click the Home icon here

This is the end of the tutorial. You now know how to create MySQL databases, and modify user preferences