MySQL IN clause can be used instead of using OR operator with Where clause. It can be used when where clause is applied for multiple values for same column in an SQL query.
Convert .pem to .ppk using PuTTY to connect to Amazon EC2 instance from Windows. Amazon provides a .pem private key which cannot be directly used in PuTTY.
When working with MySQL, you may need to backup and restore MySQL database regularly to recover in case of accidents. Here’s how you can do it.
Usually remote access to MySQL database is disabled for security reasons. However, if you need to provide remote access to MySQL, just follow these steps.
Sometimes you need to create a read-only MySQL user. You can follow these steps and use these ready made commands to create a read-only MySQL user.