Tour of the WordPress Database with phpMyAdmin & Adminer WP Database Plugins - SQL & MySQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ต.ค. 2024

ความคิดเห็น • 110

  • @dontrez8412
    @dontrez8412 ปีที่แล้ว

    I've been building these websites and have avoided a lot of things. This is one of them...which is encapsulated inside of other things I'm learning. Thanks for the guidance.

  • @owbii
    @owbii 3 ปีที่แล้ว

    Love the fast pace of the video. fast and still learnt properly

  • @susantomkin1879
    @susantomkin1879 5 ปีที่แล้ว +4

    Thanks Joel. Clear, concise, to-the-point instruction. I like you addressing more than one way to get the job done. Eager to work my way through your other videos. A new subscriber!

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว

      Thanks Susan, I have a huge list of videos I’m getting ready to record. I’ll probably update this video as well to include WordPress Multisite. Let me know if there’s anything in particular you’re interested in watching.

  • @RoniWebly
    @RoniWebly 10 หลายเดือนก่อน

    God bless you for that!!!
    i was searching a good tutorial for this topic and you nailed it!

  • @PaulLundgren1970
    @PaulLundgren1970 3 ปีที่แล้ว

    New WP user here. Thank you for the excellent tutorial.

  • @naumankhan9125
    @naumankhan9125 6 ปีที่แล้ว +6

    Superb Sir, Really appreciated your way of teaching.

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว +2

      Thanks, I'm gearing up a more advanced series on WordPress Development, especially with the new Gutenberg Editor and how that will change theme and plugin development. I might also create a more advanced database video as well. Thanks for watching and let me know if there's any video you think I should create.

  • @cassandra190
    @cassandra190 6 ปีที่แล้ว +1

    Thank you for this video. It answered a lot of questions and explained concepts which I never properly understood before. A lot of info is packed into a short amount of time. I had to stop the video several times and think a bit to absorb what was just covered; that's no problem, because so much good info was in there. I learned a lot.

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      Thanks, I'm working on a massive update to DevWP which is my development training theme. Uploading a video on it next week. Stay tuned.

    • @armandoameer1361
      @armandoameer1361 3 ปีที่แล้ว

      i guess im randomly asking but does anyone know of a method to log back into an instagram account..?
      I was dumb forgot my password. I would love any tricks you can give me!

    • @enochroyal4258
      @enochroyal4258 3 ปีที่แล้ว

      @Armando Ameer Instablaster =)

    • @armandoameer1361
      @armandoameer1361 3 ปีที่แล้ว

      @Enoch Royal thanks for your reply. I found the site through google and Im in the hacking process atm.
      Looks like it's gonna take quite some time so I will reply here later with my results.

    • @armandoameer1361
      @armandoameer1361 3 ปีที่แล้ว

      @Enoch Royal it did the trick and I finally got access to my account again. I am so happy:D
      Thanks so much, you saved my ass!

  • @ChrisGeden
    @ChrisGeden 5 ปีที่แล้ว +1

    Great video. I actually didn't mind the speed that you went at, despite me not knowing everything about database stuff. It's easy enough to speed up the video, if needed, so maybe going a little slower would be more beneficial to other viewers. Slowing videos down just makes tutors sound...slow.
    Subscribed!

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว

      Yeah, I’m always trying to figure out the right pace. Especially with longer videos. With complex topics, I should definitely slow down a bit. Thanks for watching.

  • @Reji82135
    @Reji82135 4 ปีที่แล้ว

    Awesome man, need database deep leavel operations that is not handled so many people

  • @defariase
    @defariase 5 ปีที่แล้ว

    OUTSTANDING!!! The best on WP admin I've seen (and I've seen a lot!!). Thank you, sir!!!

  • @zubairmushtaq1634
    @zubairmushtaq1634 6 ปีที่แล้ว +2

    simply awesome , i m in notification squad

  • @hs-lb1493
    @hs-lb1493 3 ปีที่แล้ว

    nice basic tutorial about how wordpress use the database
    but what i really want is making forms and add data to the database from the outside interface

  • @oxblackiexo268
    @oxblackiexo268 4 ปีที่แล้ว

    Thanks Joel. You just got a new subscriber!
    I have 1 question please, if i have a form like wp contact form 7. if a person add his details. How and what is the safest way to add it into the database?

  • @GeneralDynamickx
    @GeneralDynamickx 4 ปีที่แล้ว +1

    Thanks for the nice video. But... What happened to Adminer? It is not availlable anymore??? Can I maybe download this plugin from someone, plz?

  • @newthoughtsenterprises8019
    @newthoughtsenterprises8019 5 ปีที่แล้ว +10

    Hi Sir, I cannot find the mentioned plugin. Plz help me out

    • @HotaraTakeo
      @HotaraTakeo 4 ปีที่แล้ว +1

      It's no longer available

    • @CrudChronicles
      @CrudChronicles 4 ปีที่แล้ว

      Did anyone find a similar replacement?

    • @raghedsalloum8590
      @raghedsalloum8590 4 ปีที่แล้ว

      @@CrudChronicles I found WP-DBManager plugin but I did not use it yet

  • @robertamaldini2908
    @robertamaldini2908 7 ปีที่แล้ว

    WOW YOU ARE THE BEST TH-camR WOW..WE LOVE YOU BROTHER...YOU LET US KNOW HOW THE WOLF DANCE ...THANKS A LOT OF .....GOD BLESS YOU AND YOUR FAMILLY......

  • @HirumaniNath
    @HirumaniNath 7 ปีที่แล้ว +1

    Thank you for making this very very useful Video.

    • @PixemWeb
      @PixemWeb  7 ปีที่แล้ว

      No problem, glad you found it useful. I'm working on a few more videos on working with the WordPress Database, basically on optimization and security.

  • @dontbeafraid5313
    @dontbeafraid5313 5 ปีที่แล้ว

    Hi thanks for this great tutorial. I am happy to find this.
    By the way, I also want to ask which file should go if I want to customised the look and feel of the WP admin dashboard, say I want to change color, font style, the Text (example instead of the word Product in woocommerce I will replace it by Services.
    Same goes to check out page and shop page. Thanks bro

  • @alinaz8243
    @alinaz8243 2 ปีที่แล้ว

    I believe the ARI Adminer plugin is not available anymore. Is there a similar alternative?

  • @SikhSkater.Gurpreet
    @SikhSkater.Gurpreet 4 ปีที่แล้ว

    Great work sir

  • @WahYarWah
    @WahYarWah 6 ปีที่แล้ว

    hi thank you for the nice lesson, what is the link of your video about the multi site database? thank you

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      Still on my to do list. Should get it done soon. Hopefully in the next 30 days. I have a bunch of videos on Developing a WordPress Website via themes and plugins. Stay tuned.

  • @sefemarketing3870
    @sefemarketing3870 4 ปีที่แล้ว

    Could you recommend further resources on wordpress database repair, optimisation and hack solutions?

  • @PEdulis
    @PEdulis 3 ปีที่แล้ว

    Thanks for your informative video, it explains exactly what the title says in a comprehensive way.
    I just looked for the adminer plugin but did not find it any more from within wordpress, so I looked externally and then found "This plugin has been closed as of April 5, 2019 and is not available for download. Reason: Security Issue.
    "
    Apparently, there is another plugin called adminer that is currently available in version 4.7.8. Have you tried this one and is it secure in your view?

  • @conspircaytheorysviewedina6481
    @conspircaytheorysviewedina6481 4 ปีที่แล้ว

    Mario Constantin: I think the video is quite good but it still does not answers the question: how do I insert the form7 data into Mysql automatically from the form-how do I link the form to MySql from the website? regards, Mario

  • @mergulho5054
    @mergulho5054 5 ปีที่แล้ว +1

    Very good, thank you!
    But I still have one doubt, how may I discover if someone created another administrator account in hidden mode?

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว +1

      Hi Mergulho, You could go to the users table in phpMyAdmin and check what users are created. you can see what level of access they have. If there's an account that seems to have greater access than it's supposed to you can either change the access level or you can further investigate via WordPress Admin Dashboard. In the dashboard you can go to your users and see who has admin level access. It should just be you. You can get greater control over your users with plugins like Members which I believe I have a video on and also the User Role Editor Plugin which is really good as well. Thanks for watching.

  • @stefcioagoodboy
    @stefcioagoodboy 7 ปีที่แล้ว +1

    Joel, quick question, can I Optimize all tables directly on phpMyadmin? For example, I use WP-Optimize it clean several things, but I got the tables postmeta, post, and option tables which were around 8-12 MB each. And I reduce to 1MB each just by selecting those 3 tables and clicking "Optimize tables" on phpMyAdmin... So I was wondering if I can safely optimize like that All tables? Thanks !!

    • @PixemWeb
      @PixemWeb  7 ปีที่แล้ว

      I actually do prefer to optimize all the tables via phpmyadmin. I frequently check the tables, repair them and optimize them from phpmyadmin since it gives you greater control. Just make sure to take a full backup.

  • @cabpil0t556
    @cabpil0t556 2 ปีที่แล้ว

    I'm a newbie doing my own site. I did delete and reinstall wordpress and after that it crash. Thanks for these tutorial. Hope i can set the database on my own. Its so confusing when its being setup by the hosting company

  • @ericjs961
    @ericjs961 6 ปีที่แล้ว

    Thanks for the video. I have a question. I would like to build a form where the drop down content is created from a query of a database. Here is an example. A user selects a U.S. State, (California), the results from a query filter only populates the Cities with those that are in the database. So, if California and I only have Los Angeles and San Francisco, only Los Angeles and San Francisco are listed in the new dropdown. Then after selecting Los Angeles, the output only lists facilities located in Los Angeles.
    Can you point me in the direction of a youtube video or link that might help me code this?

  • @jcapper2
    @jcapper2 6 ปีที่แล้ว

    Life saver man, thank you so much!

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      No problem, glad it helped.

  • @theshredguitarist25
    @theshredguitarist25 3 ปีที่แล้ว +1

    Im the 1000th like!

    • @PixemWeb
      @PixemWeb  3 ปีที่แล้ว +1

      That’s awesome. Thanks for the support.

    • @theshredguitarist25
      @theshredguitarist25 3 ปีที่แล้ว

      @@PixemWeb you are welcome! Thanks for the great content. I want to become a python sql developer! Do you have beginner tutorials for wordpress? Am i starting in the right place? I want to learn the fundamentals of databases in Wordpress.

  • @stefcioagoodboy
    @stefcioagoodboy 7 ปีที่แล้ว +1

    Great Video again! So How to protect properly the database?

    • @PixemWeb
      @PixemWeb  7 ปีที่แล้ว

      You will want to make sure that your web hosting account is secure with unique credentials, 2 factor authentication and make sure your database credentials are also strong and unique. Since the database works with WordPress or any other CMS like Drupal or Joomla, just make sure to only use trusted plugins and themes since they can insert information into the database.

    • @PaulLundgren1970
      @PaulLundgren1970 3 ปีที่แล้ว

      @@PixemWeb Is it recommended/good practice to also rename the default tables to make it more difficult for script attacks to do their work?

  • @andreiromania3
    @andreiromania3 2 ปีที่แล้ว

    I try to figure out how to find my old website that I created in WordPress. Site is not active anymore but it was created in WordPress so all the information is sometwhere there in the database. Where do I find that? If I type my site address with /wp-admin I get the message that there is an error because the domain is not active anymore, but I just want to enter the database with all the page I created. How can I do that? Thank you

  • @georgesmith3022
    @georgesmith3022 6 ปีที่แล้ว

    that was good tutorial on wp tables. i would like to see also how acf affects the tables, but i think i will try it on my own. thanks

  • @ApostolicPraiseSOM
    @ApostolicPraiseSOM 5 ปีที่แล้ว +1

    Awesome tutorial

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว

      Thanks. I might create an updated video to reflect WordPress multisite. What do you think?

    • @Reji82135
      @Reji82135 4 ปีที่แล้ว

      @@PixemWeb its sounds good

  • @salduccikheira6370
    @salduccikheira6370 3 ปีที่แล้ว

    Thanks for your video, Can I recover pages's content from the database phpmyadmin ? Merci

  • @nirmalvlogs3266
    @nirmalvlogs3266 4 ปีที่แล้ว

    sir I want to know can WordPress webpage host to MySQL database & is it ok?

  • @Curious_Cat706
    @Curious_Cat706 2 ปีที่แล้ว

    Hi Joel. Thanks for the great video. I backed up my site, restored it and found all subscribers were set to role none. How can I use the database to set them all to subscriber again? I have over 37K subscribers. Doing it manually is a nightmare :(

  • @MonteLogic
    @MonteLogic 5 ปีที่แล้ว

    Excellent!

  • @ruelagnes4277
    @ruelagnes4277 6 ปีที่แล้ว

    this tutorial is helpful

  • @vokechamp
    @vokechamp 4 ปีที่แล้ว

    Hi. can't find the adminer plugin, after search using the keyword adminer, maybe it maybe renamed, idk. Please help thanks!

    • @PixemWeb
      @PixemWeb  4 ปีที่แล้ว

      It’s been removed from the WordPress repository. It’s best just to use phpmyadmin

  • @robertamaldini2908
    @robertamaldini2908 7 ปีที่แล้ว

    THANKS AGAIN TEACHER...HOW CAN WE PLEASE HOST OUR LOCALHOST FROM HOME TO TEST THIS WITH PHPMYADMIN I MEAN OVER WAN BROTHER...?THANKS AGAIN AND I AM HAPPY TO FIND YOUR TUTTOR HERE...GOD BLESS YOU

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      I use MAMP for a local server. You can also try WAMP or Xampp. They are all great tools and they're free.

  • @FraternalHouse
    @FraternalHouse 6 ปีที่แล้ว

    Database is located @> Go To Your Hosting Companies CPanel >Databases> And Then Click phpMyAdmin.

  • @mohamedelhassenbellahi862
    @mohamedelhassenbellahi862 6 ปีที่แล้ว

    great tutorial

  • @imadfazil3166
    @imadfazil3166 4 ปีที่แล้ว

    IM seeking for some help of using database. how can i contact you?

  • @1100290972
    @1100290972 5 ปีที่แล้ว +1

    hey, nice video... haven't watched full... asking in between how to save the database from hackers???

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว +1

      I have some videos on WordPress Security but I’m gearing up for a whole new series of WordPress focused videos for 2019 full of new tips and tricks. I’ll show how to secure your website from nearly all attacks (except for zero day vulnerabilities since those are unknown). I’m also creating an advanced scanning and tracking plugin and will show how to code it. 2019 is going to be an epic year. Thanks for watching.

    • @1100290972
      @1100290972 5 ปีที่แล้ว +1

      PixemWeb also discusses the backup issues like a backup of website and database, intervals like 1 month or daily, restoring the same, backup on local hardware. etc. Generally, people don't know that at what intervals backup is needed...

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว +1

      I have a few videos on backups from manual approach to the plugin route. Checkout the Duplicator Plugin Video. In that one I show how to clone a website and restore from backup.

    • @1100290972
      @1100290972 5 ปีที่แล้ว

      @@PixemWeb sure...!!👍

  • @soufianeayat6321
    @soufianeayat6321 5 ปีที่แล้ว

    But how to change localhost to costum domain in php my admin ??????

  • @fullstack5008
    @fullstack5008 5 ปีที่แล้ว +1

    Awsome

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว

      Glad it helped

  • @3wGaming
    @3wGaming 6 ปีที่แล้ว +1

    i got a Wix ad lol!

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      Lol, that’s funny. Thanks for watching.

  • @danielwatson6529
    @danielwatson6529 3 ปีที่แล้ว +1

    Adminer is not there? maybe this tut needs updated now

    • @PixemWeb
      @PixemWeb  3 ปีที่แล้ว +1

      Yeah, it’s about time for an update

    • @danielwatson6529
      @danielwatson6529 3 ปีที่แล้ว

      @@PixemWeb To be fair, i managed to follow along just fine. really helpful tutorial, Thanks

  • @brabratil2188
    @brabratil2188 5 ปีที่แล้ว +2

    Apparently they removed the plugin

  • @alrifqua9131
    @alrifqua9131 2 ปีที่แล้ว

    I do type adminer in search box nothing is there???!!!

  • @phorusp
    @phorusp 5 ปีที่แล้ว

    It seems that this plugin is no longer available in the search

    • @PixemWeb
      @PixemWeb  5 ปีที่แล้ว

      It was found to have a massive security issue and was subsequently removed from the repository. I actually no longer use phpmyadmin anymore either. Straight up command line, but mainly because the performance issues caused by so many GUI’s. Thanks for watching.

  • @claudeandreafrulla7766
    @claudeandreafrulla7766 3 ปีที่แล้ว

    Put like only for the music.

  • @jalnacscvlesocity
    @jalnacscvlesocity 5 ปีที่แล้ว

    cant search today 2019

  • @vaibhavmatalia2662
    @vaibhavmatalia2662 6 ปีที่แล้ว +1

    Slow down.Your explanation is too fast.Anyone who is beginner is not able to understand what you explain.

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      Hey, thanks for watching. I hear ya, sometimes I talk to slow and other times, too fast. I must have had a lot of coffee that day lol. If the video is too fast, then you can slow down the playback to something like 75%. Let me know if you have any questions. Again, thanks for watching.

  • @uniboni
    @uniboni 2 ปีที่แล้ว

    16:30 wp_posts

  • @paulmcdevitt2038
    @paulmcdevitt2038 4 ปีที่แล้ว

    J

  • @mesalesme7501
    @mesalesme7501 6 ปีที่แล้ว

    Not for begginers

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      It is an in depth walk through but it's good to learn how the database works for WordPress.

  • @davidfisher9251
    @davidfisher9251 7 ปีที่แล้ว +10

    Slow down. Remember, you are showing people who do NOT know what you know how something works. What is the hurry??? You zoom through it as though it were painful.
    Also, try NOT to wiggle the mouse around to emphasize something. That is very poor tutorial method.
    ...

    • @PixemWeb
      @PixemWeb  7 ปีที่แล้ว +3

      Gotcha, thanks for the feedback. Still learning how to do these video tutorials. Playing around with a few different ideas on how to best upload. It's either very long and slow tutorials, fast tutorials where I cram in a lot of info, or what I'm probably going to settle on is splitting the videos into shorter segments.

    • @davidfisher9251
      @davidfisher9251 7 ปีที่แล้ว +2

      Keep this in mind: people are watching this who DO NOT KNOW what you know. Use Camtasia #9 - really the best tutorial maker of them all. Then use zoom in/out, draw boxes and arrows and use those things (there are more) instead of nervous mouse wiggling around attempting to point at something using mouse wiggles (does not work) .
      Focus on ONE message and do not mention options and other ways unless you really think the mention is worth the diversion.
      Diversions are deadly for tutorials as they do not add to your message but divert from it. I recently watched a bunch of SSL installation methods and they all made it far more difficult than it actually is. So, keep it simple. People who know something which has options find it difficult not to show off their knowledge of the options. The discipline is to keep focused and if all the options matter than do another tutorial for options. Otherwise, show ONE set of an option and make a passing comment that it is "one option" and you have other tutorials for other options if you want to.
      ...

    • @PixemWeb
      @PixemWeb  7 ปีที่แล้ว +5

      Thanks again for the feedback. I'm using Camtasia 9. It's awesome. Still learning all the features it provides. I appreciate your constructive criticism. It'll help me create better videos that people will benefit from.

    • @mesalesme7501
      @mesalesme7501 6 ปีที่แล้ว +4

      You do have the speed controls bottom right of the video.

    • @dainismichel
      @dainismichel 6 ปีที่แล้ว

      i'm totally fine with the speed. this material is sooooo boring that the speed actually makes it tolerable. i'm fine w the mouse movements as well.

  • @kattakittaxr
    @kattakittaxr 6 ปีที่แล้ว

    Thanks :)

    • @PixemWeb
      @PixemWeb  6 ปีที่แล้ว

      No problem. Glad you found it helpful.

  • @owbii
    @owbii 3 ปีที่แล้ว

    Love the fast pace of the video. fast and still learnt properly