Let’s make some database magic. 1. Configure MySQL for remote connections. The first thing we must do is configure MySQL for remote connections. To do this: ...

Next, I edited MySQL’s configuration file /etc/my.cnf to match the text listed below. I ensured bind-address was set to 0.0.0.0 — this address instructs MySQL to accept connections from any IP ...

The first thing we must do is configure the MySQL server to allow remote connections. On top of that, we’re going to create a specific user that has specific permissions for the database we’ll ...

As your application or website grows, there may come a point where you’ve outgrown your current server setup. If you are hosting your web server and database backend on the same machine, it may be a ...

My remote mysql server is correctly configured and I can connect remotly to it with Sequal from my localhost as well as another server, privileges are fine, bind-address too and my.cf and so on. Got ...

Now switch to the application directory: $ cd ostechnixapp/ Edit the application's database configuration file: $ vi config/database.yml. If you're using MySQL, add the database user name and the ...