Darryl,
Tuesday, November 26, 2002, 4:46:32 PM, you wrote:
DH> I created a database. I am having problems connecting
DH> to the database remotely. Getting "Access Denied".
DH> If I log into the machine that the database is on and
DH> mysql -u darryl -ppassword
DH> I get in.
DH> If I try to co
Hi!
RTFM :-)
These URLs will help you:
http://www.mysql.com/doc/en/User_names.html
http://www.mysql.com/doc/en/GRANT.html
http://www.mysql.com/doc/en/Adding_users.html
Iikka
On Tue, 26 Nov 2002, Darryl Hoar wrote:
> Greetings,
> I created a database. I am having problems connecting
> to the da
At 14:58 -0400 4/19/02, Barry C. Hawkins wrote:
>Alex,
> Enclose the user string in quotes. This will allow you to use
>the global wildcard option.
>
>Example:
>GRANT ALL ON *.* TO "myuser@%" IDENTIFIED BY "mypassword";
You should quote the user name and host name parts separately.
"myuse
>>>Why is this producing a syntax error at the %? This is supposed to
>>>create a global user, yes?
>>>
>>>GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword";
>>
>>myuser@"%"
>
>Andrew Hazen emailed me to use single quotes and it worked. So does
>mysql care if it is single or double quotes?
Alex,
Enclose the user string in quotes. This will allow you to use the global
wildcard option.
Example:
GRANT ALL ON *.* TO "myuser@%" IDENTIFIED BY "mypassword";
For those not using Mac OS X, the default shell is tcsh. I am not sure if this
quirk is a function of string handling
At 12:59 PM -0500 4/19/02, Paul DuBois wrote:
>>Why is this producing a syntax error at the %? This is supposed to
>>create a global user, yes?
>>
>>GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword";
>
>myuser@"%"
Andrew Hazen emailed me to use single quotes and it worked. So does
mysql c