Due to some errors you can face few occasions when you become unable to login in to your wordpress account, so it becomes difficult to handle the plugins installed on it. Following is the procedure which allow you to handle your plugins without logging into wordpress dashboard.

Login to your website hosting server via FTP and change the names of folders of all plugins, for making things simple you can just add single character of your choice to these names. If the error is more critical and deactivating your plugins is not enough then its recommended to switch to the default theme. You can do this by changing the name of your currently installed theme as this will activate the default theme automatically.

As most of us know the importance of .htaccess file for a web hosting account, here you can know one of the most useful utility of this file. It’s possible to block users or website which are causing for any malicious activities on your website. This utility not only make your website more secured but also saves your money which is needed to install any third party security software within your web hosting account.

The Apache module ‘mod_rewrite’ is needed when you want to block the access of your website by referrer in .htaccess. In most of hosting plans of Web Hosting India, this module comes as inbuild with any particular web hosting package. This module help you to deny access to all the traffic which is coming from a particular domain (IP)

Following is the way to Block traffic from a single referrer

RewriteEngine on
# Options +FollowSymlinks
RewriteCond %{HTTP_REFERER} suspecteddomain\.com [NC]
RewriteRule .* – [F]

Following is the way to block traffic from multiple referrers

RewriteEngine on
# Options +FollowSymlinks
RewriteCond %{HTTP_REFERER} suspecteddomain\.com [NC,OR]
RewriteCond %{HTTP_REFERER} anothersuspecteddomain\.com
RewriteRule .* – [F]

SSH keys are the great utility for cPanel shared hosting clients. These SSH keys play important role while allowing a specific computer system to access your website’s information through a SSH session.

Find the ‘Generate a new Key and Import Key links and follow the following the steps.

• Click the ‘Generate a new key icon.
• Fill all the required information properly. This is to be done by keeping in mind your requirements as RSA keys creates a faster confirmation of identity and DSA keys are known for fast key generation and signing times.
• Choose a key size using the pull-down menu. While doing this you should know that a bigger key size provides more security but will take more time for authentication. So you need to decided the proper combination of security level and time consumed for authentication.
• Click on Generate Key for the generation of new SSH key and it will get automatically installed on the web server.

When you have a cPanel shared hosting account for your website then this is the utility which makes you able to provide the email addresses at which you want to receive all the updates and messages from your web hosting server. These provided email addresses works as the main communication point with you and used for informing you any new information about your website and its updates. It is always recommended to use an email address which is not of your website, because it will not face any problem when your website’s emails would stop working.

Have look at the following steps for configuring these preferences.

• In the first text field you should enter the email address which you would like to be used while making contact from web server to you.
• Second text box is provided for entering other optional extra email if first email failed to receive the messages.
• Here you will find 3 check boxes which will decide when server should contact you by sending the email. Following are their descriptions.

1. Your disk quota is almost full :- When your website is close to reach the maximum disk space provided to it then it may cause for failure in modifying the current files and addition of any new files to the website, after receiving this message you need to delete any unwanted old files or upgrade your hosting account with more disk space.
2. Your bandwidth is reaching its limit :- When your website is visited a large number of visitors than normally expected then you face bandwidth issue. Similar to disk space, bandwidth is the resource which is provided with certain limitation for your website, and if it exceeded than the provided limitation then your website will not remain accessible anymore. This type of the problem occurs mostly at month ends and to fix it you need to upgrade your web hosting account with more bandwidth resource.
3. Your email accounts approach the quota :- This notification shows that email address provided by you are about to reach to their maximum limitation of the disk space allocated to it. For resolving this issue you need to delete any unnecessary mails of upgrade your account with more disk space.

• Remember to click ‘Save’ for confirming any changes made by you.

As many of us may know the importance of .htpasswd file while configuring the .htaccess file as it contains all the usernames and passwords of those people who should be grant access to the directories and subdirectories of a particular website.

It is necessary to telnet in to your web hosting server before creating this file.

Go into the directoy and using cd command, you can specify your ‘AuthUserFile’ (/var/www/html/private/)

Type htpasswd -c .htpasswd username for creating the .htpasswd file and adding username to the list which contains users to be authorised for accessing the directory and subdirectories. This program will automatically as you for a password and later on its verification also. Refer to follosing window.

[root@www /root]# cd /var/www/html/private/

[root@www private]# htpasswd -c .htpasswd username

New Password:

Re-type new password:

Adding Password for user username

[root@angles private]#

For adding new user you can use the same command without ‘-c’ switch.(For adding user ‘User1008′ type htpasswd .htpasswd User1008. )

For deleting user you should open .htpasswd file and by using any unix editor you can use dlete the row related with that particular user to be removed.

username:User1008

User1008:dljksjfh.

admin:gjhgdfjsga

Following are few reasons for getting a web server down because of getting overload.

• When heavy legitimate traffic hits within the short time interval may cause to get a web hosting server overloaded.
• Interrupted Denial of service attacks.
• There are few computer worms which may cause for infinate traffic, as they makes larger number of computer infected hence can not coordinate among network.
• XSS viruses are the type of viruses which infect browsers and server on a very large scale.
• Unfiltered traffic and uncontrolled bots from search engines and other websites to the websites which are using very limited resources, also causes to Server functionality.
• Server limits are also reached because of slow internet connections which causes for slow service to client’s requests the result of which multiple connection and requests are saturated in short time-span.
• Unplanned immediate maintenance or upgrades of a server need to shift the current load on another server which may make it overloaded.

