/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_pr
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
user='scarab' and host='localhost.lo
[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 mysq
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 another command prompt.
what i am
Greetings,
This is how the entry looks like in the mysql.user table. So basically,
root has all the global privileges.
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
Reload_priv | Shutdown_
SQL
Description:
User has ALL grants to the database.
mysql> show grants for [EMAIL PROTECTED];
+---
--+
| Grants for [EMAIL PROTECTED]
|
+-
> >I get access denied (from mysql.exe and myodbc) when
> specifying no host
> >or % as host in the grant statement.
> >
> >
> >
> >>-Ursprungligt meddelande-
> >>Från: gerald_clark [mailto:[EMAIL PROTECTED]
> >>Skickat: den 2
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 by ' doesn't work ' ?
Have you t
EMAIL PROTECTED]
> Ämne: 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 @'%&#x
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 @'%'
IDENTIFIED BY ''; FLUSH PRIVILEGES;
yes. no diffrence. Specifying '%' or no host doesn't work for me.
--
MySQL
>
> GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%'
> IDENTIFIED BY ''; 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:http://lists.mysql.com/[EMAIL PROTEC
--Ursprungligt meddelande-
> Från: 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 tryi
e 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
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 are 10 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]>
Cc: <[EMAIL PROTECTED]>
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.
> 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: http://
stand 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
| N
| N|
+--++-+-+-+-+-+-+---++-+++---+--+
> -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
OR 1045: Access denied 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 insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD'
I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not
receive any errormessages when creating the account. Have I forgot something?
Med vän
> > >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
> >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.
>
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 cas
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 s
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
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 re
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
"peter";
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query: DESC tbl_name_1; he can see all the
structure of that table. Th
I wish to:
GRANT SELECT ON mediabankmaster.clients TO [EMAIL PROTECTED]
GRANT SELECT,INSERT ON mediabankmaster.publicdocs TO [EMAIL PROTECTED]
however, this does not work.
'cemail' can SELECT from clients.
'cemail' can INSERT into publicdocs.
'cemail' CAN NOT SELECT from publiccocs.
I don't know
29 matches
Mail list logo
