In the past, either databases or usernames (A Google image search of the wizard shows the username was 7?) could have a max amount of 7 characters, and I've been 'stuck' in to using 7 characters ever since, until now when using the MySQL database wizard which shows the maximum characters (the MySQL page doesn't), I noticed it's now 59 characters for the database and 43 for the username. Heavens knows when that change happened, but brilliant, now I can give databases and usernames more meaningful names!
But could going above the 'traditional' 7 characters cause any compatability issues, both with server and MySQL database viewing/management software, and with web applications that use the database that may have their configuration/setup wizards still character limited to 7? I hope that makes sense. Are there any downsides or limitations of using this higher character limit?
And while I'm here, I've also got in the habit of always making one database and user and attaching them together, normally with the same name. Is this okay, or should I be doing something else? Could I use one MySQL user across all of my databases on my accounts?
Thank you
(Note: Checked documentation prior to asking)
But could going above the 'traditional' 7 characters cause any compatability issues, both with server and MySQL database viewing/management software, and with web applications that use the database that may have their configuration/setup wizards still character limited to 7? I hope that makes sense. Are there any downsides or limitations of using this higher character limit?
And while I'm here, I've also got in the habit of always making one database and user and attaching them together, normally with the same name. Is this okay, or should I be doing something else? Could I use one MySQL user across all of my databases on my accounts?
Thank you
(Note: Checked documentation prior to asking)