Permit Root Login Into Instance Launched From Centos Official Image

Introduction

If you tried to access your instance using SSH as root: # ssh -i PrivateKey.pem  root@Floating-IP-Address Where Flaoting-IP-Address is the flaoting IP address associated with your instance. You might get this message: “Please login as the user “centos” rather than the user “root”.” Then the connection will close. Continue reading “Permit Root Login Into Instance Launched From Centos Official Image”

How To Set Up a Remote Database to Optimize Site Performance with MySQL

Set Up Remote Database

Now that we have MySQL configured listening on an external address, we need to create a database and establish a remote user. Even though MySQL itself is now listening on an IP address that other machines can connect to, there are not currently any databases that it can access. This is also an opportunity for us to establish different privileges based on where a user is connecting from. We can create two “users” that can actually just be the same username, but associated with different hosts. Continue reading “How To Set Up a Remote Database to Optimize Site Performance with MySQL”