SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    Web Design Addict
    Join Date
    Mar 2004
    Posts
    2,159
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Benifit of PHPMyAdmin on my own system?

    My web server has PHPmyadmin on it, but what would be some of the benifits of having it on my on personal PC? What exactly does it do...I'm kinda lost as to what it officially does.
    Deron Sizemore
    ----------
    My Sites: LogoGala | Golf Ledger (coming soon)
    Twitter: Deron Sizemore

  2. #2
    SitePoint Wizard bronze trophy JRMillion's Avatar
    Join Date
    Apr 2004
    Location
    Arlington VA
    Posts
    2,094
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    its just a web-based graphical UI for MySQL...
    It only useful locally if you run the DB server on your local machine.
    This would only be needed if you need a local staging server, or if you just like to learn how to set that stuff up.

    ps- in case this is not evident, you must have PHP and MySQL installed and running also...
    James Rice :: Ex-Mentor
    www.jamesrice.net

  3. #3
    Web Design Addict
    Join Date
    Mar 2004
    Posts
    2,159
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by JRMillion
    its just a web-based graphical UI for MySQL...
    It only useful locally if you run the DB server on your local machine.
    This would only be needed if you need a local staging server, or if you just like to learn how to set that stuff up.

    ps- in case this is not evident, you must have PHP and MySQL installed and running also...
    Hi,

    Well I do have MySQL server and PHP installed on my personal PC. That's why I was wondering what exactly the benifits of getting PHPMyAdmin would be and having it there to use. I mean, does it allow you to add tables to your database, or add/delete databases? I did the demo on the PHPMyAdmin website, but was kinda lost.
    Deron Sizemore
    ----------
    My Sites: LogoGala | Golf Ledger (coming soon)
    Twitter: Deron Sizemore

  4. #4
    SitePoint Wizard Young Twig's Avatar
    Join Date
    Dec 2003
    Location
    Albany, New York
    Posts
    1,355
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah. you can add tables and insert data into them, delete data from them. I pretty much use phpMyAdmin as a CMS for my site.

  5. #5
    SitePoint Wizard bronze trophy JRMillion's Avatar
    Join Date
    Apr 2004
    Location
    Arlington VA
    Posts
    2,094
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah if you already have php and mysql installed, go ahead and setup phpmyadmin...
    James Rice :: Ex-Mentor
    www.jamesrice.net

  6. #6
    Web Design Addict
    Join Date
    Mar 2004
    Posts
    2,159
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry...just got one more question (I think). So if I set up PHPMyAdmin on my own system, which gives me to the ability to add databases, and tables, etc....I more or less do not have to know SQL anymore, as PHPMyAdmin is in a sense a wysiwyg editor with an interface rather then just typing in commands in the MySQL server?

    Then once I have my database all I have to do is export the database to my web server so I can use it for my websites right? Is this able to be done through PHPMyAdmin?
    Deron Sizemore
    ----------
    My Sites: LogoGala | Golf Ledger (coming soon)
    Twitter: Deron Sizemore

  7. #7
    SitePoint Wizard bronze trophy JRMillion's Avatar
    Join Date
    Apr 2004
    Location
    Arlington VA
    Posts
    2,094
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah thats mostly correct.
    you dont need to know the commands to create the DB...
    and you can export it and import it on your host.

    but you obviously still need to know sql for use with php etc
    James Rice :: Ex-Mentor
    www.jamesrice.net

  8. #8
    Web Design Addict
    Join Date
    Mar 2004
    Posts
    2,159
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    alright...sounds good. Thanks for the help
    Deron Sizemore
    ----------
    My Sites: LogoGala | Golf Ledger (coming soon)
    Twitter: Deron Sizemore


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •