In this video, I'll show you how to set up access directly to your database.
So if you own your own server and your own database, there's some tools that we can give
you where you can go in and access this data directly.
This can be very helpful if you're doing things like bulk exporting, bulk importing.
You can also use things like Looker Studio to create very granular reports on different
items.
So we're going to create a few videos for those.
But in this one, I just want to show you how to get access to your MySQL database.
So if we jump over, you're going to want to go over to your DigitalOcean account.
This would have been created in your company's name.
And so we're going to jump over.
I'm going to just show an example here with Brilliant, for example.
When you click in here, you'll see there's a project called TribeSocial.
You'll have your app, your droplets, and then this database.
So to get to the database, you just simply click on this.
You'll also need to go and just add your IP here.
So if you click here, and actually, if you scroll down all the way, you'll see Trusted
Sources.
You're going to want to click Edit Sources and then click here, and we'll be able to
add the current IP here as well.
So I think if you start typing, you can also Google my IP, and your IP address will come
up here.
And this will change depending on if you're on a different network, so just keep that
in mind if you are having issues connecting.
You do want to click on this, add it here, and then it should be added.
If you go to the top here, you'll also see in the connection details.
I'm not going to show the password here, but if you plug in all this information, this
is how you will access the SQL data.
So you guys have access to this, it's owned under your company, it's how it's set up,
and the next step we're wanting to use, if you're on a Mac, I highly recommend using
a tool called MySQL, sorry, it's called SQL Ace, if you just Google that, I can drop a
link below.
But it's a great little tool, it's totally free, and you'll go in and plug in that data
here.
So when I open it for the first time, you'll see something like this, and you'll plug in
all those values, name, host, username, password, and all these different variables.
You can actually save that, so then it's saved to your computer, and the next time you want
to come in and access that, you just simply double click, and it will go in and open up
everything in kind of like a nice spreadsheet view, and you'll see there's different tables
with all of your data all stacked in here.
So you can see all of your user data, for example, there's things like passwords that
are masked and encoded, so those aren't the actual passwords, but this is a great way
to just browse things, you can go up to the top here and hit export, various information,
you can also filter, let's say I only want to look at people who equal admin, you can
do a quick filter, and now it just filters all the admin users there, and so forth.
So great way to do that, this is obviously if you just want to browse, export things,
you can do that here, you can also plug it into Looker Studio, I'll make another video
for that, but you can see that things like analytics are actually just a table inside
of this spreadsheet, and in this particular case there's over a million rows in this table,
and so a lot of big data and stuff that can be managed through this, but now you kind
of have direct access to your database.