Announcement

Collapse
No announcement yet.

mysql access bug

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql access bug

    Hi,

    One of our customers discovered a possible bug on mysql as reported bellow;
    System: CentOS 5.2 + Interworx 3.0.4
    Mysql user BD created: domuser1_OB_user
    when using domuser1_OB_user123, domuser1_OB_user1111, etc, it permits login to database and the user is not created.

    Please confirm if it is really a bug

    Regards

  • #2
    Hi Paulo -

    I can certainly confirm the behavior. It's because MySQL only supports 16-character user names, and the server itself simply truncates the username! Since the usernames are truncated to the same 16 characters as the first name your user is using, as long as it's using the same password, the connection is made as the first user, not as the longer name.

    Unfortunately, MySQL does not see this as a bug - http://bugs.mysql.com/bug.php?id=4944

    Thanks
    Tim

    Comment


    • #3
      Thank you for the feedback, Tim

      Comment

      Working...
      X