From: Peter Brawley
Date: September 17 2008 12:57pm
Subject: Re: valid chars mysql db username
List-Archive: http://lists.mysql.com/mysql/214527
Message-Id: <48D0FEAE.2070606@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------010103000608090709010103"

--------------010103000608090709010103
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 >I'm looking at using the "@" symbol

Don't. Restrict yourself to alphanums and '_'.

PB

Res wrote:
>
> Hi All,
>
> Does anyone have a reference to what is regarded a legal valid chars
> for the MySQL database username?
>
> You can imagine what google shows me, everything totally irrelevant, as
> usual. The best I can find is using hyphen and percents...
>
> I'm looking at using the "@" symbol, if I enclose it in quotes as such
> 'foo@stripped'@'localhost'  would this work like with other special
> chars like "%",  in test this works fine, adding, authing, and 
> deleting, but is this legal? Could there be downsides to using this 
> format? Could something I've not considerd break?
>
> TIa
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.169 / Virus Database: 270.6.21/1673 - Release Date: 9/15/2008 6:49 PM
>
>   

--------------010103000608090709010103--