Author: Rahul

Amazon is the leading cloud hosting providers, You can get any type of server from AWS with very small in size to very large in size. If you have created a windows server instance in AWS EC2 hosting account, This article will help you to How to Find Windows Server Administrator Password in AWS Instance. Follow the below steps to Get Default Windows Password in AWS Instance using key file. Requirements First make sure you have AWS console access for your server along with private key created/used during creation of AWS Windows server instance. 1. AWS Console Access 2. Private…

MySQL is a popular open-source database management system that is widely used to store, organize, and retrieve data. It is commonly used in web development, as it is easy to set up, has a simple syntax, and is widely supported by hosting providers. In this article, we will cover the basics of creating and dropping databases in MySQL. Creating a Database in MySQL To create a new database in MySQL, you can use the `CREATE DATABASE` statement. The syntax for this statement is as follows: # Syntax: CREATE DATABASE employee_data; Replace “database_name” with the desired name for your database. For…

phpMyAdmin is the most popular web interface for managing MySQL databases. But there are many other tools available which we can use in place of phpMyAdmin. Using this article, I am trying to provide you a list of alternatives of phpMyAdmin. 1. Adminer Adminer is the my first choice to use rather than phpMyAdmin. Adminer is available in single php script, which can be easily uploaded in document root and easily access without any installation or configuration. Adminer also can be used to manage SQL Server, Oracle, PostgreSQL etc. Download Adminer 2. MyWebSQL MyWebSQL is an ultimate desktop replacement for…

Amazon SQL Server RDS Instance doesn’t support to restore data from .bak files. So using this article I am writing to how to migrate your SQL server database to Amazon RDS instanace with easy steps. If you looks on AWS migration steps its too complicated, But windows Azure migration wizard tools provide an easier way to migrate data between local SQL Server to AWS RDS instance. Step 1. Download SQLAzureMW Tool 1.1. At the very first we need to download SQLAzureMW using below url and extract on your system at any location. Download SQLAzureMW tool 1.2. Use SQL Server Management…

The Dynamic Host Configuration Protocol (DHCP) is an essential network protocol that simplifies the management of IP addresses in a network. It automates the assignment of IP addresses, subnet masks, and other network parameters to devices, allowing them to seamlessly communicate within a local area network (LAN) or wide area network (WAN). This article will provide a comprehensive overview of DHCP, its core components, and its working process. We will also cover its advantages and potential security concerns. Understanding DHCP In the early days of networking, network administrators manually assigned IP addresses to devices. This process was both time-consuming and…

Fail2ban is a very useful application for you if you are managing the security of the server, or you are running your own VPS or physical server. Fail2ban scan log files created on the system and has the ability to ban IPs which found malicious based on configuration rules. We can use it for monitoring various system services logs like Apache, SSH and blog the IPs which are trying to breach the system’s security. Step 1 – Install Fail2ban on CentOS First of all, enable epel-release yum repository on your CentSO system. Then install the Fail2ban rpm package using the…

Amazon EBS (Elastic Block Store) provides persistent block storage for using with Amazon instances. Each Amazon EBS volume offering high availability and durability. It has capability to automatically replicate in its Availability Zone to protect you from component failure. This article will help you to Create and Add EBS Volume to your existing instance. All the command are used with this article are used with CentOS 6.5. So change commands used in Step #3 as per operating system used. Step 1: Create an EBS Volume First we need to login to AWS EC2 dashboard. After login navigate to following location…

FTP (File Transfer Protocol) are mostly used in web development. Is very useful for connecting servers using FTP protocol for transferring files between server and client. This article will provide you with basic info about top FTP clients for windows systems. Personally, I always use FileZilla as FTP clients, So the below list can be used for Alternatives of FileZilla. 1. FileZilla FTP Client FileZilla is the most popular FTP client used for connecting FTP servers. It is popular with its user-friendly features. FileZilla is cross-platform and supports FTP, FTP over SSL/TLS (FTPS), and SSH File Transfer Protocol (SFTP). […

This article is used helpful for installing SSL certificate signed by CA for our WHM services. By default all services used self signed certificate in WHM/cPanel and we always get an warning while using any secured service like WHM/cPanel access, webmail access etc. Using this article we will install trusted ssl certificate in our WHM/cPanel server. Follow the below steps to do it. Step 1: Check System Hostname Check your current system hostname to generate csr by going to following location Home » Networking Setup » Change Hostname Or we can use linux command to find systems hostname # hostname…

Have you forgotten MariaDB root password? You don’t know how to recover it. Not to worry, this tutorial will help you to reset MariaDB root password on Linux system. Let’s follow this step by step tutorial to reset MariaDB root password on your Linux systems. Step 1 – Start MariaDB in Safe Mode First of all, you need to stop MariaDB service on your system. You can do this using the following command. sudo systemctl stop mysql.service Now start your MariaDB service in safe mode using skip grant and run this command in the background. mysqld_safe –skip-grant-tables & Step 2…