How to troubleshoot 500 Internal Server Error?

The 500 Internal Server Error will be familiar to all Internet users. There are various http status codes which are three-digit integers. For every request, there will be a status code to return from the server to the client. Usually, we’d have come through various errors like 404 Not Found error. These error codes are actually http status codes. The 500 Internal ...

How To Extract .tar.gz Files using Linux Command Line

In this tutorial we can learn how to extract tar.gz files using Linux Command line tools. A .tar.gz file is nothing, but an archive. It is a file that acts as a container for other files. The tar program provides the ability to create tar archives, as well as various other kinds of manipulation. For example, you can ...

How to connect to MySQL using PHP

This article describes several methods to connect to a MySQL database using PHP: MySQL Improved (mysqli) PHP extension PDO (PHP Data Objects) Legacy MySQL (mysql_) functions Connect to remote MySQL database using PHPThe MySQL databases and users must already exist before you can use these methods.Method #1: Connect to MySQL using MySQL Improved The MySQL Improved extension uses the mysqli ...

When Should You Use JPEGs vs. PNGs

Digital images come in many types, but the two most common formats on the web are JPG and PNG. You may have heard conflicting information from different sources about which one is best. This can make it hard to know what format you should use for your website.In general, PNG is a higher-quality compression format. JPG images are generally ...

How to import and export a MySQL database

This article describes how to import MySQL databases and export MySQL databases. You can import and export databases for a variety of scenarios, including: Transferring a MySQL database from one web hosting account or provider to another. Importing a third-party MySQL database. Backing up a MySQL database.How to export a MySQL database You can export a MySQL database to ...

How to transfer files using SCP (Secure Copy)

This article describes how to use SCP (Secure Copy Protocol) to transfer files quickly and securely from the command line.What is SCP? Secure Copy (SCP) is a protocol based on SSH (Secure Shell) that provides secure file transfers between two computers. With SCP, you can quickly transfer files using the command line, which is often faster and easier than ...

How to clear the DNS cache on your computer

This article describes how to clear the DNS cache on your computer. Many computer operating systems use caching to store DNS lookup results. Normally this is not a problem, and accelerates network performance. However, when you are developing a web site or configuring domain settings, your computer's DNS cache can get in the way, preventing you from accessing the correct ...

How to troubleshoot network connectivity using ping and traceroute

This article demonstrates how to use a ping test and traceroute tools to test network connectivity between two hosts. Ping performs a basic test to determine if a remote host is available, while traceroute tests the complete route network packets take from one host to another. Traceroute is especially helpful for diagnosing where network slowdowns and congestion occur.Testing network ...

How to troubleshoot DNS with dig and nslookup

This article describes how to use the dig and nslookup tools to test DNS settings. (Microsoft Windows uses nslookup, while Mac OS X and Linux use dig.) You can use these tools to determine the IP address associated with a domain name, obtain the mail server settings for a domain, and much more. You can use web-based tools or command-line ...

How to manage MySQL databases, users, and tables from the command line

This article describes how to do common MySQL database administration tasks from the command line using the mysql program. These common tasks include creating and deleting databases, users, and tables.This article only applies to the products listed in the Article Details sidebar. If your account includes cPanel, you should use it instead to manage MySQL databases and users.Creating ...

How to clear a web browser's cache and cookies

This article describes how to clear the cache and cookies for a variety of popular web browsers. Web browsers use caching to speed up the browsing experience. Normally, this is not a problem. However, when you are developing pages for your web site or configuring domain settings, the browser's local cache and cookies can get in the way. For example, ...

How to Access Your Windows Server Using Remote Desktop

In this article, we explain how to use Remote Desktop software to access your Windows server’s desktop from anywhere in the world. On a normal Windows computer, you have a keyboard, monitor, and mouse that allow you to interact with the machine. For Windows VPS servers hosted on the Internet, things are a bit different because your server could ...

How to add Python Path to Windows 10 PATH

Python is a powerful programming language that is scalable and uses code that is readable and clear for all types of projects. Python is also available across a number of operating systems, making it a popular choice for developers. If you are using Python on your Windows operating system, you may need to adjust your System Environment Variables to simplify ...

Understanding the DNS Process

What is DNS? DNS stands for Domain Name System (DNS) services. When we access a website, we are using this service to locate the server where the domain's website is located. When browsing the web, we usually type in a domain name like www.google.com into our browser. This is better than trying to remember an IP address linked ...

How to Check the MySQL Version

In this quick tutorial, we'll learn how to check the MySQL version of a server. Without a doubt, MySQL is one of the most popular RDBMS (Relational database management system) options available, so you'll find it pretty much everywhere. There can be some pretty staggering differences between MySQL versions, so knowing which version you're working with is important. Learn here ...

What is the Default Password for PostgreSQL?

When connecting to PostgreSQL on Linux for the first time many admins have questions, especially if those admins are from the MySQL world. By default, when PostgreSQL is installed, a postgres user is also added. If you run the command:cat /etc/passwd… you’ll see the postgres user.postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bashThe first question ...

How to Install PIP for Python on Windows

Pip is one of the best tools to install and manage Python packages. Pip has earned its fame by the number of applications using this tool. Used for its capabilities in handling binary packages over the easily installed package manager, Pip enables 3rd party package installations. Though the newest versions of Python come with pip installed as a default, this ...

How to Edit Your Hosts File in Windows 10

What is a Hosts File? The hosts file is a local plain text file that maps servers or hostnames to IP addresses. This file has been in use since the time of ARPANET. It was the original method to resolve hostnames to a specific IP address. The hosts file is usually the first process in the domain name resolution procedure. ...

How To Setup And Configure DNS In Windows Server 2016

Microsoft Windows Server 2016 is an updated version and a powerful operating system capable of many different, highly customizable roles and functions. However, to prevent overloading the hardware and severely degrading the performance of the hardware, Windows Server 2016 continues to provide a modular approach to tasks and roles in a server administrative environment through the Add Roles and Features. In addition ...

Installing FTP in Windows Server

One of the key parts of using a server for hosting or storage is quickly and easily transferring your data between the server and your local computer. The best way to accomplish this is using File Transfer Protocol (FTP). This guide will show you how to configure FTP for Windows servers in 2008, 2012, and 2016. The steps to accomplish this are primarily ...