cPanel Login

2. cPanel Login • Go to: dmdesignfirm.com/cpanel • Enter in your username and password.

3. Your Team Login Information GREEN CLEANING ALLIANCE • Domain: www.greencleaningalliance.com • Email: contact@dmdesignfirm.com • Username: alliance • Password: HCCteam1 UNCLE MIKE'S BBQ • Domain: www.unclemikesbbq.com • Email: contact@dmdesignfirm.com • Username: bbq • Password: HCCteam2 • EQUITABLE DIVORCE SOLUTIONS • Domain: www.planningfor thebest.com • Email: contact@dmdesignfirm.com • Username: solution • Password: HCCteam3 • LASTING LEGACY ANTIQUES • Domain: www.lastinglegacyantiques.com • Email: contact@dmdesignfirm.com • Username: legacy • Password: HCCteam4

5. Check Domain Information • Make sure your account is pointed to the correct domain name. If it needs to be corrected or changed, please let me know. • If the client has not chosen a domain name, you can temporarily view the site by going to dmdesignfirm.com/~(plus your cPanel username) Example: dmdesignfirm.com/~solution

6. Getting familiar with cPanel

7. Getting familiar with cPanel • cPanel has some excellent tools and tutorials to help you navigate through the program and also to make the most out of your hosting experience. • I recommend checking out some of these items:

8. Getting familiar with cPanel • Video Tutorials • You will be a pro in no time with cPanel's video tutorials. • These tutorials allow you to easily learn as you can rewind, pause, and fast forward through any of the videos. • Website Templates: • Free Flash & Non-Flash templates for you to use. • Choose from 1000’s of templates • Requires Adobe Photoshop

9. Getting familiar with cPanel • File Manager • Quickly manager all of your files with the new File Manager. • Copy, move, upload and download files with ease. • Email Accounts • Set up email accounts • Set account size and limitations • Webmail access to view emails online • Configure for other programs (ie: MS Outlook)

10. Create MySQL Database with cPanel and phpMyAdmin

11. Create MySQL Database with cPanel and phpMyAdmin • After logging into cPanel, click on the icon that says MySQL Databases

12. Create MySQL Database with cPanel and phpMyAdmin • You should now see a screen showing your mySQL information.

13. Create MySQL Database with cPanel and phpMyAdmin • We will need to create the database. • Under Create New Databases in the New Database field type the name of your database. • I will call my database “test”. • Click “Create Database”

14. Create MySQL Database with cPanel and phpMyAdmin • You will be forwarded to a screen that tells you the database was added. • Click the go back button to return to management screen.

15. Create MySQL Database with cPanel and phpMyAdmin • In order to access the data we need to add a user and give the user a password. I will call my user ‘testing’ instead of just ‘test’ to avoid confusion with the actual database. Enter the username and password and then click the ‘Create User’ button.

16. Create MySQL Database with cPanel and phpMyAdmin • You will be forwarded to a page telling that the user was added. Click the go back button to return to the previous page. • You will now see that you have a user and a database listed under ‘Add users to your database’. Now we will do just that, add the user to the database. • Select your user and your database.

17. Create MySQL Database with cPanel and phpMyAdmin • We will give the user all privileges, so check the all privileges box. • When you are finished click Make Changes. You will be forwarded again and cPanel will let you know that a user was added to the database, click the go back button.

18. Create MySQL Database with cPanel and phpMyAdmin • When you return to the Account Maintenance Screen you will now see that you have a user added to your database.

19. Create MySQL Database with cPanel and phpMyAdmin • Our database has been created successfully, but now we need to add some data. • To do this, click the Home icon in the upper left corner of your screen to go back to the main cPanel screen. • Click the phpMyAdmin Link located under the database section.

20. Create MySQL Database with cPanel and phpMyAdmin • Welcome to phpMyAdmin

21. Create MySQL Database with cPanel and phpMyAdmin • Select your database by choosing one of the options on the left hand side. In this instance, I will select “solution_test”. • You will notice that is says “No tables found in the database”. We need to add a table and some data.

22. Connecting to your database <?php mysql_connect("localhost", "solution_test1", "test1") or die("error connecting to server"); mysql_select_db("solution_test1") or die("error selecting database"); ?>

23. FTP Access • If you have downloaded an FTP program you can use it to upload and change files from the server. • Host Name/IP: Just use either the client’s domain or dmdesignfirm.com as the host name. • Username & Password: Same as your cPanel login.

24. www.coreftp.com • A free, secure FTP client that gives you a fast, easy, reliable way to update and maintain your website via FTP.  • It also provides a secure method (via SSL, TLS, or SFTP) to upload / download files to and from FTP servers.  

25. Connecting via Komodo Edit

26. QUESTIONS??? • 24/7 Support • For questions during regular business hours (Mon-Fri 10am-6pm), please call DM Design Firm • 425.298.5336 • For after hours emergency technical support, please call Hostgator with your domain name. • 1.866.96.GATOR