RE: Grant problem

2004-07-30 Thread Victor Pendleton
/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

Re: grant problem!!!

2004-04-21 Thread Victoria Reznichenko
[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

SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
: 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

SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
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:

Re: SV: GRANT problem

2003-10-24 Thread gerald_clark
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.

SV: SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
: 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

Re: SV: SV: GRANT problem

2003-10-24 Thread gerald_clark
. -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

SV: SV: SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
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

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
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

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
| +--++-+-+-+-+-+-+---++-+++---+--+ -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

Re: GRANT problem

2003-10-23 Thread Rory McKinley
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

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
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:

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
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

Re: GRANT problem

2003-10-23 Thread Rory McKinley
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

RE: GRANT problem

2003-10-23 Thread Nathaniel Mallet
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

RE: GRANT problem

2003-10-23 Thread Matt Babineau
: 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

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-15 Thread Nicolas Ross
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.

MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
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

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Paul DuBois
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

Re: MySQL on Darwin (Mac OS X 10.2) grant problem

2003-10-14 Thread Nicolas Ross
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 :

a grant problem.

2002-03-05 Thread Victoria Reznichenko
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

a grant problem.

2002-03-04 Thread Matthew Darcy
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