cPanel beginner tutorial 6 - How to set up a database
HTML-код
- Опубликовано: 10 сен 2024
- 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
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.
Thanks for the first baby steps, wow this is different to DOS stuff, I hope my 70 year old brain can keep up!
True
Thank you so much. Very easy to understand. Saved me a lot of time and frustration. Subscribed!
Very helpful sir. Very helpful.
Should all the c panel tutorials you have made be followed before building a website. complete novice here. thinking about making my first website
hello i have question
i want create a data base but every time i face the prefix error can you guide me
thanks a lot, it really worked
i forgot to give my user permission u saved me thank u
Quentin i love you ! YOU ARE KING ! THANK YOU
(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?
Thanks
You just saved me. Many thanks.
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.
but how do i add that database to the localhost user pass data thing
Many thanks for this, awesome stuff!
hi. how about i already have my own database? can i upload it?
Where do I find my hostname?
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…)
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.....
I have do all the step by when im going to phpmyadmin there is nothing there
me too
Hey, do you have any idea why I don´t have the "DATABASES" section in my cPanel? Only Files, Domain, Email, etc, etc.
Probably because your hosting package does not provide databases.
my website was hacked but thanks God i downloaaded the zip file and database but how do i connect it ?
Super, thanks!
Thanks Alot
why not make the databse on phpmyadmin only vs going back to cpanel and then coming and looking at phpmyadmin? waste of time
very helpful, thank you
how can i make unlimited database in c panel ?i am hosting 1gb
Thank you!!!!
I love u u r my king
where I see the hostname of my database
It's more than likely localhost, otherwise your hosting provider would provide the name somewhere.
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 ????
That is done in your PHP code. Look for a PHP tutorial on that.
Thanks for reply man... I solved it... thanks for the help...
Will this work in namecheap c panel? #newbiew #namecheap
CPanel is pretty standard. So.. probably. but sometimes hosts customise their version, so also, maybe some steps will be different.
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
:(
Thanks