cPanel beginner tutorial 6 – How to set up a database


Stay Away! – The Tech Support weekend staff don’t know if they are coming or going. You take a chance to fix problems during weekdays, but not able to be fixed… I had to call 5 times for a small problem. The price is good but you get what you paid for… I wouldn’t renew my account even if they paid me… Debra, USA, crossborderseminars.com


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: https://www.facebook.com/jozituts
twitter: https://twitter.com/jozituts

Follow my personal social media pages:
facebook: https://www.facebook.com/quentin.watt
twitter: https://twitter.com/QuentinWatt
youtube: https://www.youtube.com/QuentinWatt

Quentin Watt Tutorials

23 Comments
  • Pling Plong
    Posted at 21:44h, 06 April

    Thank you, this really helped me. I had to rewatch it twice after going trough the entire cPanel tutorial series, but I'm pretty slow so it couldn't be helped.

  • Hilko kriel
    Posted at 13:56h, 05 June

    Hi Quentin
    I've been an avid follower of your videos for quite some time (HTML, CSS and now cPanel 🙂 )
    Really enjoy your videos, especially since it's local.
    Would you mind if I made reference (and add links) to your videos on my Company page, LinkedIn and Facebook profile?
    My Company supports small businesses with Computer Literacy Training (and other services) and your videos have awesome content that could really be of value to them.

  • Akash Thakare
    Posted at 05:28h, 25 September

    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 ????

  • Phoenix kx
    Posted at 12:44h, 29 September

    Thanks for this video . It was helpful for configure on a cPanel server rented from datasoft http://datasoft.ws/

  • viviviha
    Posted at 16:35h, 11 November

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

  • Nordin Zaidi
    Posted at 07:37h, 17 November

    Hey Quentin, u really improving your tutorial production with that little music at the end 😉 Like it and thanks for this Cpanel one.

  • M L
    Posted at 18:11h, 14 January

    The biggest problem about tutorials nowadays is that everyone talks way to damn much about stupid shit. We don't want or need your opinions or life story just teach the damn thing.
    Spent about 5 minutes on this channel.
    4 minutes watching this crap and 1 minute to write this in response of your crap.
    Good day.

  • Heroic InfoTech
    Posted at 07:31h, 06 February

    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…..

  • Suman Jha
    Posted at 23:15h, 10 February

    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.

  • iPHYZLL ,
    Posted at 18:49h, 01 March

    Quentin i love you ! YOU ARE KING ! THANK YOU

  • Mimi Neko
    Posted at 14:13h, 04 March

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

  • Isaac Tenba
    Posted at 13:44h, 16 May

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

  • dweb world
    Posted at 08:05h, 05 June

    (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?

  • prottoy roy
    Posted at 12:06h, 24 July

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

  • Peter Nicholson
    Posted at 06:44h, 31 October

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

  • L A
    Posted at 15:41h, 26 March

    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…)

  • En Baha
    Posted at 05:31h, 08 June

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

  • Kajal Irani Hostonpdl
    Posted at 08:45h, 03 October

    Thanks

  • Alphaxard Gacuuru
    Posted at 10:43h, 08 November

    You just saved me. Many thanks.

  • Eduardo A
    Posted at 13:31h, 27 November

    Thank you!!!!

  • Rolando S. Bouza
    Posted at 11:31h, 29 November

    Super, thanks!

  • Surinder Shanker Anand Artist
    Posted at 03:44h, 08 December

    Simple and to the point…. thanks.

  • Aslam K
    Posted at 06:22h, 20 December

    Nice video rented a cpanel server from datasoft for details visit http://www.datasoft.ws