Author: Rahul

MySQL is a popular open-source relational database management system that is widely used for web development and data-driven applications. When working with MySQL, it’s essential to understand how to create and manage user accounts and grant them specific permissions. This beginner’s tutorial will guide you through the process of adding users and managing permissions in MySQL. Prerequisites Before you start, ensure that you have MySQL installed on your system and have administrative privileges (such as the root user). You’ll also need access to a command-line interface to interact with the MySQL server. Step 1: Accessing the MySQL Server To begin…

In the digital realm, ensuring the integrity of files, especially when transferring them over the internet or storing them for long periods, is paramount. MD5 checksums serve as a crucial tool in this endeavor, offering a way to verify that files have not been altered or corrupted. This guide will walk you through the process of generating and validating MD5 checksums for the contents of a directory, ensuring your data’s integrity every step of the way. What is an MD5 Checksum? An MD5 checksum is a 128-bit hash value, typically expressed as a 32-character hexadecimal number, generated from a file…

Virtual Hosting provides us to host multiple domains (websites) on a single server. It is a concept of resource sharing among multiple hosting accounts. The best use of Virtual hosting is shared hosting servers, where multiple users can host multiple websites on a single server. This blog post will help you to create virtual hosts in the Tomcat web server. Setup Details Here are the basic setup details used in this article: A Linux host with IP address 192.168.1.100 Running the Tomcat server on the host on port 80 Deployed two sample applications, the first application is configured at http://192.168.1.100/myapp1…

Question – How to remove extra spaces from a string using JavaScript? A space (” “) character is used to separate two words. Some times we get the extra spaces in a string, which may case issues with your application. JavaScript trim() function is used for removing leading (before) and trailing (after) spaces from a string. This tutorial will help you to remove extra spaces from a string using JavaScript function. Remove Spaces with JavaScript trim() Function For the example, assign a string with spaces to a variable. Then use JavaScript trim() function to remove leading and trailing spaces from…

phpMyAdmin is a popular tool used to manage MySQL databases through a web interface. However, allowing root login through phpMyAdmin can pose a security risk because it gives complete control over the database. Disabling root login in phpMyAdmin is a simple yet effective way to protect your system from unauthorized access. In this guide, we will walk you through easy steps to disable root login, making your phpMyAdmin setup more secure without affecting its functionality for other users. Disable root Login in phpMyAdmin First of all, find the phpMyAdmin directory location as per your installation. Generally, it is installed under…

The ASPState database is used by Microsoft’s ASP.NET Session State Service to store session data. By default, session state service stores its data in an in-memory cache. If you want to persist session data across multiple web servers in a web farm or you want to recover session data in case of application crashes or restarts, you should consider storing your session state in an ASPState database in SQL Server. Prerequisites A version of SQL Server (2008 or later). The ASP.NET Session State Service should be installed on your server. This service comes with ASP.NET and is installed automatically when…

We can use an internal field separator (IFS) variable to parse an array. Let’s use an example script, where first we define a string with colon-separated. Then we will use IFS to separate values based on a delimiter.

Let’s execute this script and check for results. ./myscript.sh Output: orange grapes banana apple

Command SNAME=$(basename “$(test -L “$0” && readlink “$0” || echo “$0″)”) While running a bash script using Linux terminal the script name can also passed as argument at $0. but if we are using full path of script to execute, it will show full path as results when print value of $0. So use above command will exactly provide only script name. It also handle if you are running any bash script using symbolic link. Example: Create a script named test.sh and add following content in script. #!/bin/bash SNAME=$(basename “$(test -L “$0” && readlink “$0” || echo “$0″)”) echo “Your…

MX records in DNS are used to route emails to correct mail servers and properly send to correct destination server. If you are using Google apps account for hosting email accounts on Google servers for your domains, then you need to add following MX records in your domains DNS configuration. Google Apps MX Records: @ IN MX 1 ASPMX.L.GOOGLE.COM @ IN MX 5 ALT1.ASPMX.L.GOOGLE.COM @ IN MX 5 ALT2.ASPMX.L.GOOGLE.COM @ IN MX 10 ALT3.ASPMX.L.GOOGLE.COM @ IN MX 10 ALT4.ASPMX.L.GOOGLE.COM

Generally Ubuntu users used Synaptic Package Manager for GUI and apt package manager for command line for installing packages. But not all latest application’s provides pre compiled packages for system, In that case you need to compile it using source code for installing application on your system. This article will help you for installing packages using source archive on Ubuntu systems. Prerequisites Before working with the compilation of source package, First we need to prepare our system with requirements for compilation. $ sudo apt-get install apt-file autoconf build-essential checkinstall Extract Source Package Firstly download the source archive on your system…