Detailed Notes
This is a short series to help you get started on Debian 12 with a LAMP stack to install WordPress on our server. We continue from our Apache 2 install with PHP running and setup the database so we can launch and login to WrodPress. We wrap up with the WordPress installation and configuration.
You can learn more through our online classes at https://school.develpreneur.com and register for free. Registration will add you to our email list, and you will periodically receive coupons for courses and notifications of the latest releases.
Transcript Text
[Music] well hello and welcome back uh last episode we were working on building out a lamp server in dbn 12 with the PHP version 82.7 is actually where we're at and this episode we're going to continue with this and we're going to dig into to putting together uh our database and getting some of those pieces into place now we have gotten uh we've got our Basics up what I do want to do is I'm going to get Maria DB in and let me do and let's see if I can get it all in one shot it's going to be our back end Maria DB we could use just as we used our uh my SQL but we're going to use Maria DB this time around for our back end and here we go so okay so let's see authentication is required to start multiple identities can be used for authentication choose an identity to authenticate I'm going to do uh both can I do one comma two uh no okay said the last thing I want is uh here we go okay so I'm going to go ahead and just uh do it as I'll start it as admin oh there is no password whoops so I'm going to pass it as me because I do have a password there we go um synchronizing same thing uh reload authenication complete uh why okay there we go okay so we finally got through all our little stuff Uh current password for root I believe is none um let's see second password using nobody can log in without proper authoriz enable unique socket authentication yes whoops so we need the default password so let's try this first uh root okay so see suu now if I just do my sequel okay uh and I can do so I can come in as root if I want to I create a user um let's leave it at this first so who am I uh who am I all right I'm rout so let's go back to uh so I've got my seat or Maria in uh it's probably enabled and so I want to do secure installation I think I can do it just straight here there we go so current password is none switch to uh or using that a no we can log into it without proper authorization oh so I can safely answer no okay uh so you can safely answer no uh remove Anonymous users yes disallow rout login remotely yes remove the test databit yes reload privilege table yes okay so now so um I'm not going to be able to log in as root oh I guess I am okay I did get it set up so all right so I'll set up here and uh where am I at okay so I'm on my so I have my database configured so now I can I go do uh get my U let's see I want to get I want to get data the WordPress stuff well while I'm here uh let's do this I think I've got it all let's see so I'm going to create a database for WordPress um and let me let me save that oh so here we go so that's my WordPress [Music] user I want to use that I think I probably will well let's see we'll come back to this um let's do because we're going to restart it in uh we're going to do with this within WordPress so let's see WordPress DV and I'm going to create a databas well let me see let's go this way so what I do need to do is I'm going to get the latest WordPress first um I don't want to be rude wh let's make sure I've got who I am all right back to my guys so I'm going to get my latest uh why not oh I'm not in my home folder that's why let's try that again okay so let's get that cool now I can do that I can do a gz- d uh what was that call whatever I call did I call latest yes so I'm going to uncompress it and now I'm going to go to my I go down to my rot HTR slash HTML slash okay so if I go there oh sorry R www HTML okay so now I've got some B whop some Basics here and what I want to do is I'm going to take all of that I'm just going to dump it basically here as like the WordPress piece um it's a little different so what I want to do let me do this first is uh let me get my stuff done because I think this may take a second or a minute uh because what I want to do is I'm actually going to make sure that I put it at the right level which is probably going to be not not exactly the root so let me while I'm here while I'm waiting for that let me go look over here on another server okay cool he's there and if I do AAR d xvf uh let me before I do that ex that might be a lot of files if I go here let's see see if I go to HTML whoops then I want it to be uh let's see think I want to be here yeah so what I really want to do uh W oh HTML ww why do I reverse those I don't know why I did but okay so what I'm going to do is first because of what this is for I want to make this oh I have to make that as a pseudo and then I'm going to change it so now I can see that here I own that so I go here I'm going to do make uh I'm going to call this blog which is where I'm going to put WordPress just make sure I'm owning it right yep now I'm going to do what I call that latest yep so now I'm going to blow out all of the WordPress stuff and now let's see what if I do this if I go to oh I have WordPress here okay my mistake I'm going to move everything down a notch and I can remove move the WordPress and now if I go back to [Music] here okay so I am missing the MySQL extension so I need to get the MySQL I okay so to do this let's go back [Music] here that means I am missing and maybe I'm just missing my SQL I let's see if I've got one some somewhere I don't see it so I'm going to just install it anyways uh let's see where is let's go check let's make sure we got the right one so if I want looks like we failed to get the right all of our PHP stuff earlier so yes we do not have it so we're going to do a uh who am I okay so I'm going to do a pseudo appt install PHP my SQL let's see if it gives me the right one okay um I probably have to restart Pat G2 okay let's see if I get it this time there we go okay so now I need to get some stuff set up so I'm going to need a database name username and password so what I want to do is I could do it as that but I don't want to oh which is cool okay good that's what it was supposed to do pseudo suu Min SQL there we go uh show database is let's make sure okay so now what I want to do is I'm going to use a database that is one second let me see I know I'm over here I will come back to the mic in a second I want to make sure I get my database name right just because I'm moving from another because I want to keep it so this is going to be it's going to be RB BL and so now I've got my that is in there so I've got RB blog is there now I'm going to create a user and the way we do that is I'm going to give you the line and then I'm going to go back and tweak it so that I can do it properly it is uh let's see let me create my user first and when you do that is going to be create user you're going to give it the in here it's going to be local [Music] user at and that means it's going to be on the local machine oh local user is the name so I want to do I'm sorry Local Host I'm going to create just Rob as a database user and then I'm going to do identified by and I'm going to get a password and this is going to be my password into this so I'll be right back after I do this so let me jump back in I created my my user now what I need to do is I need to Grant so I want to Grant all on uh let's see I think it's Grant all privileges on star. Star to and is it user I think it is I think it is okay to let's do Rob at localhost and I think this will give me what I need and then I want to do flush privileges so I can get everything set up there we go and so now I should be able to log in as Rob and see stuff with my password okay so I can see RB blog so I'm going to come in here and I can come back over here and the database name is going to be RB blog uh username is going to be Rob password is uh Local Host I can keep it as WP I think let me look at what I had before because I want to keep it sort of the same so if I do use I just show tables okay it was WP so I kept that before um let me do this cuz there we go so now I should be able to do this see if it gets it started uh let's see so I probably don't have the okay so the database name is blog username Rob database host is that and let's see if that works there we go okay so I need to create this so I need my WP config and I'm going to do this here oh because uh where is does it allow me to read okay so I want to do this here so let's just do PHP we write that and let's see is that readable we're going to find out in second second and here we go since we're going to an R case uh we're going to move a uh another site into this so we're just going to do this we're just going to call this uh well we'll do this we'll go ahead and just put a name to it uh username let's make it Rob password I'm going to just make it a password so you can make your password whatever you be this is going to be your um this will be your admin user um if you don't already know uh let me do this get my email set up um I don't want to hide in search engines indexing it because I'm going to want to do that let's do wh and let's gohe and try to install WordPress it has been installed so now if I go back to my site I probably will see a yep there you go and so now I have my web my uh have my WordPress side up if I go to WP admin and oh let's see so I should be able there we go and now I have installed WordPress so we've got this working I have uh put the lamp stack I've got that set up have WordPress installed and uh the next thing we're going to do is we're going to say all right now that we have WordPress let's go pull this stuff and migrate from our our old WordPress version to this new one if you have any questions as always send an email to info@ developer.com and we'll walk you through this we're going to have scripts uh we'll have the the script as much as we can I think we can put it all in our show notes so it won't get messed up as far as any control characters anything like that and uh you should be ready to go so as you see you can knock this thing out fairly quickly maybe a couple adjustments you need to do depending on your uh your Linux version and of course if you have a little bit different if you have a different drro it's slightly different but really not that much you should be ready to go you can get this thing up and going quickly uh as always go out there and have yourself a great day a great week we'll talk to you next time well hello this is Rob from develop andur building better developers and we have a mastermind class that will be starting or actually several Mastermind classes starting in 2024 check us out at technology Mastermind 2024 4.com we've got all the information you need including some pricing early bird discounts up to 50% off but those are things that you're going to have to act soon there is an application process so go ahead and sign up today thanks a [Music] lot
Transcript Segments
[Music]
well hello and welcome back uh last
episode we were working on building out
a lamp server in dbn 12 with the PHP
version
82.7 is actually where we're at and this
episode we're going to continue with
this and we're going to dig into to
putting together uh our database and
getting some of those pieces into place
now we have gotten uh we've got our
Basics up what I do want to do is I'm
going to get Maria DB
in and let me
do and let's see if I can get it all in
one
shot it's going to be our back end Maria
DB we could use just as we used our uh
my SQL but we're going to use Maria DB
this time around for our back
end and here we go so okay so let's see
authentication is required to start
multiple identities can be used for
authentication choose an identity to
authenticate I'm going to
do uh
both can I do one comma
two uh no okay said the last thing I
want
is uh here we
go okay so I'm going to go ahead and
just uh do it as I'll start it as
admin oh there is no password whoops so
I'm going to pass it as
me because I do have a
password there we go um synchronizing
same
thing uh
reload authenication
complete uh why
okay
there we go okay so we finally got
through all our little stuff Uh current
password for root I believe is
none um let's see second password using
nobody can log in without proper
authoriz enable unique socket
authentication
yes
whoops so we need the default
password so let's try this first uh root
okay so see
suu now if I just do my sequel
okay uh and I can do so I can come in as
root if I want to I create a user um
let's leave it at this first so who am I
uh who am I all right I'm rout so let's
go back
to uh so I've got my seat or Maria in uh
it's probably enabled and so I want to
do secure installation I think I can do
it just straight here there we go so
current password is none switch
to uh or using that a no we can log into
it without proper
authorization oh so I can safely answer
no okay uh so you can safely answer
no uh remove Anonymous users yes
disallow rout login remotely yes remove
the test databit yes reload privilege
table yes okay so now
so
um I'm not going to be able to log in as
root oh I guess I am okay I did get it
set
up so all right so I'll set up here
and uh where am I at okay so I'm on my
so I have my database configured so
now I can I go do uh get my
U let's see I want to
get I want to get data the WordPress
stuff well while I'm
here uh let's do
this I think I've got it all let's see
so I'm going to create a database for
WordPress
um and let
me let me save that
oh so here we go so that's my WordPress
[Music]
user I want to use that I think I
probably will well let's see we'll come
back to this um let's
do because we're going to restart it in
uh we're going to do with this within
WordPress so let's see WordPress
DV and I'm going to create a databas
well let me see let's go this
way so what I do need to do
is I'm going
to get the latest
WordPress first um I don't want to be
rude
wh let's make sure I've got who I am all
right back to my guys so I'm going to
get my
latest uh why
not oh I'm not in my home folder that's
why let's try that again okay so let's
get that cool now I can do that I can do
a gz-
d uh what was that call whatever I call
did I call latest
yes so I'm going to uncompress
it and
now I'm going to go
to my I go down to my rot HTR slash HTML
slash
okay so if I go
there oh
sorry R www HTML okay so now I've got
some B whop some Basics here and what I
want to do is I'm going to take all of
that I'm just going to dump it basically
here as like the WordPress piece um it's
a little different so what I want to do
let me do this first
is uh let me get my stuff done because I
think this may take a second or a minute
uh because what I want to do is I'm
actually going to make sure that I put
it at the right level which is probably
going to be not not exactly the root so
let me while I'm here while I'm waiting
for that let me go look over
here on another server okay cool he's
there and if I do AAR d xvf uh let me
before I do
that ex that might be a lot of
files if I go here let's
see see if I go to HTML
whoops then I want it to
be uh let's
see think I want to be here yeah
so what I really want to
do uh W oh
HTML
ww why do I reverse those I don't know
why I did but okay so what I'm going to
do is first because of what this is for
I want to make this oh I have to make
that
as a pseudo and then I'm going to change
it so now I can see that here I own that
so I go here I'm going to do make uh I'm
going to call this blog which is where
I'm going to put
WordPress just make sure I'm owning it
right
yep
now I'm going to do what I call that
latest
yep so now I'm going to blow out all of
the WordPress
stuff and now let's see what if I do
this if I go
to oh I have
WordPress here okay my mistake I'm going
to move everything down a
notch and I can remove move the
WordPress and now if I go back to
[Music]
here okay so I am missing the MySQL
extension so I need to get the MySQL I
okay so to do this let's go back
[Music]
here that means I am missing and maybe
I'm just missing my SQL I let's see if
I've got one some
somewhere I don't see it so I'm going to
just install it
anyways uh let's see where
is let's go
check let's make sure we got the right
one so if I
want looks like we failed to get the
right all of our PHP stuff earlier
so yes we do not have it so we're going
to do a uh who am I okay so I'm going to
do a pseudo appt
install PHP my SQL let's see if it gives
me the right
one okay um I probably have
to restart Pat
G2 okay let's see if I get it this
time there we go okay so now I need to
get some stuff set
up so I'm going to need a database name
username and password so what I want to
do is I could do it as that but I don't
want to oh which is cool okay good
that's what it was supposed to do pseudo
suu Min SQL there we go uh show database
is let's make sure okay so now what I
want to do is I'm going to use a
database that is one second let me see I
know I'm over here I will come back to
the mic in a
second I want to make sure I get my
database name right just because I'm
moving from another because I want to
keep it so this is going to
be it's going to be RB
BL and so now I've got my that is in
there so I've got RB blog is there now
I'm going to create a
user and the way we do that is I'm going
to give you the line and then I'm going
to go back and tweak it so that I can do
it properly it is uh let's
see let me create my user
first and when you do that is going to
be create user you're going to give it
the in here it's going to be local
[Music]
user at and that means it's going to be
on the local
machine oh local user is the name so I
want to do I'm sorry Local Host I'm
going to create just Rob as a database
user and then I'm going to do
identified by and I'm going to get a
password and this is going to be my
password into this so I'll be right back
after I do this so let me jump back in I
created my my user now what I need to do
is I need to Grant so I want to Grant
all
on uh let's see I think it's Grant all
privileges on star. Star
to and is it user I think it is I think
it is okay
to let's do Rob at localhost
and I think this will give me what I
need and then I want to do flush
privileges so I can get everything set
up there we go and so now I
should be able
to log in as Rob and see
stuff with my
password
okay so I can see RB blog so I'm going
to come in here and I can come back over
here and the database name is going to
be RB
blog uh username is going to be Rob
password
is uh Local Host I can keep it as WP I
think let me look at what I
had before
because I want to keep it sort of the
same so if I do
use I just show tables okay it was WP so
I kept that
before um let me do this
cuz there we
go so now I should be able to do this
see if it gets it
started uh let's see so I probably don't
have
the okay so the database name
is
blog username
Rob database host is
that and let's see if that works
there we
go okay so I need to create
this so I need my WP
config and I'm going to do this
here oh
because uh where
is does it allow me to read okay so I
want to do
this here so let's just
do
PHP we write
that and let's see is that readable
we're going to find out in second
second and here we go since we're going
to an R case uh we're going to move a uh
another site into this so we're just
going to do this we're just going to
call this uh well we'll do this we'll go
ahead and just put a name to
it uh username let's make it
Rob password I'm going to just make it a
password so you can make your password
whatever you be this is going to be your
um this will be your admin user um if
you don't already know uh let me do
this get my email set up
um I don't want to hide in search
engines indexing it because I'm going to
want to do that let's do wh and let's
gohe and try to install
WordPress it has been installed so now
if I go back to my
site I probably will see a yep there you
go and so now I have my web my
uh have my WordPress side up if I go to
WP admin and oh let's
see so I should be able there we go and
now I have installed WordPress so we've
got this working I have uh put the lamp
stack I've got that set up have
WordPress installed and uh the next
thing we're going to do is we're going
to say all right now that we have
WordPress let's go pull this stuff and
migrate from our our old WordPress
version to this new one if you have any
questions as always send an email to
info@ developer.com and we'll walk you
through this we're going to have scripts
uh we'll have the the script as much as
we can I think we can put it all in our
show notes so it won't get messed up as
far as any control characters anything
like that and uh you should be ready to
go so as you see you can knock this
thing out fairly quickly maybe a couple
adjustments you need to do depending on
your
uh your Linux version and of course if
you have a little bit different if you
have a different drro it's slightly
different but really not that much you
should be ready to go you can get this
thing up and going quickly uh as always
go out there and have yourself a great
day a great week we'll talk to you next
time well hello this is Rob from develop
andur building better developers and we
have a mastermind class that will be
starting or actually several Mastermind
classes starting in 2024 check us out at
technology Mastermind 2024 4.com we've
got all the information you need
including some pricing early bird
discounts up to 50% off but those are
things that you're going to have to act
soon there is an application process so
go ahead and sign up today thanks a
[Music]
lot