WEBVTT

1
00:00:00.000 --> 00:00:05.600
In this video, I'll show you how to set up access directly to your database.

2
00:00:05.600 --> 00:00:10.800
So if you own your own server and your own database, there's some tools that we can give

3
00:00:10.800 --> 00:00:15.040
you where you can go in and access this data directly.

4
00:00:15.040 --> 00:00:20.120
This can be very helpful if you're doing things like bulk exporting, bulk importing.

5
00:00:20.120 --> 00:00:26.360
You can also use things like Looker Studio to create very granular reports on different

6
00:00:26.360 --> 00:00:27.360
items.

7
00:00:27.360 --> 00:00:29.200
So we're going to create a few videos for those.

8
00:00:29.200 --> 00:00:33.840
But in this one, I just want to show you how to get access to your MySQL database.

9
00:00:33.840 --> 00:00:38.660
So if we jump over, you're going to want to go over to your DigitalOcean account.

10
00:00:38.660 --> 00:00:42.360
This would have been created in your company's name.

11
00:00:42.360 --> 00:00:43.960
And so we're going to jump over.

12
00:00:43.960 --> 00:00:52.200
I'm going to just show an example here with Brilliant, for example.

13
00:00:52.200 --> 00:00:55.400
When you click in here, you'll see there's a project called TribeSocial.

14
00:00:55.400 --> 00:00:58.800
You'll have your app, your droplets, and then this database.

15
00:00:58.800 --> 00:01:03.800
So to get to the database, you just simply click on this.

16
00:01:03.800 --> 00:01:11.000
You'll also need to go and just add your IP here.

17
00:01:11.000 --> 00:01:15.160
So if you click here, and actually, if you scroll down all the way, you'll see Trusted

18
00:01:15.160 --> 00:01:16.160
Sources.

19
00:01:16.160 --> 00:01:20.880
You're going to want to click Edit Sources and then click here, and we'll be able to

20
00:01:20.880 --> 00:01:24.780
add the current IP here as well.

21
00:01:24.780 --> 00:01:30.740
So I think if you start typing, you can also Google my IP, and your IP address will come

22
00:01:30.740 --> 00:01:31.740
up here.

23
00:01:31.740 --> 00:01:35.180
And this will change depending on if you're on a different network, so just keep that

24
00:01:35.180 --> 00:01:37.500
in mind if you are having issues connecting.

25
00:01:37.500 --> 00:01:41.420
You do want to click on this, add it here, and then it should be added.

26
00:01:41.420 --> 00:01:48.380
If you go to the top here, you'll also see in the connection details.

27
00:01:48.380 --> 00:01:52.180
I'm not going to show the password here, but if you plug in all this information, this

28
00:01:52.180 --> 00:01:54.100
is how you will access the SQL data.

29
00:01:54.420 --> 00:01:58.980
So you guys have access to this, it's owned under your company, it's how it's set up,

30
00:01:58.980 --> 00:02:03.980
and the next step we're wanting to use, if you're on a Mac, I highly recommend using

31
00:02:03.980 --> 00:02:12.660
a tool called MySQL, sorry, it's called SQL Ace, if you just Google that, I can drop a

32
00:02:12.660 --> 00:02:13.660
link below.

33
00:02:13.660 --> 00:02:20.340
But it's a great little tool, it's totally free, and you'll go in and plug in that data

34
00:02:20.340 --> 00:02:21.540
here.

35
00:02:21.540 --> 00:02:25.580
So when I open it for the first time, you'll see something like this, and you'll plug in

36
00:02:25.580 --> 00:02:31.580
all those values, name, host, username, password, and all these different variables.

37
00:02:31.580 --> 00:02:35.900
You can actually save that, so then it's saved to your computer, and the next time you want

38
00:02:35.900 --> 00:02:41.100
to come in and access that, you just simply double click, and it will go in and open up

39
00:02:41.100 --> 00:02:44.880
everything in kind of like a nice spreadsheet view, and you'll see there's different tables

40
00:02:44.880 --> 00:02:48.660
with all of your data all stacked in here.

41
00:02:48.660 --> 00:02:53.220
So you can see all of your user data, for example, there's things like passwords that

42
00:02:53.220 --> 00:02:57.740
are masked and encoded, so those aren't the actual passwords, but this is a great way

43
00:02:57.740 --> 00:03:04.540
to just browse things, you can go up to the top here and hit export, various information,

44
00:03:04.540 --> 00:03:10.460
you can also filter, let's say I only want to look at people who equal admin, you can

45
00:03:10.460 --> 00:03:15.680
do a quick filter, and now it just filters all the admin users there, and so forth.

46
00:03:15.680 --> 00:03:20.760
So great way to do that, this is obviously if you just want to browse, export things,

47
00:03:20.760 --> 00:03:25.440
you can do that here, you can also plug it into Looker Studio, I'll make another video

48
00:03:25.440 --> 00:03:30.800
for that, but you can see that things like analytics are actually just a table inside

49
00:03:30.800 --> 00:03:37.840
of this spreadsheet, and in this particular case there's over a million rows in this table,

50
00:03:37.840 --> 00:03:42.760
and so a lot of big data and stuff that can be managed through this, but now you kind

51
00:03:42.760 --> 00:03:45.960
of have direct access to your database.