Academic Use and 8 Character Username Limit

mwynne

• October 10, 2017 08:49

Hi All, I am working on getting cpanel/WHM setup for use in classes here at our college. Wondering if there is anyone out there that has done this and could provide some guidance and lessons learned before I go to production. The way I have it set up now is I am setting instructors up with reseller accounts and letting them create users/domains for their class(es). One thing in particular that I am seeing as being problematic is the username first 8 character uniqueness requirement. Is there any way to tweak that? I have read that it is tied to the way cPanel creates dB prefix names so wondering if that can be altered at all. I currently have a single server, and am planning to have them create domains/user accounts that match the students' username which we allow them to set themselves and it often gets duplicated beyond 8 characters (for instance, they often use lastnamefirstname as a format and last names often duplicate beyond 8. Any thoughts or suggestions are appreciated. Mark

• 

  cPanelMichael

  • October 10, 2017 18:54

  Hello, In cPanel & WHM version 11.56 and newer, MySQL's unique character limit requirement does not exist on servers that use MariaDB. You can ensure MariaDB is installed by using the following option: "WHM Home " Software " MySQL/MariaDB Upgrade" This will allow you to use usernames that start with the same eight characters, regardless of if database prefixing is enabled under the "SQL" tab in "WHM >> Tweak Settings". Thank you.

  0
• 

  mwynne

  • October 12, 2017 14:55

  Thanks for the info. That works! Anyone have any Academic use cases/suggestions? Mark

  0

Please sign in to leave a comment.