Benifit of PHPMyAdmin on my own system?

[deronsizemore]

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.

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

[deronsizemore]

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.

[Young Twig]

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.

[JRMillion]

yeah if you already have php and mysql installed, go ahead and setup phpmyadmin...

[deronsizemore]

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?

[JRMillion]

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

[deronsizemore]

alright...sounds good. Thanks for the help