When your are trying to import your data into RDS MySQL, it may prompt with following error message. “ERROR 1227 (42000) at line xxx: Access denied; you need (at least one of) the SUPER privilege(s) for this operation” This can be fixed by removing the DEFINER from MySQL dump. You can use following simple …
Category Archive: Amazon Web Services
Sep 03
Redirect non-www requests to www using AWS Route 53
Many web masters prefer to redirect non-www request to www. There are lots of different approaches for that and most famous one is using 301 redirection on the web server to handle this redirect part. Then what happen is, server must need to put extra processing for this redirection request. If the server have to …
Aug 06
Adding users to Linux EC2 instance and give SSH access
The default AWS Linux EC2 instances come up with one user account such as centos, ubuntu etc with sudo privileges. However in complex environment you may be needed add more users to EC2 instance with different privileges. Here we are going to discuss how to adding users to Linux EC2 instance and give SSH access …