Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 2nd July 2011, 13:51
pjdevries pjdevries is offline
HowtoForge Supporter
 
Join Date: Sep 2006
Posts: 130
Thanks: 7
Thanked 12 Times in 5 Posts
 
Default Length of MySQL database names

Hi,

The ISPConfig manual states that database names must not be longer than 16 characters, implying that MySQL does not support longer database names. Although I don't have access to manuals of MySQL 4.x and older, it seems this 16 character limit concerns those older versions only. In the MySQL 5.x manuals one can see that the limit now is 64 characters (see MySQL 5 Reference Manual - Schema Object Names).

Nice to know for users such as myself, who prfere database names starting with a readable [CLIENTNAME] instead of a cryptic [CLIENTID].

Beware though! User names can still be no longer than 16 characters.

Last edited by pjdevries; 2nd July 2011 at 14:58.
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 10:12
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Client Website MySQL Database Names Lister Installation/Configuration 4 12th January 2008 17:21


All times are GMT +2. The time now is 10:50.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.