Alternative to mysql-workbench?

2 respuestas [Último envío]
cuculus
Desconectado/a
se unió: 11/29/2017

Hi! I’m a computer science student and I’ve just started on a databases course.

My professor recommended using MariaDB and mysql-workbench. Currently, I am working with a Debian computer (free only) and mysql-workbench is apparently no longer free as it is not in the list of free packages.

I see from this thread that the version in Trisquel is free:
https://trisquel.info/es/forum/mysql-workbrench-es-libre

My question is whether or not I should:
bother compiling the last free version from source for my Debian computer,
just set up a Trisquel computer for this class (I have plenty around),
or use an alternative.

From this article I see that adminer might be an alternative:
https://www.linux-magazine.com/Issues/2019/222/The-sys-admin-s-daily-grind-Adminer

Any suggestions would be helpful! Thanks.

chaosmonk

I am a member!

I am a translator!

Desconectado/a
se unió: 07/07/2017

mysql-workbench [is in the main section of Debian's unstable branch][1], so Debian still considers it free. The issue appears to be that the package was [removed from the testing branch][2] before Debian 10 was released, which is why it's not currently available. The reason appears to be that mysql-workbench depends on mysql-connector-python, which was removed due to [bug #923347][3]:

"mysql-connector-python is affected by Oracle's policy of not disclosing
what security fixes they fix.

"CVE-2019-2435 is labeled with a CVSS 8.1/10 score and only fixed in
8.x, while the version in stretch (2.1.x) is marked as vulnerable,
but no 2.1.9 release is available, i.e. we cannot effectively provide
a fix within stable only 20 months after stretch was released.

"This renders mysql-connector-python unsuitable for inclusion in a stable
release with security support."

So Debian has excluded this package from their testing and stable branches because they are unable to backport security fixes. There's nothing special about Trisquel's version of mysql-workbench. Trisquel just happens to be based on Ubuntu, who have lower standards than Debian when it comes to what they'll include in their stable releases. If you want to compile it yourself, I would compile the version from Debian's unstable branch. This might be a pain, because you'll also need to compile some of its of dependencies, and you'll need to do this every time there is a new release in order to keep your system secure. You would probably be better off using an alternative.

[1]: https://packages.debian.org/sid/mysql-workbench

[2]: https://tracker.debian.org/news/943250/mysql-workbench-removed-from-testing/

[3]: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=923347

cuculus
Desconectado/a
se unió: 11/29/2017

Thanks for the info!