Following are the guidelines I would like to share with website hosting clients who are going to host there blog or website as based on a wordpress. Find out the following in the downloaded and unzipped the WordPress program on your computer and edit it as I am placing the instruction under each of it.

// ** MySQL settings - You can get this info from your web host ** //

/** The name of the database for WordPress */
define(‘DB_NAME’, ‘putyourdbnamehere’);

Replace your desired domain name with putyourdbnamehere


/** MySQL database username */
define('DB_USER', 'usernamehere');

Replace your desired username name with usernamehere

/** MySQL database password */
define('DB_PASSWORD', 'yourpasswordhere');

Replace your desired password name with yourpasswordhere

/** MySQL hostname */
define('DB_HOST', 'localhost');

There is no need to change localhost unless any specific requirement.

Let the web hosting account be of any type either Windows Web Hosting or Linux Hosting, MySQL supports to both type of web hosting services and is very  popular as a database. The websites which has large data in their MySQL databases are supposed to be optimize it which enable them for enhanced collation of data and indexing. When the number of cases of slow speed of database, queries, rise in backlogs and user unable to connect the database then you can know that you need to optimize your database as soon as possible. Then main causes behind this are non existed or improperly defined indexes. Common people can sort out these causes and tries for some other solutions like implementation of any other costly system but by fixing these small issues one can feel great improvisation in website functioning.

Following is the example I would like to share to get a brief idea of the above discussed issues.

Suppose there is a table ‘emp’ with three different fields as following

emp_code, emp_name, emp_age

For finding the information of an employee the query is written as following

SELECT * FROM from ‘emp’ where emp_code is = 3;

Now the above query will be performed for finding the all records of the employee who has been assigned code as 3, but lets imagine if the number of records existed in the table are in billions then the same query will have to through each record for matching the given condition and the execution of that particular query will need more time.

To avoid the above long time process you need to create an Index. As you have a separate field created as emp_code an index would be a separate file which contains the only records you have inserted in a particular field in sorted manner. If you creates an index for emp_code the MySQL search query is able to find the given record very fast. Indexation causes to sort and search the records at an amazing speed. Here index works very similarly to an Index you know in a book.

Here is the process of changing a database engine of MySQL table.

Suppose the table name is my_table which resided in your database and it uses MyEng engine which you want to change as myDB.

• Login into your website hosting account

• Open your phpMyAdmin tools and click on the database which contains my_table (the table of which you want to change the engine).

• Click on the SQL tab and type the following query int it.

ALTER TABLE my_table ENGINE = InnoDB;

• Click on the go button to run the query.

• Its finished and this is the quickest way to change your required table’s engine.

In wp-admin for retrieving password one need to click on ‘Lost your password?’ which appears at login screen. After clicking it you will have to enter either your username or e-mail ID which is verified in wordpress database and if found then new password is forwarded to your email address which you used for registration.

As the above procedure is a little bit lengthy and time consuming one there is another one method can be used for the same. By using particular instances you can access admin area. By using phpMyAdmin which is a utility provided with cPanel Hosting package, one can manage his wordpress database. After accessing the phpMyAdmin it is necessary to select the database which is used by your website. Click on that database and you will find multiple table inside it. Find SQL tab which is located at the top of the navigation bar. You need to type following SQL query in the field available.

UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password‘ ) WHERE `wp_users`.`user_login` = “your_username”

Replace ‘new_password‘ and “your_username” in the above query with your desired new desired password and your username respectively. After you typed the query accurately, click on the GO tab, this will submit your query. If you have done the above work successfully then you should be able to login in to your wordpress admin area.

phpBB is a very popular application among the webmasters, specially those who run forums on their websites.

Free of cost – Having a base of php and licensed under GNU (GPL) open-source license phpBB is popular all over the world.

Supportive – It supports a number of databases, including MySQL, PostgreSQL, MS SQL Server, and MS Access. phpBB is a feature-rich BBS, discussion-board application which is also easy to install, deploy, and maintain.

Easy Availability and Easy Installation – phpBB’s latest version is widely available on all over the internet but its always good to download it from the official website (www.phpbb.com), here it is available in both tarball and zip file format. One just need to download this file and decompress the archive, keep it on your web hosting server and set up the database as required. For installing it you will have to follow the guidelines of method you are using for installation. If you are doing it from cPanel hosting account using softaculous then you can get the help from following link

http://www.host.co.in/knowledgebase/how-install-phpbb-from-cpanel

Styles – By default phpBB provides ‘subsilver blue’ style and if you want to change it to any other style which can be more suitable to your website then it is possible to do. There are many pre-built styles available from which you can select the one. There is one inbuilt ‘Edit Menu’ which makes it easy to change the style directly through browser because actually it is a CSS file.

Simple Forum Structure – Administrating and managing phpBB style forum is very simple to set up as well as to use. The tasks like Addition, edition, and deletion of categories in the forum becomes very easy with phpBB.

There are number of other features come with phpBB board which I would like to discuss in another post.

Following are the steps to install phpBB through cPanel using softaculous.

• Login to your cPanel web hosting account by using your username and password.

• Click on the ‘Softaculous icon, which will carry you to newer screen where you will see ‘phpBB’ listed under the forums to the left side.

• Click on the phpBB and you will see the overview page of particular phpBB Version.

• Find the ‘Install’ tab and fill all the required details in the form such as Protocol, Domain, Directory in which phpBB is to be installed, Database name etc.

• Now find the ‘Install’ button at the bottom and click on it, your installation will get started and you will receive the message “Congratulations, the software was installed successfully.” after successful completion of it.

Now you can login into your phpBB control panel through the url provided at confirmation page and arrange the setting as required.