Greetings,
I created a database. I am having problems connecting
to the database remotely. Getting Access Denied.
If I log into the machine that the database is on and
mysql -u darryl -ppassword
I get in.
If I try to connect from another machine, Access denied for
[EMAIL PROTECTED].
How do I
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
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 connect
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;
Is there a quick command to show all GRANTS? or Users?
--
-
Alex Pilson
FlagShip
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 care if it is
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 in
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?
No.
--
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.
myuser@%