Basic mysql admin commands

SET MYSQL root password mysqladmin -u root password NEWPASSWORD change mysql root password mysqladmin -u root -p’oldpassword’ password newpass   Add MySQL users and assign privilege CREATE USER ‘newuser’@’localhost’ IDENTIFIED...

Public key authentication on EC2-instances

Step 1: Create a key pair on your local linux server anjani@local-host$ ssh-keygen Generating public/private rsa key pair. Enter file in which to save the key (/home/anjani/.ssh/id_rsa):Enter key Enter passphrase (empty for no passphrase): Press enter key Enter same...

Basic admin commands

useradd -m username crontab edit env EDITOR=nano crontab -e   To backup using TAR tar -zcvf file_27_07_2012.tar.gz /var/www/ To Restore tar backup   Remote file copy using scp scp localfile root@remoteserver:/BACKUP eg: scp tomcat.tar [email protected]:/BACKUP...

FTP installation and configuration in ubuntu

sudo apt-get install vsftpd vi /etc/vsftpd.conf write_enable=YES local_enable=YES pam_service_name=ftp sudo /etc/init.d/vsftpd restart Setting the default permissions for files uploaded via FTP to a directory change your umask setting to 022   Additional...