How do I login to phpMyadmin on a VPS

phpMyAdmin is a tool that is used to administer MySQL databases with a web based graphical interface. To login to phpMyAdmin on your Pickaweb VPS running cPanel, do the following: Login to your cPanel. Go to Databases section. Click on phpMyAdmin icon. This will take you to the phpmyAdmin panel where you can import and […]

Read More

Change Collation using phpMyAdmin

There’s always been a confusion about Character Sets and Collation. A character set is a set of symbols and the encoding of those symbols where as Collation defines the set of rules with which the characters in the character sets are compared. This is the exact definition you can find in the official website of […]

Read More

What Is MySQL?

MySQL is a popular Database system launched in 1995 by Swedish Company My SQL AB. It is written in C and C++ and is frequently used in web hosting environments and forms the ‘M’ in the acronym ‘LAMP’ (i.e. Linux, Apache, MySQL, PHP/Perl). After SQLite it is the most popular Relational Database Management System (RDBMS). […]

Read More
phpmyadmin with apache on centos

Install And Configure PhpMyAdmin With Apache In CentOS Server

Installation & Configuration Tutorial – phpMyAdmin (Apache/CentOS) Web server is necessary for phpMyAdmin to work as it is a web based tool. It provides a GUI which provides the users a very easy and efficient interface to administer the MySQL databases. With the help of phpMyAdmin, a normal person who doesn’t know the MySQL commands […]

Read More

How To Install MySQL In CentOS

Installation & Configuration of MySQL in CentOs MySQL and MariaDB is the most popular database management system and is well known for its stability, flexibility, robust and powerful nature. Installing MySQL is a very simple process and it involves only a couple of steps. This tutorial covers how MySQL is installed and configured in a […]

Read More

Installing APC cache on a cPanel Server

Quick Overview of Alternate PHP Cache (APC) APC stands for Alternate PHP Cache. It is an open source caching module to cache PHP codes and thereby optimizing it. With this caching enabled in the server, PHP code will be cached and it will be served faster from then on without having to re-run the code. […]

Read More

Securing A Linux Server With APF On CentOS

Setting Up and Configuring Advanced Policy Firewall (APF) for Linux Servers (CentOS) Advanced Policy Firewall (APF) is one of the advanced iptables based firewall used in Linux servers. Some of the best features of APF are: Detailed and easily understandable configuration file. Detailed error checking in startup. Granular network filtering Bruteforce protection Intrusion detection etc. […]

Read More

Linux Server Security – Installing And Configuring LMD (Maldet)

What is LMD & Why You Should Use It To Help Secure Your Linux Server If you are a server administrator you need a way to protect the integrity of your server, in particular from sending out spam. This usually occurs when an account has been compromised. Often users will not have updated their applications […]

Read More

Setting Up Remote MySQL Server (CentOS)

The Advantages Of Setting Up Remote MySQL Server With servers hosting large websites, resource usage is a big issue and in most cases MySQL is consuming the majority of the resources. To tackle this, setting up a separate stand alone MySQL server and loading the websites from there is a very good option. With this […]

Read More