problem with usernames longer than 16 chars

MySQL database connector for Python programming

Brought to you by: adustman

problem with usernames longer than 16 chars

Forum: Help

Creator: Jan Prochazka

Created: 2006-04-06

Updated: 2012-09-19

Jan Prochazka - 2006-04-06

Hello,
I am trying to connect database, and when I use username longer than 16 characters, connect fails
(it returns error:
(1045, "P\x1b-B\xf8\xedstup pro u\xbeivatele 'vorech.zpevnik.n'@'82.202.112.94' (s heslem ANO)"),
correct name of user is vorech.zpevnik.net
when I connect to user account with username shorter than 16 chars, it works

I use distribution MySQL-python.exe-1.2.0.win32-py2.4.zip

Have you please anybody experiences with this problem?
Thanks Jena

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andy Dustman - 2006-04-06
  
  http://dev.mysql.com/doc/refman/4.1/en/user-names.html
  
  "MySQL usernames can be up to 16 characters long. Changing the maximum length is not supported. If you try to change it, for example by changing the length of the User column in the mysql database tables, this will result in unpredictable behavior. (Altering privilege tables is not supported in any case.) Operating system usernames might have a different maximum length. For example, Unix usernames typically are limited to eight characters."
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Jan Prochazka - 2006-04-07
    
    Thanks, now it is clear
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.