List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 6 2001 12:27am
Subject:Re: Problem with Domain name
View as plain text  
On Sun, Aug 05, 2001 at 06:07:36PM -0600, Mike White wrote:
> I am trying to GRANT access to user xyz@stripped.  MYSQL has a
> problem with the white-home portion of the domain name.  I have tried
> several ways to get around this including quoting the string.  So I used the
> '%' to grant access but then the mm.mysql JDBC API uses xyz.white-home.com
> and not localhost so the authorization fails.  This leads me to believe that
> MySQL has a basic problem with a hypnated domain name.  This domain name is
> perfectly legal does anyone know of a fix or what I'm missing?
> 
> The statement I'm using is:
> 
> GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR xyz@stripped
> IDENTIFIED BY 'aaaaa';
> 
> I get
> error 1064: you have an error in your SQL syntax near -white.com IDENTIFIED
> BY 'aaaaa'' at line 1
> 
> So I enclosed the user name stuff in double quotes as well as the password
> and get
> .
> GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR "xyz@stripped"
> IDENTIFIED BY "aaaaa";
> 
> error 1145: The host or user argument to GRANT is too long

Quote the user and host parts separately: 'xyz'@'xyz.white-home.com'

> 
> I have MySQL-3.23.36-1 rpm installed on a Redhat 7.1 linux system.
> 
> 
> Regards,
> 
> Mike White
> mike@stripped
Thread
Problem with Domain nameMike White6 Aug
  • Re: Problem with Domain namePaul DuBois6 Aug
    • RE: Problem with Domain nameMike White6 Aug