Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /data/sites/web/breulsorg/data/ZendFramework-1.11.7/library/Zend/Cache/Backend.php on line 66

Warning: Cannot modify header information - headers already sent by (output started at /data/sites/web/breulsorg/data/ZendFramework-1.11.7/library/Zend/Cache/Backend.php:66) in /data/sites/web/breulsorg/data/breulslog.live/application/modules/frontend/Bootstrap.php on line 15
Breuls.log / MySQL Administrator is weird
Ik ben Peter Breuls. Ik schrijf webapplicaties in PHP, filmreviews en onregelmatig iets op deze weblog. Welkom!
Onder de naam Devize ben ik beschikbaar als developer of consultant voor websites of webapplicaties.
Ik ben werkzaam als Administrator bij online community FOK! en als Lead Developer bij frontoffice-leverancier SIMgroep.

MySQL Administrator is weird

Tech / MySQLreageer

I'm an admin for a MySQL database server, and today I needed to add a user account. I'm used to doing this using the commandline program or phpMyAdmin, but today I thought "let's use the nifty MySQL Administrator for Mac," a GUI tool, very much point-and-click and supposedly easy to use.

Or so I thought. For creating a user, you need to fill in, of course, username and password. When you want to save that, you get notified that you need to add a hostname for the user, first. That makes sense, because in MySQL, a user consists of a username and a hostname. So I press the tiny icon that seems to mean "add host". Wrong, MySQL admin tells me. I need to save the properties of this user before I can add a host. Allright, but I just tried that.. but whatever. Pressing Save again.. wrong again! Need to add a host first.

As you can see, I can fill my day with this. The MySQL Administrator is no good. Back to the drawing boa.. eh, the commandline tool. At least those things always work.


Deprecated: Function create_function() is deprecated in /data/sites/web/breulsorg/data/ZendFramework-1.11.7/library/Zend/Form/Element.php on line 319