PHPAdmin or Other?

[xclicks]

Hello,

I am gonna take my first try at PHP ...
Wondering what is the best way to manage MySQL here at Powweb?

I was going to install PHPAdmin, but that seems like a lot of work.
I downloaded MySQL-Front but have not installed it yet since
I thought it would be a good idea to ask here first.


Thanks,

[Incantius]

I use MySQL's Control Center & have had 0 problems with it. you should be able to download it from their website at www.mysql.com

[irasmith]

You can use this link (http://www.irarichardsmith.com/modules.php?op=modload&name=Sections&file=index&req=viewarticle&artid=11&page=1) to check out several MySQL admin tools. There is a brief description and a link to the home page/download page of each.

phpMyAdmin is good but there is the hassle of setting up password protection so the install directory isn't available to those who would want to sneak a peak at your login/password for MySQL.

Hope this reference helps you out.

[xclicks]

Then it sounds like there is not a general favorite or most
popular utility among webmasters but it is a matter of personal
preference?

How about a poll ....

What is your preferred Method for managing MySQL ?

[irasmith]

I think here on powweb, among the ones who have been here for some time, the mysqlfront would be the most popular with them. They have used the product and gotten used to is, as we all get used to something over time, and still prefer it. The downside to it is that it is no longer in development and is no longer supported by the developers. So it's one of those packages that does what it does, does it well, and you would need to consult with users of it for support purposes.

The second most likely favorite is phpMyAdmin as it seems just about every php book out there introduces the programmer to it. The strength of it is that it does allow you to administer your MySQL database from anyplace you can access a browser and the web. The downside is that it is a security hole unless you take the precautions to set up htaccess/htpassword protection to the install directory of it.

My current favorite after leaving phpMyAdmin is MySQLCC. It is still in beta so all the features you would want are not necessarily there. But I feel it has strong potential and since it is brought to you by the same fine folks that develop MySQL, who better to provide an admin utility.

My needs are such that I only need to administer my databases from my local machine so not being able to do it through the webrowser is no big deal to me.

Hope this helps you out some and good luck with your poll. My personal advice to you is to look at what your needs and desires are, use the brief outlines provided on my site page to lead you to the leading contendors, and then select from there. It's not necessarily a matter so much of personal preference as it is of personal need and what you are comfortable with.

One other thing, if you use phpMyAdmin, and if your MySQL database grows pretty large, then you will have issues restoring and backing it up as there is some sort of timeout issue with it when doing things over the 'long haul'.

Something else that might help you out is in this particular forum do searches using keywords of each of the products mentioned on my page. That will allow you to see the kinds of issues each has raised from users in the past as well as what the solutions were to them. That should help you out somewhat as well in deciding.

Good luck and if you happen on some products that I don't have listed, please let me know. My goal is to develop as comprehensive a list as possible to give new users here a selection of what they can choose from.

[B&T]

I vote for phpmyadmin. Works great and you can run it from anywhere - since it is on the net. Installing is easy. Unzip, make 4 entries in the config script and upload.

[WnJBirds]

phpmyadmin gets the nod here too.
I've got two instances of it up and running on powweb, and it works fine.
I would reccomend an earlier version if you can find it, the new one IS more complex to install, and then it is quirky at best.
Version 2.2.5 is the more stable release.

[xclicks]

Thanks for all your replies ... as usual, the Powweb community is a great help!

I think I am currently leaning towards MySql-Font but still have not decided for sure!

[El Diablo]

phpMyAdmin is probably a quick easy way to go when you get it setup. Only problem is, it is case sensitive (I learned the hardway) while hooking it up. Just do not put in username or login information in the config.ini.php file, and it will request you log in everytime you go to the directory. Cookies enabled of course.

[B&T]

El Diablo -

Thanks for the tip. I had always included my user/password in the config. Changed my authentication to cookie and removed them. Cool.

ANother thing to do is chmod the config file to 600 so no one else can read it. Less criticial now without the user & password in it.

[Croc Hunter]

Nice reply irasmith, very helpfull. thx :)

[irasmith]

Corc Hunter you are very welcome. Glad to be of help and hope others find the information posted helpful as well.

[NJTHOMAS]

MySql-Font was recommended by powweb and has worked great for me.

[Stylee]

MySql-Font for me as well.

You install MySql-Font to the desktop on your PC.
you upload MySQLAdmin to your space. You can use either/ or just not both at the same time (from what I understand)

So Why not start with the MySql-Font, if you are about to install PHP, especially PHPnuke, as there is already alot to upload.

After that, when it comes to management, if you dont like the front, then switch to the MSA :D

Chances are good, you prolly wont use it all that much anyway, as most pf the administration can be done through php itself, deleting, creating, pruning, etc. And I have noticed that alot of the blocks and moduals that require you to create new tables, have a function that creates them for you.

Well, thats my 2 pennies. Hope it helps

[El Diablo]

There are times for instance, specifically on phpNuke where the creation of tables, etc. will not be made. Or incase something messes up within the installation scripts, some work inside the database will be needed.
:)

[Stylee]

That is SWEET! How did you do that?
I need that.