Managing MySQL databases with phpMyAdmin in Direct Admin

Managing MySQL databases with PHPMyAdmin 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 use PHPMyAdmin to manage MySQL databases

Click the phpMyAdmin link

Enter your system username and password

Then click OK

This is the PHPMyAdmin main screen

From this drop-down menu, let’s choose a database to manage

Click the SQL link

There are currently no tables in this database, as indicated here

Click the Import link

You can run SQL queries here, but we’re not going to do that now…..

Then click Browse so we can search for a database to upload

Let’s upload table1.sql from our local computer

Scroll down a little….

To complete the upload, click Go

Click the table1 link

We’ve successfully uploaded the table called table1.sql to the test.sql database

Click the Export link

On this page you can see all the details of table1 within the database test.sql

Now let’s learn how to save the table1 table to our personal computer

Scroll down…..

Select the Save as file check box

Then click Go

Click Save

Click Save

Click Yes to re-write the old table1.sql file

Click Close

We’ve just saved table1 to our computer

Click the Exit button

If at any time you need help with using PHPMyAdmin or MySQL, click on one of these help links

We’ve successfully signed out of PHPMyAdmin

Click the Home icon here

This is the end of the tutorial. You now know how to use PHPMyAdmin to manually manage a MySQL database

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 view website statistics in Direct Admin

How to view your website statistics in Direct Admin

Click the Site Summary / Statistics / Logs link

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

Now let’s learn how to view our website statistics

This is the main web stats screen, and has lots of information about this hosting account

Scroll down…

For example….. we’ve used 2.50 MB of bandwidth so far this month, and are allowed a total of 5,000 MB

We’ve also used only 2 of our allowed 50 POP email accounts

Scroll down…

Here you can view how many resources you’ve used in your account (Current Usage), as well as the total amount you’re allowed (Maximum Usage)

Scroll down…

You can change the email address the server (or server administrator) uses to notify you of important messages here

Scroll back up to the top of the page…..

Here is where you can see all the various services in the server, and whether or not they are running

Click the demo1234.com link here

Now let’s take a look at the webalizer stats for our website

Scroll down…

This is the main Webalizer Stats page

To view more detailed statistics, click the month for which you want to view statistics

Click the [Daily Statistics] link

This is the summary stats page for the chosen month. For more detailed stats, select from the available links

Click the [URLs] link

Let’s return to the Direct Admin page

Click the Home icon here

This is the end of the tutorial. You can return to the Site Statistics page at any time to view updated stats about your website

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 use webmail in Direct Admin

How to use WebMail in Direct Admin

Click the Webmail icon here

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

Now let’s learn how to use WebMail for accessing email from within Direct Admin

Login to Webmail using your complete POP email address, and it’s password

This is the main screen of SquirrelMail, and it shows the contents of the main inbox

Click the Options link

Click the Folders link

On this page there are several options for configuring the way your webmail displays for you

Although we won’t do it now, feel free to alter any of these options:

Personal Information

Display Preferences

Message Highlighting

Folder Preferences

Index Order

Let’s create a new folder…. enter the new folder name here

Then click Create

From this page you can create or delete folders and sub-folders, which is a convenient way to help organize your email messages

To see our new folder in the folder’s list, click refresh folder list

Click the Addresses link

There’s the new folder we just created!

You can create as many folders and sub-folders as you like….. whatever makes it easier for you to organize all your emails

Scroll down…

SquirrelMail comes with a Personal Address Book which you can use to store commonly used email addresses

Let’s go ahead and add an email address to the address book

When finished, click the Add address button

Let’s delete an address from the address book…..

The new address has been added to the address book, and can be seen here

Now let’s send an email… click Compose

To choose an address from our address book, click the Addresses button here

Let’s select this address to send a message To

Now fill in the rest of the details

The email address is automatically inserted into the To field

Scroll down…

Click the Send button

Click the INBOX.Sent link to see the message we just sent

The message has been sent!

Now go back to the INBOX

There it is!

Let’s delete this message

Now let’s move this message to the Temp Folder we created earlier

Click Move

Let’s go see if it’s there…. click Temp Folder

The message has been moved to the Temp Folder

When finished with webmail, you should always click the Sign Out link

There it is!

This is the end of the tutorial. You should now have an understanding of how to use Webmail from within Direct Admin

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