/04 12:06 PM
Subject: Grant problem
I'm running the scarab problem reporting system and and trying to grant
some privileges to a user and don't understand why it isn't working. I
have the following user that I can see in the USER table
mysql select user,host,password,Insert_priv from user where
[EMAIL PROTECTED] wrote:
hi,
I am having problems with mysql.
1. I downloaded mysql on to my system.
2.installed it
3. ran the server using the command prompt
C:\mysql\bin\mysqld --console
it gave me the results that i could start using the service.
4. i started mysql on
: Nathaniel Mallet [mailto:[EMAIL PROTECTED]
Skickat: den 24 oktober 2003 03:04
Till: Rory McKinley; Datatal AB - Gauffin, Jonas
Kopia: [EMAIL PROTECTED]
Ämne: RE: GRANT problem
I was having the same problems trying to get a user added to
a new DB, so here's are the commands I used
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
for user: '[EMAIL PROTECTED]' (Using
password: YES)
please help
-Ursprungligt meddelande-
Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
Skickat: den 23 oktober 2003 09:15
Till: [EMAIL PROTECTED]
Ämne: GRANT problem
Hello
I've created an account by using:
GRANT
|
+--++-+-+-+-+-+-+---++-+++---+--+
-Ursprungligt meddelande-
Från: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]
Skickat: den 23 oktober 2003 11:03
Till: Datatal AB - Gauffin, Jonas
Ämne: AW: GRANT problem
Hi Jonas,
did you send a 'FLUSH PRIVILEGES' after the GRANT-Statement ?
If not, MySQL-Srver
binary and those who don't (Unknown)
- Original Message -
From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 9:14 AM
Subject: GRANT problem
Hello
I've created an account by using:
GRANT insert,update,select,delete on phonewatch
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:
it works if I specify the host. Why doesn't % work as host?
-Ursprungligt meddelande-
Från: Rory McKinley [mailto:[EMAIL PROTECTED]
Skickat: den 23 oktober 2003 11:56
Till: Datatal AB - Gauffin, Jonas
Ämne: Re: GRANT problem
thinking.
In one of your follow up posts I see
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]
Cc: [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 12:05 PM
Subject: SV: GRANT problem
it works if I
with % as host, so specify localhost for you user,
and you should be all set.
Nat
-Original Message-
From: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 6:21 AM
To: Datatal AB - Gauffin, Jonas
Cc: [EMAIL PROTECTED]
Subject: Re: GRANT problem
Ok.
I'm stumped
: Rory McKinley [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 6:21 AM
To: Datatal AB - Gauffin, Jonas
Cc: [EMAIL PROTECTED]
Subject: Re: GRANT problem
Ok.
I'm stumped. If I'm reading the manual correctly, you were right about not
hving to specify the host..the only
2. Grants aren't working.
Almost for each db we have the grant I did is something like :
grant all on db.* to 'user'@'%.domain.com' identified by 'password';
So, I end up with a user with no global privilege in the user table,
and
a
entry in the db table with all privs.
Hi !
Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just
crached, I had to recover on another hardware, a Mac OS X 10.2, wih
mysql-max 4.0.15.
The restore went well, but I have some problems :
1. All tables/database are now lower case.
This not a major issue, as the dbs are
At 11:30 -0400 10/14/03, Nicolas Ross wrote:
Hi !
Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just
crached, I had to recover on another hardware, a Mac OS X 10.2, wih
mysql-max 4.0.15.
The restore went well, but I have some problems :
1. All tables/database are now lower
2. Grants aren't working.
Almost for each db we have the grant I did is something like :
grant all on db.* to 'user'@'%.domain.com' identified by 'password';
So, I end up with a user with no global privilege in the user table, and
a
entry in the db table with all privs.
User table :
Matthew,
Tuesday, March 05, 2002, 12:05:46 AM, you wrote:
MD a while ago I had problems with users on mysql.
MD I am trying to login as root from the local host using password and I get
MD access denied using password=YES
Usually it means that you are using wrong password for your user.
Take a
Hi,
a while ago I had problems with users on mysql.
I am trying to login as root from the local host using password and I get
access denied using password=YES
the host column of my user table is set to % and I have done a flush
privileges
and from other certain hosts I cannot login as root
22 matches
Mail list logo