Nanobox Forum

Provision MySQL Server Locally or On Nanobox

grabbar 2017-08-24 03:05:50 UTC #1

I already have mysql running on my computer - can I use it, or am I forced to use a second nanobox?

sanderson 2017-08-24 03:06:49 UTC #2

You can use it, but it'd be a lot easier to just provision one inside of Nanobox. You don't need a second Nanobox. It'll provision a single VM, then build whatever components/containers are in your boxfile.yml.
For example:
run.config:
engine: php

data.db:
image: nanobox/mysql:5.6
That would provision a php code container and a mysql container inside the Nanobox VM
you'd be able to connect to the mysql database from the php container
However, to use your local mysql db, you'd have to expose it to the public network in order for anything running inside of nanobox to communicate with it.

grabbar 2017-08-24 03:07:09 UTC #3

The public network?? You mean I cannot use it as localhost (127.0.0.1)??

sanderson 2017-08-24 03:07:19 UTC #4

No, because inside the nanobox VM, localhost (127.0.0.1) is not your local machine. It's the VM localhost.

grabbar 2017-08-24 03:07:36 UTC #5

So the only difference between you and MAMP is that you spam me and MAMP doesn't??

sanderson 2017-08-24 03:07:58 UTC #6

MAMP installs and runs Apache, MySQL, and PHP on your Mac with very fixed configuration and is only meant for local development. Nanobox lets you use any language, any database, and any webserver (whatever you configure in your boxfile.yml) to build your app in a virtualized environment on your local machine. You can then deploy that app to a production infrastructure that is identical to your local environment.
Not sure what you mean by spam you? Do you just mean emails from Nanobox?

grabbar 2017-08-24 03:08:11 UTC #7

If I cannot use my installation of MySQL, then I'll guess I cannot use MySQL workbench either...

sanderson 2017-08-24 03:08:26 UTC #8

Oh, you can still use MySQL workbench. When Nanobox builds the database inside the VM, it exposes a virtual IP that you can use to connect to the database inside the VM.

grabbar 2017-08-24 03:09:10 UTC #9

I was referred to you because Homebrew is unable to install Phalcon on my Mac, which I use for local dev.

sanderson 2017-08-24 03:09:24 UTC #10

Here's some more info about managing local mysql databases: https://guides.nanobox.io/mysql/local/

grabbar 2017-08-24 03:09:40 UTC #11

As to your spam question:
$0 cost = free... free equals no trading... yet you require me to trade my email address in exchange for downloading your software...

sanderson 2017-08-24 03:10:31 UTC #13

Keeping the download behind the dashboard is likely only temporary. We've done this to aid us in rooting out bugs and associating issues with users that we may need to contact. I know it's a hoop to jump through, but I promise we don't do anything dodgy with your email address. The most we will use it for is emailing you. And even those you can unsub from.

grabbar 2017-08-24 03:10:41 UTC #14

Sorry but I have a strict policy of never giving out my email address. And I have a bad habit of badmouthing people that say free and then require an email address. In my world that negates your use of $0 per month and makes it a lie.

sanderson 2017-08-24 03:10:52 UTC #15

You can also run nanobox anonymously if you'd like: nanobox config set anonymous true

sanderson 2017-08-24 03:11:13 UTC #16

I understand your thinking and we in no way meant to lie. I'm sorry it came across that way. There is value associated with Nanobox, and if that value isn't worth an email address for you, then Nanobox may not be the right product for you.