The following tutorials are example of the essential MySQL commands and techniques needed by system administrators. Although there are people/departments that specializes on Database administration, knowing these commands will help you understand and collaborate effectively with database administrators.
Continue reading “Important MySQL commands”
Category: CentOS
CentOS
Additional MySQL Commands
When you forgot the password to your MySQL server, you can reset it using the following steps. This will require a downtime since you are going to stop MySQL service. After this, remember to keep you mysql root password.
Create a swap file in Linux
Some VPS on hosting providers like Amazon Web Services do not have swap by default. Or if your server was configured with small swap and now you want to increase it. Below are instructions on how to increase swap area.
Continue reading “Create a swap file in Linux”
SFTP Server with chroot Setup CentOS 6 / RHEL 6
SFTP provides a secure way for providing FTP access to clients. It comes built-in with the openssh-server package. Creating SFTP accounts is straightforward like normal user accounts. However if you want to limit the users to access their designated folder only, then a chroot setup is needed. This improves security in a way that sftp users cannot login to a normal bash shell and they cannot view system folders when they are logged-in. This tutorial will walk you though SFTP server setup.
Continue reading “SFTP Server with chroot Setup CentOS 6 / RHEL 6”
DNS Server Setup for Centos 6 / RHEL 6
DNS stands for Domain Name System, or Domain Name Server. DNS resolves an IP address to a hostname or vice versa. This tutorials walks through the installation and setup of a Bind9 DNS server for Centos 6/RHEL 6. This is just for a master DNS server and setup of a slave is not covered.
Continue reading “DNS Server Setup for Centos 6 / RHEL 6”
Setup NFS share in Linux
Network File System (NFS) is the standard protocol used for sharing files/folder between Linux/Unix systems. This is helpful on production environments that requires a common folder on multiple servers. NFS shares provide quick and efficient file/folder sharing between systems. It’s easy to configure and setup. It’s not compatible on windows machines though- you can Samba protocol for this. This tutorial is done on CentOS but will also work on Ubuntu and other Linux OS.
Continue reading “Setup NFS share in Linux”
Installing Transmission Daemon on CentOS 6 / RHEL 7
Transmission is a popular torrent client on modern Linux systems. It has both a GUI for desktop and a daemon that can run on headless servers such as an Amazon VPS. An advantage of running it on Amazon is that torrents will be downloaded faster since the VPS bandwidth is higher, then you can just directly download your file from your VPS. This helps offload the torrent traffic from your own internet connection.
Continue reading “Installing Transmission Daemon on CentOS 6 / RHEL 7”
Manage Drives and Disk Partitions using fdisk
One of the common administrative tasks under UNIX/Linux is to add a new disk to the system to increase its storage capacity. This tutorial will walk through on adding disk to a running system, making a partition, assigning file system and creating mount point for the new disk. The fdisk utility is very helpful especially when adding new drives to be used for Logical Volume Management (LVM).
Continue reading “Manage Drives and Disk Partitions using fdisk”