Accessing MySQL Server via a GUI

In this video, I will show you how to access your MySQL server which could have been set up from a LAMP, LEMP, or even custom installation. In this video I use Sequel Pro, a free app for the Mac.

Join the official OceanCasts' mailing list: http://goo.gl/UVGmwj

Sign up using my referral link for digital ocean and receive a $10 credit: https://www.digitalocean.com/?refcode...

========================================­========
Intro & Outro Song:
Tobu - Mesmerize [NCS Release]
Tobu:
➞ SoundCloud http://www.soundcloud.com/7obu
➞ Facebook http://www.facebook.com/tob...
➞ Twitter http://www.twitter.com/tobu...
➞ YouTube http://www.youtube.com/tobu...
➞ Website http://www.7obu.com

---

Closed Caption:

cool
%uh
so if you recall a while back we were
headed installed lamp using the one
quick
installation method on the solutions web
site now this also applies to the lump
installation tutorial to so I'm gonna go
ahead
and I'm teach you how to connect to your
MySQL server because is requested
features for car go ahead and give this
to you
hurt so the first thing you're going to
want to do you wanna go handle computer
model
and we're gonna go ahead then connected
to that server
so I'm gonna open up terminal here
alright so what this open I'm gonna go
ahead
SSH into one of my servers so I'm going
to ssh into my surname which in this
case is dropped what
just to put the same thing here you can
accept this footprint
again this is different than what is
already listed on so when and how did
that mean noon
look hosts list operates a notice Iran
now we have a default
my squirrel passer but we can't really
do anything with this yet we first have
to run this my squirrel secure
installation for so let's go ahead and
do that right off the top
let's go ahead and paste and in person
we wanted him to the curb password for
root so if you look up here we can see
that password
and we just wanna go ahead and peace
that inner rates and I wrote go
you know you're presented with a couple
on different things here that we have to
go up
ahead and address so the first thing is
do you want to change your password now
on
default you do you wanna probably change
this but in this case for this tutorial
you and me this alone
so many go and put a wider for you s com
away and for two people on our some just
a piece in the existing password I had
you know so I suppose to do om in do I
remove
anonymous users I highly suggest you do
you remove Yunus users because they can
enormous users can create here my Skoda
race if you have set up so armand is
this is just to remove any on possible
conflicts that word on happened lebanon
a simple
I'm walking into your system so do we
wanted disallow root login remotely
in this case known but again you're
doing whatever white whatever you want
I'm do wonder who the test database in
access to it
oMG if your production environment
however committee do and Latinos
on then we do want to go
include provisions air privileged people
now alright that's all done
so now we have to go ahead and I'm do
something else now so
next we have two allow for us to connect
to are my ski well on from a remote host
so we have two neighbors in the firehall
source go ahead and do that by type in
IP tables and then
we wanna go ahead and do dash day and
input because this is what we're this is
the feel that works like to hear
and then we're gonna we're doing is
allowing import we're going to go ahead
and select the interface which happens
to be though in this case on or
dissolution
on droplets that is eat though we won at
the Pete
going to a dash P which stands for the
protocol which is TCP in this situation
then again what we wanted to do a dash
am for TCP
in for the port that we're using wanna
type in
3306 we want to do
dash in Jaipur the method and that will
be except
great source impress entered in
we have lived at argument it looks like
all rights over wanna go hand in hand
did
dash dash deport re:
so let's go ahead now on and we should
build a go-ahead to IP tables taxi
we should go see that we have edited our
IP tables in which we did
we added this here alright so next I
wanna go ahead
and dont see if the maestro's currently
running suspended that's a net
stat and we're gonna do dash tune
and then we want to do the OP
okay so now we can see
old the dominoes colonel OP are kinda
people were
on to give you a pro closer so we can
see that we have the
on my secure sir Ronnie here because
that port 3306
but look at the local address is running
on know this first for local host but is
in your work for outside sorus so we
have to go ahead and do good that
additional configuration in order for
this to work
so we're gonna do now is a CD into the
my school directories however EPC for so
we can go ahead
in and it the
mom the to FIG file inside that which is
my tight
see enough so we're going this turns out
here we can see that
we want to go ahead and look at that my
diet Sienna to reduce
on you do see if you're not even read
user on
but we're headin do the annual my see an
apt
and looking ahead in just scroll down
this file a little bit
and we were just looking for the bind
address
so which is funny I bind address
gorgeous cursor over
to be ended and just cleared up that
current address
again this is the local host address we
want to put in the actual server address
so in order for your server just open up
Safari
in issue droplet IP address to minimize
that
just peace that inner so no go ahead to
control X to close out the input oh why
in there for that interest-bearing
you're good to go
bed the changes are not going to be
shown right away
we have to go been actually restart
MySQL server suspended at
to reduce service my squirrel restart in
my school it's restarting as we speak
and then
that's basically about it we have one
more thing when you do so we can go
ahead and connect with the sequel pro
has already used to connect to a server
so we're gonna go ahead and do with her
fingers through the MySQL
dash you dash are
were induced dash youth group in dash
peace good will be prompted for a
password
we have 10 to the pass for now sit
remember while ago
I entered a password and use the same
password on the city's for now
against house just a date change his
passwords
great time you hit after this password
alright so we're in
now the last thing we have to do now is
just do a grant permission so we can
grant
ourself axis to arm add edit/delete
databases from within sequel pro or any
other program you may want to use again
this works on Windows as well
so I'm gonna go ahead and do the phones
were gonna grape
all on
and they weren't this be for example the
name in the database
and then that the database
tables and we're going to
allow that to rue something new to
route at now again this is where
reasoning is what you can create
multiple users
and then this is going to be your actual
IP address at your home
so was actually fine if you don't know
that is so just go to
file 10 p.m. we can do
I her what is my IP great and that your
public address their
okay so we're gonna go ahead now and
just type in after public address
in that is wherever mine is so judgment
a than
alright
and a minute cause that's very close our
endeavor and do the following:
which is i down by identified see I D
and then this though the following is
your password for my school
so we're just gonna pay stand in there
and we are ready to go
source when a prisoner and we haven't
air it looks like
alright so justice billing issue Mishi
spellers quickly great so
now this is arm finish that after
surrendering
quit out this great so now
with your head internet to our databases
and whatever
on program you want to use so I'm in
eight UC GoPro for this tutorial
and we're just going to protect our
servers to reconnect
on for just an added a name for now to
him
put in the password to the server
dislike these new real
im gonna go ahead and eat a whose to the
server her in
pasted in there we release the database
arm just
partial for now please read it then and
we're gonna
and our port here we go ahead and
connect
to the ICC were connected op now if you
leave out any these previous steps
most likely it's not going to work
expecially if you don't add
the a grant or for my scopey-tone
add that and if you don't aren't allowed
the IP address
her if you don't repeat the firewall
quickly it won't work
go so it's report to make sure you get
those steps cracks just make sure you
get the area one which is right
is a mistake there okay so which urs had
here you can create a database
into me databases you everything you
ever imagine just how I like PHP man but
for
mcintosh our mentor teacher deciding to
do now again it all depends on what you
want to do if you're a Windows you want
to use our
a different program but your Mac see
gophers are pretty recommended product
i'm for the PHP in community okay so
that's it for today I hope this helped
arm
sir but those couple was going to hit
book pick up there home
but yeah dats it for today if you have
any questions please leave a comment
armed police like recruited subscribe it
is the US hope you
and that it for today so thank you for
watching