Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

That's odd, I feel the opposite. For years the way to create a user in MySQL was this:

    grant usage on *.* to 'bob'@'localhost'
      identified by 'itsasecret';
Meanwhile, PostgreSQL had the extremely straightforward "createuser" command line tool, and the "create user" SQL statement. (MySQL got "create user" and "alter user" around 2006 or so.)

Having to edit pg_hba.conf to allow network connections was always an annoyance for me, but at least the error message you get if it's set up wrong tells you to edit that file, which is also very straightforward and contains documentation out of the box.

Not allowing external access by default is arguably a security practice, though I always thought distro maintainers ought to have erred on the side of usability by enabling localhost access by default.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: