Author: Rahul

I, Rahul Kumar am the founder and chief editor of TecAdmin.net. I am a Red Hat Certified Engineer (RHCE) and working as an IT professional since 2009..

As a system administrator, you need to take backup on daily basis. Backups are very useful to recover data from any crashes or corruption. I have written a simple script to take database backup from MySQL server and upload it to FTP server. Being a system administrator, I recommend keeping a remote copy of your every backup. You can also try our new advance script for MySQL databases backup and upload to remote locations. Create a shell script file and copy the below script. Then update all the required values and execute.

Setup Details – Edit the above script…

Read More

Linux servers power many of the world’s applications and services, making them a popular target for attackers. Ensuring the security of your Linux server is critical to protect sensitive data and maintain system stability. In this comprehensive guide, we’ll discuss various strategies to harden your Linux server, covering aspects like system updates, user management, file permissions, and more. 1. Regular System Updates One of the most effective ways to improve your server’s security is to keep your system up-to-date with the latest patches and security fixes. Regularly updating your Linux distribution will ensure that you’re protected against known vulnerabilities and…

Read More

Resetting the MySQL root password in Linux is a crucial task for database administrators, especially when access is lost or compromised. This guide will walk you through the steps to regain control of your MySQL database by resetting the root password. Whether you’re dealing with a forgotten password or enhancing security, following these instructions will help you securely reset your MySQL root password. The process involves stopping the MySQL service, starting it in safe mode, and updating the root password. These step-by-step instructions will help you recover the mysql root account password quickly. Prerequisites Before we begin, make sure you…

Read More

MySQL is one of the most popular open-source relational database management systems used worldwide. As your data grows, it becomes increasingly important to safeguard it by implementing regular backups and having a reliable restoration process. In this article, we will provide a comprehensive guide to MySQL database backup and restoration, covering best practices and tools that will ensure the integrity and availability of your data. Backup Methods There are several methods to create a MySQL database backup, including: Using mysqldump Using MySQL Enterprise Backup (commercial) Using binary log-based incremental backups Using file system snapshots We will focus on the most…

Read More

FreeRadius is an implementation of RADIUS server. Its support multiple types of authentication. This article will help you to setup freeradius authentication with OpenLDAP. Step 1: Setup OpenLDAP Server First its required to setup openldap server to complete below setup. Use below link to install it. Setup Openldap Server on CentOS, RHEL System Step 2: Install freeradius Packages Install all freeradius2 server packages on your system using following command. # yum install freeradius2 freeradius2-utils freeradius2-ldap Step 3: Download Schema File Download radius ldap schema file and copy to ldap schema directory using below commands. 3.1 Download File # wget http://open.rhx.it/phamm/schema/radius.schema…

Read More

OpenLDAP is an opensource implementation of Lightweight Directory Access Protocal. Read more about OpenLDAP Project. I am using CentOS 5 for configuring OpenLDAP server. Below are the steps which I have performed during configuration. This article will help you step by step to Install and Configure OpenLDAP Server. Network Details: Below is the network details used while writing this article. System name: openldap.example.com System IP: 192.168.10.50 Domain Name: example.com Step 1: Create Test Accounts Firsty create two test user accounts in your linux system using following commnands. # useradd ldapuser1 # useradd ldapuser2 # passwd ldapuser1 # passwd ldapuser2 Step…

Read More

MySQL is a database system that stores data for websites. It is a type of RDBMS, or Relational Database Management System. This means that it organizes data into tables, and you can access and update the data using SQL commands. MySQL is used by many popular websites, including Facebook, Twitter, and YouTube. It is also used by some large organizations, such as the US Census Bureau and the National Weather Service. MySQL is free and open-source software, so anyone can download it and use it for their own website. MySQL runs on a server, which means you need to have…

Read More