HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Length of MySQL database names (http://www.howtoforge.com/forums/showthread.php?t=53289)

pjdevries 2nd July 2011 13:51

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.


All times are GMT +2. The time now is 00:22.

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