Current time: 06-26-2024, 09:04 PM Hello There, Guest! (LoginRegister)


Thread Closed 
Databases with prefixes
Author Message
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #2
RE: Databases with prefixes
MYSQL_PREFIX_TYPE = 'infront'

I recommend this for every ISP.

My points:
you need a prefix otherwise two customers want a DB named test -> problem
you need a short prefix because the username length is limited (16 chars) -> therefore only customer number...
prefix must be infront otherwise a 16 char db username is not unique (or you should check the length so a prefix at the end can be added).

If you add a customer name as prefix - eg. "testdomain.com" then you are in troubles with the length of the user name.
11-28-2009 01:47 AM
Visit this user's website Find all posts by this user
Thread Closed 


Messages In This Thread
Databases with prefixes - kevke - 11-27-2009, 08:14 PM
RE: Databases with prefixes - joximu - 11-28-2009 01:47 AM
RE: Databases with prefixes - Lucan - 11-28-2009, 02:11 AM
RE: Databases with prefixes - joximu - 11-28-2009, 02:14 AM
RE: Databases with prefixes - Lucan - 11-28-2009, 03:45 AM
RE: Databases with prefixes - kevke - 11-28-2009, 05:14 AM
RE: Databases with prefixes - joximu - 11-28-2009, 07:11 AM

Forum Jump:


User(s) browsing this thread: 2 Guest(s)