Posts Tagged ‘Web Hosting’

How can I change my MySQL database collation?

How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below:

1. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.

2. Select the database you wish to manage from the drop-down menu on the left

3. Click on the Operations tab in the top menu of your phpMyAdmin

4.  At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.

Please note that after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.

 

cPanel Primer For The New Webmaster

cPanel Primer For The New Webmaster

cpanel Web HostingIf you are about to purchase web Hosting, it is very likely that you will be using cPanel to manage your Hosting. To get the most from your web Hosting, you need to learn the workings of cPanel.

What Can Be Done with cPanel?

If your web Hosting doesn’t offer shell access, cPanel will be the only way to manage your web Hosting, cPanel is a web based server control software that allows you to do the following operations and a whole lot more. Common operations such as adding FTP users, creating databases, creating mail accounts and a multitude of other Hosting operations can all be performed with cPanel.

Creating Mail Addresses

If you have the domain xyz.com and you would like to create a mail address called info@xyz.com, you can perform the following. Firstly click on the Mail tab from the front page. There you will see options to create, modify or delete mail accounts. If you to forward mail to an existing account here you can set an address to forward to the account of your choosing. To read emails access the Web mail tab from the front page

Managing your domains

You may want more than a single address directed towards one web site, for example if you owned xyz.com and xyz.net, this can be achieved by using the Parked Domains tab, here you can type any address that you own to point to one of your web sites. If you Hosting provider allows you to have more than one web site on your account, you can add domains via the Addon Domains tab. If you Hosting provider supports the creation of sub domains you can create these via the Sub Domain tab.

FTP Options

You can create additional FTP users, set their access levels and other FTP related tasks using the FTP tab.

Database Tasks

To create a new database, or modify existing databases use the Database tab. Here you can perform all allowed database tasks, to perform more advanced database operations you will need to use phpMyAdmin, this can also be accessed from the Database tab.

Analyze The Logs

When running a web site you need to know what your visitors like, where they are coming from, which search engines are bringing the most visitors and all other data about them. Normally you will have access to the raw log files, but these are hard to analyze, to see data that is formatted about your visitors in an easy to read way go to Web/FTP Stats, here you will have the option to review your sites statistics using a variety of software such as Webalizer or AWStats.

Fantastico

Most if not all cPanel installations these days come with Fantastico which is an auto installer for many php based scripts. Fantastico can be used to install popular php scripts such as WordPress, Mambo, phpbb and many other php products. Using Fantastico is the easiest way to setup these php based scripts and will save you having to manually upload the scripts, and more often than not Fantastico will do all the configuration of the script for you which is a real time saver.

Final Words

cPanel is a very advanced application for configuring your Hosting and learning all the tricks can take some time, but hopefully with this guide you will have the basics down and you can progress from here as your experience with web Hosting increases.

cPanel Primer For The New Webmaster