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 ...

Installing a VNC server in Debian/Ubuntu

VNC, or Virtual Network Computing, lets you connect to the GUI (Graphical User Interface) of a remote Linux/Unix server. Once you have installed X windows and a display manager, you can set up VNC to connect to it from a remote computer. Step 1: There are a few options for the VNC server; TightVNC is one of them. To install ...

How to Traceroute TCP/IP Connections

When troubleshooting connection issues to your website or your server, one of the tools you have at your disposal is the traceroute tool as a network troubleshooting tool. Traceroute comes in handy when you're trying to diagnose routing issues over large networks. This command-line tool will print out the route taken by a packet between your computer and its destination ...

How to Enable Chrome Remote Desktop on a Windows VPS

This guide will show you how to access another computer with Chrome Remote Desktop. By following this guide, you will access files and applications on another computer over the internet using a computer or mobile device. Set Up Remote AccessStep 1: Download the Chrome Remote Desktop app . Step 2: In the address bar, type in chrome://apps Step 3: Click on the Remote ...

How to Flush Your DNS Cache

Flushing your DNS cache on your local computer can ensure that you're pulling the most current version of a website. In this article, we will review the simplest methods to flush your DNS cache for various operating systems. Windows 2000 / Windows XP Open up a command prompt by clicking the Start button Search for Run Enter in cmd Type in the ...

How To Map Your Windows Server Drive As A Network Drive

One thing you can do with your Windows VPS or dedicated server is map one of its folders as a network drive on your local PC. This is great if you have data on your server that you need quick access to or have data on your local PC that you would like to push to the server. This guide ...

Common Reasons A Website Is Not Loading

Why Can't I Load My Website?There are many reasons a site might not load, such as misconfiguration, corrupt files, problems with a database, or something as simple as needing to clear your browser's cache and cookies on your computer. Problems with the DNS Make sure that you have the nameservers and DNS set correctly and it's had time to ...

How to Disable Automatic Updates and Restarts in Windows Server 2016

With Windows, Microsoft pushes updates to the operating system fairly frequently. These updates often include important aspects such as security updates, which it is highly recommended you install. However, by default, Windows updates will automatically download and install and force your server to reboot even if you didn't want it to. To avoid this, it is recommended to change how ...

How to edit or delete Categories in WordPress

Introduction When organizing your website content using categories, you will definitely come to a point where you would like to perform certain changes. From time to time, you may need to modify some category details to keep everything up-to-date. You may also need to completely remove some old categories that are no longer required. In this tutorial, you will find ...

How to manage Addon Domains in cPanel?

Introduction Often, when it comes to managing multiple websites on a single Web Hosting Account you might reach a point when you need to add a new domain and manage a completely separate website for it apart from your Primary Domain. The ability to add new Domains and manage separate websites for each one of those in the context of ...