cPanel beginner tutorial 6 - How to set up a database

In this tutorial you will learn how to set up a mySQL database in cPanel. I cover, the three steps of creating a database, creating a user, and assigning the user to the database.
Playlist description
---------------------
In this tutorial series we'll be learning how use the everyday tasks a web developer or webmaster needs to know. These tasks include managing files, MySQL databases, email accounts and more.
Links
---------------------
Visit this tutorial on my website: www.jozituts.com/
Follow Jozituts on social media:
facebook: / jozituts
twitter: / jozituts
Follow my personal social media pages:
facebook: / quentin.watt
twitter: / quentinwatt
youtube: / quentinwatt

[@arsenaIfans]

It has been 8 years ago, yet here I stand, all I can say is that the tutorial is of exceptional quality, and extremely beneficial.

[@peternicholson4417]

Thanks for the first baby steps, wow this is different to DOS stuff, I hope my 70 year old brain can keep up!

[@antoniofuller2331]

True

[@darrellludlow]

Thank you so much. Very easy to understand. Saved me a lot of time and frustration. Subscribed!

[@LocalLionMarketing]

Very helpful sir. Very helpful.

[@lgarnz4314]

Should all the c panel tutorials you have made be followed before building a website. complete novice here. thinking about making my first website

[@muhammadumersaleem1298]

hello i have question
i want create a data base but every time i face the prefix error can you guide me

[@amosmandizvidza8503]

thanks a lot, it really worked

[@keneandigitaltechnology9337]

i forgot to give my user permission u saved me thank u

[@iphyzll1091]

Quentin i love you ! YOU ARE KING ! THANK YOU

[@dwebworld8648]

(XID 7cwqsc) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table). I am facing this problem when I create database. How to solve it?

[@KayembaJoel]

Thanks

[@alphaxardgacuuru1794]

You just saved me. Many thanks.

[@sumanjha1951]

i have taken full cpanel backup, i was having problem with website so i
was deleting public_html. but by mistake i deleted complete cpanel. now i
trying to restore it getting error "Your PHP installation appears to be
missing the MySQL extension which is required by WordPress.". i had
restored separately home directory and mysql.

[@axeleli6845]

but how do i add that database to the localhost user pass data thing

[@AfricanFlightStar]

Many thanks for this, awesome stuff!

[@mimineko9902]

hi. how about i already have my own database? can i upload it?

[@MrAlexGolovin]

Where do I find my hostname?

[@LayGraPhix]

My database work fine on localhost. but importing database online gives me below error
Error
SQL query:
--
-- Constraints for dumped tables
--
--
-- Constraints for table `comment`
--
ALTER TABLE `comment` ADD CONSTRAINT `comment_ibfk_1` FOREIGN KEY ( `user_id` ) REFERENCES `user` ( `user_id` ) ,
ADD CONSTRAINT `comment_ibfk_2` FOREIGN KEY ( `post_id` ) REFERENCES `post` ( `post_id` ) ;
MySQL said: Documentation
#1005 - Can't create table `akintltd_trial`.`#sql-aef76_9094ed` (errno: 150 "Foreign key constraint is incorrectly formed") (Details…)

[@heroicinfotech6486]

nyc video but i cant shown contact database from my uploaded website.
it follows that, which part i used database that all part i doesnt show in my site.....

[@ron-95]

I have do all the step by when im going to phpmyadmin there is nothing there

[@TheNabzzzzzz]

me too

[@kirppahdus1]

Hey, do you have any idea why I don´t have the "DATABASES" section in my cPanel? Only Files, Domain, Email, etc, etc.

[@QuentinWatt]

Probably because your hosting package does not provide databases.

[@dennyexpressgroup]

my website was hacked but thanks God i downloaaded the zip file and database but how do i connect it ?

[@RolandoSBouza]

Super, thanks!

[@IncredibleGilgitBaltistan]

Thanks Alot

[@samdell2110]

why not make the databse on phpmyadmin only vs going back to cpanel and then coming and looking at phpmyadmin? waste of time

[@Bininandra]

very helpful, thank you

[@prottoyroy4069]

how can i make unlimited database in c panel ?i am hosting 1gb

[@hyber007]

Thank you!!!!

[@WhiteOwlStudios]

I love u u r my king

[@madabang7]

where I see the hostname of my database

[@QuentinWatt]

It's more than likely localhost, otherwise your hosting provider would provide the name somewhere.

[@BAdBoys_2807]

this tutorial was fantastic... but i have one problem, Hope you will reply..
lets say i have create above steps which is shown in video. like create database DB, and an user, user.
so now if i want to make connection to database, like mysqli_connect () function how to do that .. can you solve my querry ????

[@QuentinWatt]

That is done in your PHP code. Look for a PHP tutorial on that.

[@BAdBoys_2807]

Thanks for reply man... I solved it... thanks for the help...

[@pablogonzalezrobles4429]

Will this work in namecheap c panel? #newbiew #namecheap

[@QuentinWatt]

CPanel is pretty standard. So.. probably. but sometimes hosts customise their version, so also, maybe some steps will be different.

[@WaqarAli-bk3ug]

boring style you are using to teach also speaking alot and unnecessary things short video will attract to watch this style will not make to be best teacher

[@QuentinWatt]

:(

[@kajaliranihostonpdl3700]

Thanks