- Knowledge Base -
(This is a continuing "Work In Progress" as new questions are asked.)
Just click on the Subtopic below for the answer; click it again to go back to this list!
Special Note; Why you should Always create secure passwords.
We do everything in our power to protect our server and your websites. You can help by making sure that any passwords you create for your email accounts, forums, databases, etc. are difficult for hackers to decipher. Use at least eight random alphanumeric characters and alternate between upper and lower case letters. Avoid using actual dictionary words and never use personal information such as names, dates etc. It is best not to use the same password for different logins (your account, databases, forums, etc.) as well.
How do I access my Control Panel?
Complete getting started information is in your welcome letter. If you lost it, or if you have forgotten your login
information, just email us. Remember that user names and passwords are case sensitive!
What Is a SSL Certificate - do I need one?
SSL Certificates are only needed when you have a valid reason, like collecting sensitive information on your website, when you have your own credit card merchant account. You don't need one if you are using a third party provider like 2Checkout.com
or PayPal. If you will be using your own merchant account, we can provide the SSL Certificate, a static IP, installation. You can buy your certificate elsewhere, but we will need to install it and provide a static IP for it on our server. Ask for a quote.
How do I request a static ip?
Just email us and explain why you feel you need one. Getting more IPs per server gets harder and harder. I don't think anyone is going to get a straight answer as to why they are so limited, but the fact is, they are and that is why they are expensive and so judiciously distributed according to valid needs, such as for SSL Certificates as described above.
Search engines care about website content; having a domain name is also preferable for some search engines, but a unique IP certainly is not something that should affect your search engine standing. They block by domain name, not IP, in case of abuse. Very rarely would any even consider banning by IPs as they are well aware how virtual hosting works.
How can I change my account password?
To change your domain password in CPanel: Click on the Change Password link in the Account Settings area.
Enter your current password in the Old Password field.
Enter your new password in the New Password and New Password
Click on the "Change your password now!" button. Your password
has now been changed.
What are the Error Pages listed in the CPanel?
The error pages are pages that will show up if an
incorrect request by a web page viewer has been made. If you create
a custom error page, then users will see your custom error page
instead of the default error page. You can customise your error
pages to match the look of your site, add links to your pages, or
anything else you can do on an html page. Note: Your page needs to be about 11kb or more.
400 - Bad Request
401 - Authorization Required
403 - Forbidden
404 - Page Not Found
500 - Internal Server Error
What is the Raw Access Log?
The Raw Access Log allows you to download your Apache Log File in .gz format. This will allow you to see all access entries to your page. Access Logs are normally cleared once a month.
Where can I find More Information about CPanel features?
Some of the CPanel styles have a "Documentation" text link you can click on, or you can go
for the CPanel docs. Also, there is an the excellent
"The Unofficial cPanel Guide Tutorial"
, written and shared by Mike Bowden.
Important: eMail will not work until your domain name has resolved
to our nameservers for your new hosting account.
How can I read my email online?
To read your email online, type http://www.yourdomain.com/webmail into the browser address window. Input your FULL email address for the user name (emailName@yourDomain.com) and your password for that email account.
To access Webmail from within your CPanel control panel:
Click on the Mail icon.
Click on the Add/Remove Accounts link
Click on the Read Webmail link, next to the account that you want to read.
How do I add a new email account?
Important Security Note: It is strongly advised that you do NOT use the Default email box, as it is NOT intended for actual use. It IS intended to be a "catch-all" for unrouted (spam) mail. You need to create new email addresses for your active mail use. If you must use the Default email, then security can not be as effective and you'll have to put up with the junk mail.Go to your CPanel control panel ( http://yourdomain.com/cpanel/ )
Click on the Manage Accounts link in the eMail area.
Click on the Add Account link.
Enter the first part of the email address and the password for
the account in Email and Password fields.
Click on the "Create" button.
How do I setup Spam Assassin and other email security measures?
Set up your email security precautions. This was probably already done, except for setting any forwarding,
when your hosting account was created. If so, no need to change it at all, but always check be sure:
1. Click on Mail icon in your CPanel. You will be taken to the Mail Manager Main Menu screen.
2. Click on "Default Address"; if it does not say ":blackhole:" in the box, click on the
"Set Default Address" link at bottom of page. Then type exactly (without the quotation marks)
":blackhole:" in the empty box; click "Change". Do NOT set this to ":fail:" because that will put
more load on server resources, by having to return to sender... which is not even a real adddress most of the time.
3. Click on Spam Assassin.
4. Click on Enable Spam Assassin.
5. Once cPanel indicates the change was processed, click on Go_Back link to go
back to Spam Assassin menu screen.
6. Click on Configure Spam Assassin. You will be taken to the Spam Assassin
7. Change rewrite_subject to 1
8. Click on Save.
9. Once cPanel indicates the change was processed, click on Go_Back link to go
back to Spam Assassin Menu screen.
10. Click on Go_Back again. You should now be back at the Mail Manager Main
11. Click on E-mail Filtering.
12. Click on Add_Filter. You will be taken to the Add Filter screen.
13. Type Yes in the empty box. Select "Spam Assassin Spam Header" and "begins with" .
14. Click on Activate.
15. Once cPanel indicates the filter was added, click on the Go_Back link to go back
to the Filter Maintenance screen.
16. Log out of cPanel.
What else can I do to reduce the amount of spam email I get?
1. NEVER click on an "unsubscribe" link on spam. That only serves to confirm that someone actually reads the spam they send you...and they will then sell your email address to other spammers.
2. If your email address is on your website, you might want to change to an encrypted address or using a PHP form for contact. Spammers harvest email addresses using a spider program. The spider searches websites and gathers any email address it can find.
3. If you participate in newsgroups / usenet, do NOT use your email address in the reply to field of your newsreader. Again, spammers harvest these groups for valid email addresses.
Is there a mailbox storage limit?
You can set the mailbox storage space and limit in CPanel. Remember that stored email uses part of your web space allotment.
What is my SMTP server? What is my POP server?
Your SMTP server is mail.yourdomain.com and your POP server is mail.yourdomain.com
SMTP settings MAY need to be set to match your ISP SMTP setting if mail.yourdomain.com does not seem to work.
I forgot an email password - Can I change my email account passwords?
You can change the password on any of your email accounts whenever required. It is useful to occasionally do this to maximize your email security. You should always change your password if you think someone else has access to your account. You can log into your control panel at http://yourdomain.com:2082/ and click on the "Mail" icon. Click on Add/Remove accounts. There is a feature to easily change the password on the email account.
What is the CPanel email Auto Responder used for?
It is widely used for "away" messages, or to let people know you received their message. But it can also send them a sales message. It just depends on what message you have set it up to send as an automatic reply when receiving an email.
What is E-mail Forwarding and how can i use it?
You can forward email sent to an addresss to another address or to multiple addresses. You can look more professional by creating separate department addresses for a business and forwarding all of their emails to one or more other boxes which can then filter and organize based on those addresses. You can forward mail to an external address at another host or ISP, and it can be handy to forward mail to another person while you are on vacation as well. Set forwards up in Cpanel under Mail; Forwarders.
To forward to multiple addresses, use a comma to separate the addresses.
What is an MX Record?
"Modify Mail Exchanger" (MX Entry) Do Not Touch This - Ask FIRST if you think you need this feature and know what it is.
(Briefly: The MX Record is used to control where email sent to your domain will go. Usually it is not necessary to modify this record. Occasionally it is necessary to host a web site with one network, but have an email hosted somewhere else.)
To be more specific, if you NEED this information:
Modifying an MX record MX Records (or mail exchange records) are special server settings that help to control the routing of your email.
By default, your email is currently routed through our server. If you wish to route your mail to a different provider, outside your hosting account, you may do so by choosing "Modify Mail Exchanger" from your Mail Manager menu, and moving to the "Change an MX Entry" section of your account. Here, you'll be prompted to enter the domain to which you'd like to give control of your email. NOTE: You must enter a valid hostname here and NOT an IP address.
VERY IMPORTANT: Once you've directed your mail to a server outside control of our server, you will NOT be able to control your mail from this hosting account.
This means if you have multiple email addresses, forwarders, autoresponders, and mailing lists, they will no longer be configurable through your CPanel Control Panel.
Help! My eMail Isn't Working!
If you have recently started having trouble sending email from your account hosted with us:
1. Make sure you have "SMTP authentication" (sometimes called "my server requires authentication") enabled in your email program. This has always been a requirement, but has recently started being strictly enforced. You may have previously been able to send without it.
IMPORTANT: SMTP authentication is NOT the same as SSL (Secure Sockets Layer), or SPA (Secure Password Authentication). Neither of those settings should be enabled.
If you currently have a 'login' of the form user+domain.com set, change that to email@example.com, or, if your email program won't allow you to set a login containing a "@", use user%domain.com
2. Most ISPs are now blocking Port 25. Most email programs are automatically setup with Port 25 set as the default. If you are unable to send email, and get an error related to 'unable to connect', change the default Port 25 to Port 587 in your email program. If you are unsure how to do that, consult the documentation and technical support guides for your email program.
These settings apply if you are using either your domain 'YOUR_DOMAIN_NAME.com' or 'mail.YOUR_DOMAIN_NAME.COM' as your Outgoing/SMTP server. If you use a server provided by your ISP, contact them for assistance sending email.
1. 'SMTP Authentication' must be enabled (but *NOT* "Use Secure Password Authentication")
2. Do *not* use a "+" in your username/login - if you have one replace it with @ or %
3. Use port 587 for SMTP instead of port 25 (Do not change POP - leave it set at 110)
I want to use Netscape Mail - How do I set it up?
Please see the tutorial on setting up Netscape Mail Here
I want to use Outlook - How do I set it up?
Please see the tutorial on setting up Outlook Mail Here
I want to use Outlook Express - How do I set it up?
Please see the tutorial on setting up Outlook Express Mail Here
I want to use Mozilla Mail - How do I set it up?
Please see the tutorial on setting up Mail Here
I want to use Yahoo Mail - How do I set it up?
eMail Note: CPanel mail is what we provide with our hosting services. We do offer
some TUTs here for setting up several outside mail programs as a courtesy. But this information may not
always be current or answer your specific problem. If you need more information, you'll need to
contact your ISP or your chosen email program vendor for further help.
Please see the tutorial on setting up Yahoo Mail Here
Where can I get a Domain Name?
From our domain sales site
, of course! :) We can also be more helpful if you need it. We can manage it for you too. The domain names you buy are YOURS. If you ever decide to move to another host, you simply change from our nameservers to the new host's nameservers.
My domain is registered via another registrar. Can I transfer it to you?
Yes, and we honor the time you've already paid your old registrar for. Plus, we add a free year to it Here
You can get full details there as well.
How do I get my domain to work?
Your domain will not work until you have pointed it to the our nameservers and it has propagated across the internet. This is done at your domain name registrar, using the nameservers listed in your Welcome letter.
What is domain name propagation?
Propagation is the time it takes to send your domain's address information to servers all over the world on the internet. It can take anywhere from a few hours to 72 hours or more to FULLY propagate, or "resolve" as it is often referred to.
Can I change to a different domain name for my hosting account?
Yes we can do that for you; just send an email with the "Contact" button above, telling us your new domain name you wish to use and the one you are replacing with it.
What is Domain Parking?
Domain Parking is adding additional domain name(s) that you own to a hosting account with all of the domain names resolving to the account's index page.
What is domain pointing?
It takes domain parking a step further, when multiple domains resolve to different index pages or directories on the same hosting account. Domain pointing is often used if someone wanted to maintain 2 or more very different web sites, within the public_html directory, of the web space/bandwidth allotment of their main site.
Creating Your Website
How do I create my web site? Do You Provide a Store Builder?
CPanel has the Agora store builder/shopping cart and there is the Fantastico advanced php store builder/shopping cart (OSCommerce). You can manage your website with the many features in File Manager if you like... you can create and/or edit pages with the Editor programs; set permissions (chmod) for files and Folders, create or delete files and folders, and upload files as well.
How to do most everything is usually obvious, or look for help links, as in the WYSIWYG editor. If you want to open a folder, you double click on the folder itself. If you want to take some action with a folder (or a file), such as edit, set permissions, etc., you click on the text beside the folder or file icon. Look to the upper right after you've selected a folder or file to see the actions you can take.
Or you can use any website building program and just upload your site to the public_html directory if it has a compatible upload feature. If not, you can always upload it to your web space on our server with one of many FTP programs. Always upload your web pages into the public_html directory or your website will not work!
Naming your pages, file folders, images, etc.:
You'll have less problems if you always use lower case letters and a _ where a space needs to be. Page and folder names are case-sensitive, so if you use any capital letters, you must make sure that your links match exactly, or the page or images won't show up online.
Your most important page is your index (home) page:
You must name it index.html or index.htm (or index.php, index.cgi, index.pl,etc.). When a visitor types http://your_domain.com into their browser address window, it will look for index.html, then index.htm. You can name your other pages anything you like.
What forms can I use - where can I find "email harvester-proof" forms with a Tutorial?
Free Secure Forms For Your Website Needs, spam-stop tips, safer newsletter mailings and email address encoder:
These forms replace the risky Form Mail that we don't allow on our server. We have modified these forms especially for our clients, with full instructions included. They are safer forms that help protect you and the server against spam bots and make hacker compromising more difficult.
One is a simple form for quick customer interaction and the other is a more elaborate form that allows many adaptations to acommodate what you need a form to do.
The email encoder is an easy little code that you use in place of your email address in your "mailto:" links. Nothing is 100% effective or "forever", as email harvesters keep getting more sophisticated. We will always do our best to keep you informed here of the updates we locate for you. It is all included in a handy downloadable zip file!
Click Here To Download the Forms, email code, etc.
How Can I create a subdomain?
You can not create a subdomain until your domain has propagated across the internet. Click on the Sub Domains icon in the Account Settings area.
Enter the text for the new subdomain in the field in the
Click on the "Add" button. Click on the Subdomains icon again to
return to the Subdomains window to confirm that it has been added. A
folder with the same name as the subdomain has now been added to
your public_html folder, with a cgi-bin sub-folder inside it, ready for your subdomain files.
How can I password protect a directory?
To password protect a directory:
Click on the Password Protect icon in the Account Settings area.
Navigate to the directory that you want to protect. Select a
folder by clicking on the folder name link, or open a folder by
clicking on the folder icon.
Click on the check box next to the icon.
Enter the name that you want to appear in the Protected Resource
Name field. This name is optional and purely for your benefit.
Click on the "Save" button.
What is DHTML?
Do I have to use www. in my web address (URL)?
Your visitors can access your main page and all pages on your account either with http://yourdomain.com or http://www.yourdomain.com. At first, it may be accessible with the .www in the address, but not with the http://domain.com address. This is usually because the ISP has not caught up with the DNS, but this seems to work itself out within a day or two.
Where should I upload my web site files?
Always upload into the public-html directory or your website will not work!
The public_html folder is the top level of your domain's directory tree, your root web space directory. All the files that you want visitors to see must be put inside it. You can create as many subdirectories within that folder as you need/want there. You could upload a file named "image2.gif" to your public_html directory and it would be viewable online using the URL http://yourdomain.com/image2.gif
Do you make a backup copy of my website?
No we do not do that. But there is an excellent backup utility in your Cpanel control panel. Please use it frequently, as you are responsible for your own website, even if there should be a server problem. While we do not forsee any such events, this IS the internet and everything is not always under our control. There is nothing to worry about if you are diligent about using the backup utility that is provided for your convenience and peace of mind.
To back up your website files, log into your control panel and click the "Backup" link. There you may choose to download a compressed file of "Today's Home Backup", which contains the folders and files in your home directory. You can also download an .sql file of any or all of your databases in use. Do NOT try to open the backup files with a file compression utility (WinZip, ZipMagic, Stuffit, etc.). Just save them somewhere on your hard drive, in case you ever need to use them to restore lost or corrupted files.
Uploading with FTP - CPanel - Front Page - Dreamweaver
I didn't upload yet - What are these files and folders in my account?
The first time you log in to your CPanel File Manager or FTP, you'll see some files and directories.
DO NOT DELETE OR RENAME any of these files or directories (except the default index.html or index.htm, when you're ready to upload your website). ALL the rest are automatically setup by the system and are needed for your account to function properly. Deleting or renaming any of them will cause fatal errors that can only be repaired by deleting and resetting your account. That willl cause you to experience DNS problems. DNS problems are not something that can be manually fixed, as they can only work themselves out in an unpredictable amount of time.
As you add features from your Control Panel, the system will automatically create other files or directories. ALL sub-directories and/or files created by the system are needed to make a particular function operate and SHOULD NOT BE DELETED OR ALTERED IN ANY WAY.
Uploading with CPanel
Go to your Cpanel and click on the "File Manager" icon.
Double-click on the "public_html" file folder. (If uploading to a subdirectory, open it now.)
Click on the "Upload file(s)" link. (Now you should see a group of "browse" buttons.
Click on the "Browse" buttons to locate the files (on your hard drive) that you want to upload.
Click on the "upload" button.
Repeat this process until all your files are uploaded.
Uploading with WSftp Pro, LE (similar programs, Cute ftp, etc. need this information)
Profile Name: Any name you like
Host Name/Address: domain.com (no http:// , no .ftp and no www.)
User ID: xxxxxxxx
Check: Save password
Click on: Apply (make sure "Apply" is greyed out)
Click on: OK
How can I make an FTP account for a subdomain?
In CPanel, click the "FTP Accounts" icon. Follow the directions to create a FTP account with the same name as the existing subdomain. Example: If your subdomain is "books.yourdomain.com," create an account with the username "books". Upload to it with CPanel File Manager or enter the new details into your outside FTP program.
What is Anonymous FTP and how do I use it?
Anonymous FTP allows you and others that you give permission to, to access your "public_ftp" folder. You can allow this type of access in one of two ways:
1. ftp://ftp.yourdomain.com --This allows others to view, delete, upload and download files directly into your "public_ftp" folder.
2. ftp://ftp.yourdomain.com/incoming --This allows others to upload, view, delete, and download files located only within the public_ftp/incoming folder of your hosting account.
To manage control of your Anonymous FTP settings, login to your CPanel Control Panel and click the "FTP Manager" icon, followed by the "FTP Controls" link. Here, you will be able to allow or disallow anonymous access to your hosting account, as well as set up welcome messages for your anonymous FTP users.
The login to use when using anon FTP is "firstname.lastname@example.org"
How do I upload with Front Page?
You can not upload with Fromt Page until your domain has propagated across the internet.
Although we provide Front Page extensions as a courtesy, we don't use Front Page. You should consult your manual or perhaps these links will be helpful:
How do I upload with Dreamweaver?
This information is courtesy of Dreamweaver users:
Once the site is created in Dreamweaver and ready for uploading, all you have to do is to upload it to the public_html directory on your account with FTP. You can initiate the FTP transfer directly through Dreamweaver. Setup the Remote Information for your site within Dreamweaver:
1. Choose Site > Edit Sites (or Define Sites)
2. Choose the site to be uploaded - Click Edit
3. If prompted, choose Advanced
4. In the Category list select Remote Info
5. Pull down the Access drop-down menu and choose FTP
6. In the FTP Host field type ftp.yourdomain.com
7. In the Host Directory box type public_html/
8. In the Login field type your hosting account username
9. In the Password field type your account password
10. Check the "Save" box (leave the other boxes such as "Use Firewall", "Use Passive FTP" etc unchecked)
11. Click OK - Click Done
A Forum Post On Uploading Dreamweaver Created Websites:
In DWmx go to top tool bar; windows; server behaviors; site and a wizard appears, this will ask you for your domain name address, user name, passwd, mode and then where you want the pages placed, root, sub domain or a folder. Then it asks where you want your local files stored, ie desktop>mynewsite. It is straightforward for creating a html page. You can aslo set the time out, reconnect, load each change, load after site is complketew, load a back up etc.
Setting up ftp, asp, php etc pages is similar.
Having said all that, it is still eassier to connect manually thru ws_ftp or whatever. DW doing automagically is great but it does it at each save or when told to connect and slows DW down to a crawl and DW mx is a hog ( a nice hog) already. So, I personally don't use the connect feature. If doing it manually set up your local file folders as they will be on your server, ie assets folder, image folder, code folder etc., then your links will be correct when you load it. If DW does it for you all links will be correct as it will create folders for you on the remote ftp side.
I uploaded my pages. Why can't I see my website online?
It can take from a few hours to 72 hours or more for your domain name to propagate across the internet. Make sure you upload to your public_html directory.
When your domain name has resolved to our nameservers, your site will show our temporary page, index.html. If your index page is also named index.html, it will overwrite our page and yours will show online (if you have uploaded your pages to the public_html directory). If your page is named index.htm, index.php, etc., you will either need to rename your index page to index.html OR delete our temporary page.
Also, we have seen cases where propagaton has completed, yet the website does not immediately appear, or may appear sparodically at first. Or, it may be accessible with the www in the address, but not with the http://domain.com address. This is usually because the ISP has not caught up with the DNS, but in every case, this seems to have worked itself out within a day or two.
How can I tell if I am seeing my site here or at my old web host?
If you have not removed your website from your old host yet and have uploaded it here also, you should use a temporary index page here that is different in some way... it can be just a hardly noticable thing, maybe a small dot added somewhere on the page. After your domain name has resolved, just replace it with the correct index page (or remove the temporary dot) and safely delete the website at your old host.
My Forms worked fine at my old web space, why don't they work here?
You may need to reconfigure them, as they may be calling needed files from your old web space instead of from your new web space here. If it is a FormMail processor, it needs to be replaced with a PHP processor, which will hide your email address from the "email harvesters" on the net.. Free PHP form processors are available at http;//hotscripts.com and similar websites. Verify that the script is configured correctly and make sure that it was uploaded in ASCII transfer mode (if uploading using an FTP client). If you continue to have trouble, contact the script developer, or your software vendor for assistance.
What is the path to my home (root) directory?
/home/username/public_html/ Replace username with the username for your domain account.
What is the path to my Web Accessible Folder?
/home/USERNAME/public_html/ , Replace USERNAME with your login name
What is the path to Sendmail?
What is the path to my cgi-bin directory?
What is the path to my subdomain's cgi-bin?
/home/USERNAME/public_html/SUBDOMAIN/cgi-bin , Replace USERNAME with your login name, and SUBDOMAIN with the SUBDOMAIN.domain.com part of the subdomain
What is the path to Perl?
What Perl Modules Are Installed?
Look on the left side of your control panel for "Installed Perl Modules Click to View", to see a list of perl modules installed.
Where do I put my Perl scripts?
Perl scripts (*.pl, *.cgi files) can be executed from any location within your public_html directory. There are few minor benefits in storing Perl scripts within the cgi-bin directory, but doing so is strictly optional. Possible benefits of storing Perl scripts in cgi-bin - As /cgi-bin is a common default location used to store Perl scripts, many free scripts will be setup to run in that path by default; Front Page users should note that storing scripts in cgi-bin will decrease any chance of FrontPage making unwanted permission setting changes.
PHP - MySQL - Databases
What is PHP?
PHP is a server-side HTML embedded scripting language used to create scripts and/or Web pages. In a HTML document, a PHP script is enclosed with special PHP tags. Because PHP is executed on the server, the client cannot view the PHP code. PHP can perform any task that any CGI program can do, but strength lies in the compatibility with many types of databases. PHP can talk across networks using IMAP, SNMP, NNTP, POP3, or HTTP.
What extensions do I use for PHP?
You can use .php, .php3 .phtml, .php4
Why do I get a PHP 500 Error?
Normallly, the permissions on php files should be 644 and the permissions on folders containing php files should be at 755 setting. You can check the error logs in the stats section of your control panel to see what the exact problem is.
What should I put for the MySQL host name?
You would use localhost
How do I create a new database?
To create a new database, log into your control panel and click the "Manage Mysql" link. You will see a textbox labeled "Db:" there. Type a name for your database in the box and click the "Add DB" button next to it. You will then see a message confirming that your database has been created. Click the "Back" link below the message to continue. You will need to "Add a user" to your database before it will be accessible to you.
How do I Add a user to my new database?
To "Add a user", log into your control panel and click the "Manage MySQL" link. You will see a section of the page labeled "Users", and below it, two textboxes labeled "UserName:" and "Password:". Type your chosen username and password into the boxes and click the "Add User" button. You will see a message confirming that the new user has been added. Click the "Back" link to continue managing your MySQL database(s).
How do I add a NEW user to my database?
To add a new user to your database, log into your control panel and click the "Manage MySQL" link. You will see a pair of dropmenu's there, labeled "User:" and "DB:". Choose the user you want to give access to the database, and the name of the database you want to give them access to. Then click the "Add User to DB" button. You will get a message confirming that the chosen user has been added to the chosen database.
My database name has added username_ to it - do I use that in my scripts?
USERNAME_ will be added to your database name and database username. You will need to use the full USERNAME_dbname and USERNAME_dbusername in your scripts in order to make a database connection. (Replace USERNAME with you actual account username)
How do I upload a mysqldump of my database
1. Create a database in your CPanel.
2. Go into my phpadmin and select the database you just created.
3. Click the SQL tab.
4. See "Or Location of the textfile - Click browse to find the mysqldump file on your computer then click go.
How do I Connect to MySQL with PHP?
Here's how to connect and begin querying the MySQL server from within your PHP scripts:
1. Connect to the MySQL server: Use this statement to connect to the database server. Replace the username and password with the ones who were created in the MyAdmin interface and have given adequate permissions to this database:
2. Select Your Database: Use this statement to select the database you wish to connect to. Make sure you replace with your database name.
3. Executing A Query: Now you can execute your queries. Remember that the databases and users used must be created in the MyAdmin of your CPanel. Most problems that arise with scripts are because of incorrect permission settings.
Troubleshooting "Cannot connect to the database" errors - Here are a few common mistakes:
a. Make sure that you didn't forget to ADD the database user to the database after you created your database and database user. (at the bottom of the "Databases" section in Control Panel - MySQL Manager, there are two drop down menus, "User:" and "DB:" then an "Add User to DB" button).
b. Check that you entered localhost as the database host/server name and if applicable, that you specified mysql for the database server type.
c. Check that you specified the correct database and database user names. Remember that these are case sensitive and that your account userid (usually the first 7 characters of your domain name) is added with an underscore as a prefix to both your database and database user names (userid_dbname rather than just dbname and userid_dbuser instead of just dbuser).
d. Make sure that you use the password that you assigned to your database user in MySQL Manager (NOT your account password). EXAMPLE:
if your domain name is "bigtestserver.com"
if your account userid is "bigtest")
if you created a database named "games2"
if you created a database user named "baker"
if you assigned user dude the password "sam"
if you added baker to the games2 database
then you would enter the following logon/connection info:
database server type = mysql
server name = localhost
database name = bigtest_games2
database user name = bigtest_baker
database user password = sam