On Apr 20, 2017, at 3:00 PM, Reindl Harald h.reindl@thelounge.net wrote:

what are you need "MySQL Workbench" for?

i remember to had it instaleld nearly a decade ago and while maintain dozens of MariaDB instances if have no idea what it ever provided so essential

Need? I suppose that’s not really absolutely true. A GUI is a tool to allow things to be done quicker. It can be used to avoid learning things, but, that’s not the concern necessarily. Keeps a nice history, pre-defined and friendly queries, nice monitoring on multiple systems, I could go on. I see it as similar to saying who needs Windows (which I don’t use but same idea) as opposed to dos. Not entirely of course, but, the idea is to make one more productive. Command line vs GUI. I like how it categorizes system status, variables, tracks client connections, connects to numerous machines using ssh tunnels, etc. I can do most of that without workbench, just slower. It allows me to use my clients machines GUi for organization and filing and archiving of scripts in a faster manner. I connect to so many machines I just find it’s organization useful. But YMMV.

Le 21 avr. 2017 à 12:14, Reindl Harald h.reindl@thelounge.net a écrit :

Am 20.04.2017 um 23:05 schrieb Sales:

...

...

On Apr 20, 2017, at 3:00 PM, Reindl Harald h.reindl@thelounge.net wrote:

what are you need "MySQL Workbench" for?

i remember to had it instaleld nearly a decade ago and while maintain dozens of MariaDB instances if have no idea what it ever provided so essential

Need? I suppose that’s not really absolutely true. A GUI is a tool to allow things to be done quicker. It can be used to avoid learning things, but, that’s not the concern necessarily. Keeps a nice history, pre-defined and friendly queries, nice monitoring on multiple systems, I could go on. I see it as similar to saying who needs Windows (which I don’t use but same idea) as opposed to dos. Not entirely of course, but, the idea is to make one more productive. Command line vs GUI. I like how it categorizes system status, variables, tracks client connections, connects to numerous machines using ssh tunnels, etc. I can do most of that without workbench, just slower. It allows me to use my clients machines GUi for organization and filing and archiving of scripts in a faster manner. I connect to so many machines I just find it’s organization useful. But YMMV.

there don't exist much where you are really faster with a GUI except you don't know how to handle things - what worries me more is a database server which is even open over TCP to the network

Agree on those answers but it does not tell us what is broken in compatibility . There is a parameter to fake MySQL handshake may the author of the mail can test this . MariaDB enable sql error plugin to capture are SQL and protocol errors. would be constructive to see what is broken here .

/svar

Stéphane Varoqui, Senior Consultant Phone: +33 695-926-401, skype: svaroqui http://www.mariadb.com

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

On Apr 21, 2017, at 5:14 AM, Reindl Harald h.reindl@thelounge.net wrote:

there don't exist much where you are really faster with a GUI except you don't know how to handle things - what worries me more is a database server which is even open over TCP to the network

The expected answer, heard the same thing over and over in the past on endless products. Yes, DOS really was great. :-) Of course, the database is no more open than your command line technique since it’s using an ssh tunnel (and thus only access is localhost) and likely you use ssh also for command line access. Unless you are local and the servers are not in a datacenter, which has it’s own set of troubles. Just keep in mind not everyone works in a huge company (I have). There are numerous customers out there running small businesses on open source and they are not up to the level of most people here to say the least. For them, a free admin product is a good thing. Control panel type “admin” systems are awful for the most part.

Regarding the heidisql suggestion, it supports very few modern features, it is way too limited. Workbench supports many things heidisql does not.

Regarding navicat, I use that on IOS and it seems to work ok. Have not used it on a desktop. But yes, there are paid options. Might try the free trial to see what it does and does not do.

Still, as a full mysql replacement, I do agree with the op, workbench should be part of the replacement in an ideal world, it just looks good marketing wise. However, I get that the product takes an entirely different skill set and being multiplatform makes it a bit more difficult. That’s a better reason to make your case. Certainly products like Columnstore are more important. Was not aware of some of the paid options, so, it’s good there is some choice there.

On Apr 21, 2017, at 10:19 AM, Reindl Harald h.reindl@thelounge.net wrote:

i don't buy that just because i don't work in a huge company, come from windows, started just as php developer and over the years took over the whole administration, ported the whole company from OSX to Linux and guess what the previous OSX "sysadmin" was: a clickmonkey

from 2003 to 2008 i learned all the needed things autodidact to took over the whole technical from database, web, mail, network, virtualization, nameservers and what not

what i never missed was a desktop GUI for a mysql server….

I get that, and that’s great for you. I could say the same as well, but nevertheless, still use GUIs. They may not be for you, and that’s fine. Just as you tend to lump GUI users into some bucket, I tend to lump non GUI users into a set of stereotypes. Just realize you are not the typical case. You really think the hundreds of thousands of Zen Cart, OSCommerce, Magento, etc. users can do that, your typical person? Now that mariadb is the default on many distributions? I’ve helped many of them over the years gain some access to their database so they can explore, poke around, generate some reports, run queries I generate for them, get back into their system when locked out, etc. Workbench as you may or may not know, has some failsafes. Naturally, GUI or not, they can also destroy their system though it’s a little harder with the GUI. So, caution and rules / configuration are always stated.

My intent is certainly not to try and convince any experienced admin who does not use any sort of GUI tool to do so, of course not! Use whatever makes you feel good. It’s only to agree with the OP that such tools are useful for many people, one of them not being you. However, as a programmer, I do realize that it would be challenging due to the skill set involved to maintain the product.