Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 8 of 8
Like Tree2Likes
  • 1 Post By mlseim
  • 1 Post By Ronald Roe

Thread: phpmyadmin mysql workbench

  1. #1
    Senior Member
    Join Date
    Apr 2016
    Posts
    717
    Member #
    53891
    Liked
    11 times

    phpmyadmin mysql workbench

    are both these products made to fulfil the same task? providing a visual interface for a sql database? which is better, which does more and what more does it do?

  2.  

  3. #2
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    Most of us don't even use it.

    We using our cpanel (webhost control panel) to create the database.

    Then we use PHP / PDO to create tables, and use the database.
    I have used phpmyadmin to make a mysql backup, but never have any other reason to use it.
    busso likes this.


  4. #3
    Senior Member Ronald Roe's Avatar
    Join Date
    Mar 2011
    Location
    Oklahoma City
    Posts
    3,141
    Member #
    27197
    Liked
    959 times
    I, on the other hand, have used both extensively for creating and managing MySQL DBs. They're great at it, provided you know what you're doing. For most people, using the Cpanel wizard is plenty good enough, as mlseim mentioned.

    On the surface, yes, they're built for the same purpose. Workbench is a far more comprehensive tool, though. phpmyadmin is great for remote management on servers that have PHP available. Many modern web stacks don't have it, though, so therein lies a potential issue (though PHP-based servers do still dominate the hosting space). Workbench, IIRC, can connect to and manage remote installs. It also works great for local installs. There's a pretty steep learning curve with it though if you don't know SQL as a language.

    For simple stuff, I actually much prefer the command line client.
    Last edited by Ronald Roe; Apr 25th, 2017 at 10:16 PM.
    busso likes this.
    Ron Roe
    Web Developer
    "If every app were designed using the same design template, oh wait...Bootstrap."

  5. #4
    Senior Member
    Join Date
    Apr 2016
    Posts
    717
    Member #
    53891
    Liked
    11 times
    thanks guys, if I plan on hosting myself, on my own machines, whats my best option?

  6. #5
    Senior Member Ronald Roe's Avatar
    Join Date
    Mar 2011
    Location
    Oklahoma City
    Posts
    3,141
    Member #
    27197
    Liked
    959 times
    You mean like on a physical machine in your house? Your best option is to not do that.
    Ron Roe
    Web Developer
    "If every app were designed using the same design template, oh wait...Bootstrap."

  7. #6
    Senior Member
    Join Date
    Apr 2016
    Posts
    717
    Member #
    53891
    Liked
    11 times
    yea a physical machine. no, not in my house but somewhere secure. paid hosting such as godaddy will get my site off the ground but long term I could be looking at millions of members all across the world so my own data center becomes a lot more feasible compared to paid hosting

  8. #7
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    Very well then, Busso Zuckerberg


  9. #8
    Senior Member
    Join Date
    Apr 2016
    Posts
    717
    Member #
    53891
    Liked
    11 times
    im hardly going to plan a site for ten members then fail, just planning accordingly to the sites potential


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:24 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com