How to quickly create a database that we'll use for wordpress so what we need to do is
we need to be in cPanel and from cPanel we will go to the databases section and
press my sequel databases tab once we'll press that a new tab will open and from
there we'll be able to create a database and since this database is gonna be for
a test database I'm just gonna call it test that mr. Rick comm which is mr.
Rick calm is my website so I'm just gonna create test mr. Bourg calm and I'm
gonna hit hit create database that will create a database for me
now I'll take this database name actually I'll just remember so now the
next step is we need to create a user for this database so your WordPress
website is able to have access to this database so I'll give it a user name
I'll say test user I'll give it a password
great I have given it a username and a password and now what I'm gonna do is
create the user hmm okay so there's already a user named test so well I'll
have to do is create another user I guess yes I'll have to create another
user so let's say you test mr. Rick dot-com let's see if it like that now it
doesn't so let's make it like that let's just generate password because I wanna
have password that I can use in this video tutorial because I don't want to
share a password that I use in day to day so this will be able to password I'm
just making it quick copy of it great let's try saving this
it's being a little bit slow okay great we have created our database hey uh
sorry database user what we need to do now is we have to go back and then go to
the section where we can add user to database we'll say test mr. Rick calm
and user and we want to assign tests of mr. Rick comm database to it and this is
an important step I mean because that's where you give permissions to your table
slash database to this user that work like WordPress will use it'll say add
and once you say AB it's going to ask which privileges you want to give it so
for WordPress case you'll have to assign all privileges and say make changes and
that's it and now your database is all set to go for WordPress so now what
we'll do is we'll go to WordPress and that's where we wanted to use our like
that's it that's basically like the WordPress installation page where we
want to use these details to be able to install WordPress so we'll just since we
have all these details like database name username password and database host
which will be just localhost and this case we'll just use that and let's say
let's go now database name was test dot mr. Eric calm right and the username was
test
mr. Word and the password was this that we generated it will be localhost now
table prefix is optional you can change it if you want
if you don't want to be don't changes I'm just gonna call it tests in this
case you can call it whatever and that's how your tables will start let's say a
new table will be created by wordpress it will be called test new table that's
how WordPress will create your tables so I'm just gonna say it test I'm gonna
summit that and once that's done it's gonna gonna ask if you want to run the
installation and it's giving you a confirmation I all right Sparky it's
saying all's good WordPress has been
successfully able to make a connection