- [Presenter] As for MongoDB and Redis,
we will now also create a container for MySQL
for that first run Docker, "pull mysql".
Also, make sure again,
that your docker daemon is running,
and this will pull down the latest version
of the MySQL image.
Next, as we did before,
I do a "docker run --name".
The name is "mysql",
and I'm also do the port mapping,
so, mapping my local port 3406
to the container port 3306,
which is the default port of MySQL,
and here also add one environment variable with "-e".
This environment variable is all uppercase,
"MYSQL_ROOT_PASSWORD"
So, this will be set as the password for the root user,
and I simply use my password here,
needless to say that in production
you want to have a way more safe password.
And then in the end I also use "-d" to create daemon,
and I also have to tell which image to use.
It's the "mysql" image that we just pulled,
and then I can hit Return.
Now we have a running MySQL Docker container,
and again, I want to have some graphical user interface
to look at the databases.
And again, I will use the tool provided
by the company that is behind the database,
in this case, it's Oracle,
and the provided software called MySQL Workbench.
So I simply look for MySQL Workbench
and get this on mysql.com/products/workbench,
and there you can just select "Download Now"
and you can download it then for your operating system.
I did this already, so I will just run MySQL Workbench.
Once it's started, you end up on this screen,
and there, I click on this little plus icon
at "MySQL Connections",
and here I can define the connection,
as I did before also for the other databases.
So now I'm using a connection name,
let's call it "Node Databases",
and, for the port,
I just have to change the port to 3406.
The username is "root",
and then I can already click on "Test Connection"
and it will ask me for the root password,
and this is my password,
and I select this box for "Save password in keychain",
and then I click "OK",
and I get the message
that the connection was successful.
So now I click "OK" on this window here,
and then I can click on this connection,
and after it connected to the database server,
I end up on this screen where I can click,
for instance, on "Server Status"
and get basic metrics about the server.
And, if we click into "Schemas",
we see that right now
there are only the system tables in there.
With that, MySQL is now installed on my system,
and I can now go ahead and create my first schema,
and this will be for the Maxcoin application.