MySQL Remote Access to MySQL Server on Linux CentOS 6 3 Part 1

3Ds Max 2010 Tutorials Adobe After Effects Tutorials Adobe Photoshop Tutorials Playlist Adobe Premiere Pro Tutorials Playlist AJAX Tutorials Playlist Android Application Development Tutorials C Programming Tutorials C# Beginners Tutorials Playlist C++ C++ GUI with Qt Playlist C++ Programming Tutorials from thenewboston C++ Programming Tutorials Playlist Cocos2D iPhone Tutorials Computer Game Development Tutorial CSS Dreamweaver CS4 Tutorials iPhone Development Tutorials Java (Beginner) Programming Tutorials Java (Intermediate) Tutorials Java Game Development with Slick Playlist Javascript JavaScript Tutorials Playlist jQuery Tutorials Playlist MySQL Database Tutorial Objective C Programming Tutorials PHP Programming Tutorials PHP Tutorials Playlist Python Programming Tutorials Ruby Programming Tutorials Playlist Unreal Development Kit UDK Tutorials Playlist Visual Basic Visual Basic Tutorials Playlist XHTML XHTML and CSS Tutorials Playlist

---

Closed Caption:

a look into this video tutorial and I'm
stay with on
and today we're going to be talking
about a.m. axis in your mosque or server
remotely
I'm now basically in the previous
tutorials of installed Moscow server
added ingratitude uses and stuff like
that but for
for the sake of this tutorial wanted to
go to everything from the beginning
the so anyone else watching it knows the
exact steps that you want to do
disc isn't gonna get confused by the
stuff that we've done already k so let's
get started
now the beginning bit of installed a
mosque well I'm just gonna run through
really quickly
I'm gonna leave a little link-up right
now to
so you can see the slow version K but
this is a scan of life through it and
get to a stage have actually adding
users
I think changing the configuration site
without further ado
let's go on so many to be root first
full and say YUM
a installed moscow well I Moscow
services can fly through
and find the pact is that when its
download
say yes to download them scan ago of
download for packages
and install tense when the checks now
installing installing
fine and complete
a 10 ish script clear screen by pressing
Control well I'm
now that installed let's just say so
that
a.m. must quote days can run
on server startup K and if it crashes
then the moscow several will start up
when the event that has crashed okay
missing you want to do is actually
starts
the moscow service itself or the Damon
presses initialize never think is give
us all the
instructions of what we gotta do setting
the root password to
destination that we gonna do this once a
user on
been mosque well secure
clips installation
K we haven't got a free pass what set of
removed mosque were completely
cases no on this this note databases or
anything soap to say
yes to set the root password with a set
it with password
carpeted floors of season strong
password
remove anonymous users disallow root
login remotely
yes removed estates buy snacks is to it
yes cake we look pretty stable now yes
K that's right now done case now we know
that
moscow's up money in it will stall on
server startup what's going
ru can access this one Moscow server
remotely therefore can only access it on
this one
this will compete with self a.m.
and the shit okay so let's now look into
the moscow server
to say mask well dash pay enter help us
with password
this is press Control dealt it's great
now let's just look at the
I'm host the you stable so slits
everything from
moscow well day to place in the user
table lets you see here we got to use is
both rates and and DEF host the first
house in 27 don't see why
.co 8.1 and in the other local host to
the 1271 is that the loopback address
and the second one is local high so
means we can access it from this one
computer
for the local host and then any other
processes
can access it through then that the loop
actress
and so on cut the so good so now what we
do is add a user for myself
David cake so he's got the exact same
privileges
as and the roots because I think
potentially what's looking
as root with it okay so will say first
who is create
use up and say David first full
127 talk 2.1 K and then
identify it up by
then password once again K and then
we're gonna do another one
of then like a house on a bill to Mira
what
the router Scott basically k welcome to
delete the route which can leave the
room way
the way this but we're gonna have my
user to be in full control over
case in the other we've got this
question its grant privileges to David
place with a crawl to give me every
single privileged
race say privileges after this and there
was a
on my say every single database Kate
every single table
every single bite database them say to
so which you so we give a mistake
mcguinness to David
I'm acts and then local house when it is
twice
and then we'll say with or with
grant option case it means the likkle
and the ability to grant
uses to other people say into know when
it's just
at one for the 127 those who adopted the
right one
and this place at it there K
that's basically it done cell it's now
safe flush
privileges to make sure things loaded
going
time we're gonna say I'm flush host as
well just
to know that I'm both things whips
both teams have been flushed Spurs
control it's clear the screen
and now we can say select a host
you sir from mosque well
you some and ice casino we've got a
cheap liquor
I'm user of routes but with the name
David this time
and actually the same password but you 1
I'll see have different passwords and
strong passwords
but the sake claritin here which issues
in the password of
text to form password okay so now that
we've done this
let's look out as root shell way and
it's a sacred
on this look fucking as David place
let's say you said David
and then password let's go back in
just press Control out to clear let's
say and so let's use the first IPL
as you can see this David at local host
is the
locked in now for the sake purposes less
the
let's quit out this game tight control
effort to clear
and it's now a look in this time using
use David
but host of 127 talk to adopt one
and then the switch paste for password
and just control helps clear screen and
then
select user once gain and we're still in
as the local host because
the IP address has been resolved I'm to
this
is no such thing to really to worry
about K
I said now that we've done this we want
to know that we can access it
room remotely a okay now
for the sake purposes at this week in a
poor use on here change as well
and we're gonna make a database for
James I'm just to show the difference
%uh for a person can access
k so let's just say I was stopped in its
capital letters because it's annoying
and create user I would call James
thats I am local host
K actually nice change is gonna be on on
the other machine
K yeah it's gonna be on and the other
machine which will show you in a minute
richest which is so it which one
cheese Tendo Tendo 10 dot 10 K
so what now access on tend to attend or
10 dot
10 right we can use the IP address
and then identified
up by saddam to stop using it
on part case that's not done
and now let's make it database for James
cases say
create I'm create database which is
prefixed with the baby
and saint james' a
as a subject to entertain case we got
will take place
created create databases sorry create
database DB underscored James
now that's created now let's create
privileges for James just on this one
database on every single table that they
make
on this one day to place let's say but
grants
okay and will say all
to it and on
this time we won't say stole what to say
DP
James dot start so on this states-based
on
every single table and we given all
privileges to it
so potentially can do ever think you
want to this one database
K and I'm a safe I'm
to then James thats 10 dot 10 dot 10 not
10 so this one host
callous one computer can access this one
database K
I'm but we're not going to give him the
grant option right
so it's just we like that now let's just
say and flush
privileges analyst
just flick free see if we can find it
there a-plus house as well
the stealth done okay so now we can
society
I am showed databases
first IPL cut and it's conceivable and
DB change now
let's just see who's locked in festival
here select user
is me locked in so now this locale as
David
just to show you the a.m. what happens
when we try to login
as James so this assay you sir James
with password
type in password axis tonight because
it's not on local host
the Cape sits now just a look back in
as David avonex find
control well to clear the screen case
and now we've got james caan even look
in on this war machine
which is what we want as well because
hit we want to be able to login
on the other machine now in order for us
to be able to lock in on the other
machine
we have to edit some think I am
after edit something on the actual Linux
server role for the law school
machine itself seles a sec we're on here
take to chill out to clear the screen
and now within states when it
edit the malloy kotkin
Squalicum file rather than comp file
a.m. white dot CNN file and one side
appear
K what the issue have to be which
obviously to access this
and just basically within sight at this
maestro de bracket area soap beneath it
witty to say blind address K
now the address that we're gonna buy
into and bike defaults
is 0 .co.za right dot 0
case it means that every single IP
address and can
access actually nobly to change so it's
unlikely that he can access
to we could at 0 .co.za I don't see
right
then everyone can access it but we're
gonna paint
the IP address this war machine which is
then blind dash
address equal this machine the Cape
this as as you can see down here right
the IP address of this machine so I
didn't forget which machine I'm using
on I guess that's basically that fit
their
so we just press and escape coal on to
be cute equipment
exit now off to the spike in these
changes were actually two restarts
and the maestro service salacious a
service mosque built the restart
that's potentially the motion its state
now if you've only got those settings
within sight of your my doxie NFL
that everything's gonna be fine now if
you've got a huge amount list about
things you gonna have to research
up some other items within it because
they might stop
and you should be enough to do this but
potentially all sent us when you install
MySQL server
that's 34 and m wide or CNF all that you
can make it
so now that the Moscow service I'm has
been restarted
am we should now be able to access
I am this machine such
this POSCO serval on another machine so
for the second purpose is this well it
is an open up another terminal
K and SSH to my other machine
to we wants David
up there to its fine
cut snow now on all my other machine
a which sets the world such as well
because this is a virtual machine with
someone in
I'm in the background okay so now what I
want is a once a
MySQL I'm you some
home James K and and this machine just
to show you
for quickly obviously is then
a get the IP address attend at 10 not 10
not 10
case this is one that we want to work
with right
so let's say marceca well you sir
James p password
and we still get access denied for user
James at local host
K a no there's a reason for this list
first full ping a.m. top 30
and we get the the Arts aback which is
no problem now that's just leave this
town
come back over to hear now we've got the
mosque well
service running K so this one time
should get this right at once the on
their
can we've got the moscow service running
I'm on here at the moment
and this is their my other machine can't
I'll sorry
been stupid thing that's what we're
local hosts obi-wan
I'm at thirty okay so this has taught us
again for clarity of
gots to the hosting their
but it's a week didn't get this just do
this once again
MySQL touched you James is the user to
begin looking with
and we get to 'em supply the h2 and
switch
and say that the IP address the machine
which we wanna up Collecti
and the Dutch p so snouts aside password
played cannot connect to moscow serve on
this IP address
get this is the next in the windy today
K because although we've set up the
moscow server
we've set up to use is we've set at up a
database for James
if it can't get through the IP the if I
warn you like P tables
I'm then whenever gonna get the
connection there for saying that they
can't connect
to to moscow service so we have to open
up port 3306
when the input and output chain of how I
P tables
K of I'll follow or so this just press
patrol L to clear and we need to open up
how will I P tables follow nell a we
could just do it from
at the command not here capital time
what
tight slits open this up now this is the
default settings
of your I'm CentOS machine on your
firewall when you install it now what we
need to do
is beneath the port 22 so the SSH and
Pelham
element of it just press licensor then
dash I and then kemper and we want then
the protocol of TCP and we wanna say the
AM to match
I'm gonna matched I am sorry when a much
States
K and the state that we matchin case new
and a stop polished
K and then we're gonna match also than
TCP
and the destination port is gonna be 33
06
K and they will say che for the action
and the action is gonna be except
K that's pretty much it now we can see
the on our
help chain the default a policies except
anyways we can eat at a rule
I'm to the output chain case a wall okay
and we're not running
I'm any network address translation
therefore we don't have to worry about
forward
chain either K so this will do perfectly
fine
ciskei coat on wk square because we've
updated our IP tables
with any to restart and the IP tables
or used to restore function and so on
but what to say
likely tables restarts everything's been
fine
now to come back over to alabama she
know
K which is the one which of ssh2 to this
is a
10 dot Tendo 10 dot 10 K
we can now run this funny game
Supplier password and as you can see
we're now in
McKay site help this work this is still
the question
alright why did like if the IP address
in the host table
and a what a look if the IP address of
the host
rather than of the MySQL server
I can explain this in the next tutorial
imparting okay so for the time being
we've got everything done now in the
second tutorial I'm gonna slow down
and I can explain everything okay say
don't worry about it right just come to
the next tutorial and we can slow down
and we can talk for it
what is exactly with done and slow time
a cut
site look for to seeing you in the next
tutorial
but but what