Live data from Hacker News

PhpMyAdmin Project Successfully Completes Security Audit

phpmyadmin.net

11–20 of 112 posts

Re: PhpMyAdmin Project Successfully Completes Security Audit

#11
post #8
post #2

Does anyone still use this? I didn't realize this was still actively maintained.

If you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).

I can't think of much reason to use it over Workbench or Sequel Pro.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#12
post #8
post #2

Does anyone still use this? I didn't realize this was still actively maintained.

If you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).

If you need to make a manual database change then Adminer is often a better option[1].

It's doesn't have the featureset as PHPMyAdmin but it has a huge advantage in that it's a single PHP file you can upload, make the necessary changes, and then delete. If you're interested in maintaining a secure server but you don't have any better options than using a script, then it's better to upload something when you need it than trying to secure an online admin tool.

[1] https://www.adminer.org/

Re: PhpMyAdmin Project Successfully Completes Security Audit

#13
post #8
post #2

Does anyone still use this? I didn't realize this was still actively maintained.

If you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).

MySQL Workbench works fine though?

Re: PhpMyAdmin Project Successfully Completes Security Audit

#14
post #11
post #8

Earlier quoted context omitted.

If you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).

I can't think of much reason to use it over Workbench or Sequel Pro.

Some dev environments aren't local, and sometimes this is faster, especially if you have to document the changes for future updates that don't include your fancy tools.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#16
post #12
post #8

Earlier quoted context omitted.

If you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).

If you need to make a manual database change then Adminer is often a better option[1]. It's doesn't have the featureset as PHPMyAdmin but it has a huge advantage in that it's a single PHP file you can upload, make the necessary changes, and then delete. If you're interested in maintaining a secure server but you don't have any better options than using a script, then it's better to upload something when you need it t…

> It's doesn't have the featureset as PHPMyAdmin but it has a huge advantage in that it's a single PHP file you can upload, make the necessary changes, and then delete

The days of painfully slow FTP servers are long gone where "it's one file" would count as advantage.

This leaves a massively worse UX and featureset.

(We are using adminer for postgresql databases, because there's no better alternative, and it makes me wish phpmyadmin supported postgres every time I have to use it.)

Re: PhpMyAdmin Project Successfully Completes Security Audit

#17
post #11

Earlier quoted context omitted.

I can't think of much reason to use it over Workbench or Sequel Pro.

Some dev environments aren't local, and sometimes this is faster, especially if you have to document the changes for future updates that don't include your fancy tools.

Oh, if only were we using it only in dev environments…

Re: PhpMyAdmin Project Successfully Completes Security Audit

#18
post #8

Earlier quoted context omitted.

If you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).

MySQL Workbench works fine though?

+1 for this.

The profiler (visual explain) of queries in MySQL workbench is a godsend.

Also, for general querying and table layout lookup in OSX (macOS, whatever) I recommend Sequel Pro. It has a slightly better UI when working with multiple databases (easier to switch).

Re: PhpMyAdmin Project Successfully Completes Security Audit

#19
post #16
post #12

Earlier quoted context omitted.

If you need to make a manual database change then Adminer is often a better option[1]. It's doesn't have the featureset as PHPMyAdmin but it has a huge advantage in that it's a single PHP file you can upload, make the necessary changes, and then delete. If you're interested in maintaining a secure server but you don't have any better options than using a script, then it's better to upload something when you need it t…

> It's doesn't have the featureset as PHPMyAdmin but it has a huge advantage in that it's a single PHP file you can upload, make the necessary changes, and then delete The days of painfully slow FTP servers are long gone where "it's one file" would count as advantage. This leaves a massively worse UX and featureset. (We are using adminer for postgresql databases, because there's no better alternative, and it makes me…

Having a single file isn't an advantage from a speed perspective; the advantage lies in only having to upload a file, make a change and delete the file again. There's no install, no config, etc.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#20
post #8

Earlier quoted context omitted.

If you are using MySQL, and need to manually fuck around with tables for whatever reason, it's really useful and beats most other options. For us it sees plenty of use with poorly developed legacy software (e.g. Wordpress).

MySQL Workbench works fine though?

Last time I tried it (about two years ago). It would crash all the time on Ubuntu. Went back to PHPMyAdmin.
Post reply on HN