Message -
From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED]
To: Rory McKinley [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 12:05 PM
Subject: SV: GRANT problem
it works if I specify the host. Why doesn't % work as host?
-Ursprungligt meddelande
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%'
IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
yes. no diffrence. Specifying '%' or no host doesn't work for me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
What do you mean by ' doesn't work ' ?
Have you tried connecting from another machine?
Datatal AB - Gauffin, Jonas wrote:
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%'
IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
yes. no diffrence. Specifying '%' or no host doesn't work for me.
: Re: SV: GRANT problem
What do you mean by ' doesn't work ' ?
Have you tried connecting from another machine?
Datatal AB - Gauffin, Jonas wrote:
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%'
IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
yes. no diffrence. Specifying
.
-Ursprungligt meddelande-
Från: gerald_clark [mailto:[EMAIL PROTECTED]
Skickat: den 24 oktober 2003 15:11
Till: Datatal AB - Gauffin, Jonas
Kopia: [EMAIL PROTECTED]
Ämne: Re: SV: GRANT problem
What do you mean by ' doesn't work ' ?
Have you tried connecting from another machine?
Datatal
specifying no host
or % as host in the grant statement.
-Ursprungligt meddelande-
Från: gerald_clark [mailto:[EMAIL PROTECTED]
Skickat: den 24 oktober 2003 15:11
Till: Datatal AB - Gauffin, Jonas
Kopia: [EMAIL PROTECTED]
Ämne: Re: SV: GRANT problem
What do you mean
Additional info:
the user is added to mysql.user with no privileges.
the user is added to mysql.db with insert,update,delete,select privileges on
phonewatch db.
When I try to connect to the db, C:\mysql\bin\mysql phonewatch -h ts2test -u datatal
-pMYPASSWORD, I get ERROR 1045: Access denied
doesn't read the privileges-Table again.
mfg
Klaus
-Ursprungligt meddelande-
Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
Skickat: den 23 oktober 2003 10:44
Till: [EMAIL PROTECTED]
Ämne: SV: GRANT problem
Additional info:
the user is added to mysql.user
Not sure if this will help - in your GRANT statement do you
not need to specify a host for the user e.g. GRANT.. to
datatal @ your_host_name.?.
GRANT uses % as host if none is specified.
% = all hosts.
any other ideas?
--
MySQL General Mailing List
For list archives:
kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original Message -
From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED]
To: Rory McKinley [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 11:45 AM
Subject: SV: GRANT problem
Not sure
10 matches
Mail list logo