Transcript Creating a MySQL Database in:



Go to:
dmdesignfirm.com/cpanel
Enter in your username
and password.
GREEN CLEANING ALLIANCE

Domain: www.greencleaningalliance.com

Email: [email protected]

Username: alliance

Password: HCCteam1
EQUITABLE DIVORCE SOLUTIONS

Domain: www.planningfor thebest.com

Email: [email protected]

Username: solution

Password: HCCteam3
UNCLE MIKE'S BBQ

Domain: www.unclemikesbbq.com

Email: [email protected]

Username: bbq

Password: HCCteam2
LASTING LEGACY ANTIQUES

Domain: www.lastinglegacyantiques.com

Email: [email protected]

Username: legacy

Password: HCCteam4


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


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:

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

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)

After logging into cPanel, click on the icon that says MySQL
Databases

You should now see a
screen showing your
mySQL information.




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”


You will be forwarded to a screen that tells you the
database was added.
Click the go back button to return to management screen.

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.



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.


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.

When you return to the Account Maintenance Screen you will
now see that you have a user added to your database.



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.

Welcome to 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.
<?php
mysql_connect("localhost", "solution_test1", "test1")
or die("error connecting to server");
mysql_select_db("solution_test1")
or die("error selecting database");
?>



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.


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.


24/7 Support
For questions during regular business hours (Mon-Fri 10am6pm), 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