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 […]
Category: MySQL, PHP & Databases
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 […]
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). […]
How To Choose PHP Handlers And How To Switch Them In cPanel Servers
Choosing PHP Handlers in cPanel This works hand in hand with Apache / Litespeed depending upon your installation. Web server fetches the PHP requests to the PHP handler which processes it and gives back to the web server. There are mainly 4 types of PHP handlers in cPanel servers. 1) DSO 2) CGI 3) FastCGI […]
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 […]
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 […]
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. […]
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. […]
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 […]
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 […]