Correct, my assertion is that MySQL administration does NOT require use of sudo or su at all in any way. I was responding to your claim about MySQL administration “hooking into sudo rather than a dedicated databaser user” which is just wrong as described above.
To re-summarize, MySQL administration involves use of a mysql user (meaning, a user defined inside the database server and NOT an OS user), and since there is no 1:1 mapping between OS and db users in MySQL there is quite obviously no requirement to use sudo or su for anything at all.
Postgres is not relevant to that claim, as we’re discussing MySQL behavior here.
Furthermore none of this behavior is specific to MySQL 5 (it hasn't changed in 8.0, nor anything after it like 8.4 or 9.0) and none of it relates to defaults.
It's entirely possible some default changed in the package for your chosen Linux distribution / package management system, but that is outside of MySQL itself.
No, this is about comparison between Postgres and MySQL.
When you administrate Postgres you typically run psql as another user, with MySQL you typically don't, instead you tend to use the root@localhost in the database or sudo on the rather large set of binaries that gets installed with the server.
And I don't really care whether you think the old MyISAM engine was fine and not problematic or whether you've come across problems with utf8mb3 or latin1 or whatever, and I especially don't care whether you think I'm an experienced, professional MySQL user or not.
I’ve already explained repeatedly that use of sudo is completely unnecessary with MySQL. As for the rest, that’s gibberish - for example I certainly don’t think MyISAM is fine for anything, and have absolutely never said anything pro-MyISAM in all the years I’ve been on HN. As for utf8mb3, I literally make widely-used schema management software that flags any use of utf8mb3 as a problem by default.
I have no idea why you keep replying with non sequiturs, but I’m going to stop responding now, as you don’t seem to understand anything I am saying.
What's your experience with Postgres?