----- Original Message ----- > From: "Rajeev Prasad" <rp.ne...@yahoo.com> > > I am considering using cryptic username for accessing and working on > a database on my MySQL installation. can anyone with experience > provide some suggestion pl?
Why would you make your life hard by using cryptic usernames? Have the username (and db name) reflect the project it's used in or the user it belongs to, make sure you have a properly complex password, allow only from appropriate hosts and set up restrictive firewall rules. If you know how many simultaneous connections the application can make, you can also restrict that. > in documentation, i only see that it can be 16 char long. how complex > it can be? any side effects/bugs of username complexity? can I use > special characters in name? Avoid reserved names, also best to avoid question marks and percent signs as those are wildcards in some situations - even though (I think) they're not actually interpreted unless the user name is a single percent sign. Apart from that, nothing much except the 16-character limit, I think. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
