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

Security of data and server from hackers is a main task of system administration services. Below is few basic security tips for your linux server. 1: Strong Password Policy Making strong passwords is first stage of securing your server. Do not use common names as your password like yourname, date of birth, mobile number etc. Passwords should be alphanumeric with upper and lower case letters. You can use password aging policy on your linux machine to enforce users to change there password on regular interval. Example: To get password aging information # chage -l username To change password aging information…

Read More

Q. How to reset MySQL root password in Linux? How do I recover MySQL root password? I forgot MySQL root password, steps to change MySQL root password? How to reset MySQL root password using the command line. How to reset forgotten MySQL root password on Linux? How to reset MySQL 5.7 root password? MySQL is an open source database software widely used for data storage. Sometimes we forgot MySQL root password. So don’t be panic, This tutorial will help you to reset MySQL root password with simple steps. Reset MySQL Root Password Start MySQL in Safemode – First of all,…

Read More

MySQL is an relations database management system used for storing data in tabular format. If you are using MySQL server for an production use, then its necessary to create database backup for recovering from any crash. MySQL provides an utility mysqldump for taking backups. In this article you will learn, to taken databases backup in .sql format for archive format. Also we will explain various options for it. This tutorial uses mysqldump command to backup mysql databases. The second is default mysql command for restoring databases from backup. Backup MySQL Databases with mysqldump You have many options for creating databases…

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