Mysql Identifiers and their maximum lengths(Bytes)

Mysql Identifiers:
1. Database
2. Table
3. column
4. Alias
5. Index

Length of the identifiers in bytes:

Database 64 bytes
Table 64 bytes
Column 64 bytes
Index 64 bytes
Alias 255 bytes