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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
FatCat Servers website uses cookies to enhance website experience performance. By continuing to browse the site, you are agreeing to our use of cookies.
OKWe may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.
We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.
We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.
We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Google reCaptcha Settings:
Vimeo and Youtube video embeds:
You can read about our cookies and privacy settings in detail on our Privacy Policy Page.
Privacy Statement