hi Steve,
after you login with the new account , you can use the command
show grants;
to check which permission had been already granted to this account as below.
mysql> show grants;
+-+
| Grants for r...@localhost |
+
Hi Steve
Your statement will allow you to SELECT from any table in the pet_calendar
database. You need to add INSERT, UPDATE, DELETE, CREATE etc to your GRANT
statement. If you would like to have a super user, just GRANT ALL
Mike
- Original Message -
From: "Steve Marquez"
To: "
PRIVILAGES should read PRIVILEGES
-Original Message-
From: Gary Roach [mailto:gary719_li...@verizon.net]
Sent: Wednesday 15 September 2010 19:11
To: mysql@lists.mysql.com
Subject: GRANT ALL error - newbee
I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
first ti
On Wed, Sep 15, 2010 at 12:10 PM, Gary Roach wrote:
> I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
> first time. On my internal network (behind firewall) I have a computer
> (cruncher) that is acting as the web server. Another computer (supercrunch)
> is being used as t
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi wrote:
> Hi;
> I created a user and then granted privileges:
> grant all to victor identified by 'pw';
> Looked good. Tried to log in as victor an no go. Please advise.
> Victor
>
2009/5/27 Daevid Vincent
>
> Wondering which of these will work or not?
>
> (no quotes)
> GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY
> PASSWORD 'secret';
>
> (backticks)
> GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED
> BY PASSWORD 'secr
*shrugs* I, for one, appreciate a tool that doesn't try to be smarter than I
am. If I want to be treated like an idiot, I'll use microsoft software.
On Wed, May 27, 2009 at 2:38 AM, Daevid Vincent wrote:
> I'm a little concerned and disappointed that the GRANT command doesn't do
> any sort of c
]
> Sent: 07 May 2009 15:09
> To: Jim Lyons
> Cc: John Clement; mysql@lists.mysql.com
> Subject: Re: grant user create privilege
>
> Did you flush privileges after creating the user?
>
> On Thu, 2009-05-07 at 08:54 -0500, Jim Lyons wrote:
> > It's hard to believe
From: Jim Lyons [mailto:jlyons4...@gmail.com]
> Sent: 07 May 2009 14:55
> To: John Clement
> Cc: mysql@lists.mysql.com
> Subject: Re: grant user create privilege
>
> It's hard to believe this to be the case since I assume you've created
> other
> databases in
Did you flush privileges after creating the user?
On Thu, 2009-05-07 at 08:54 -0500, Jim Lyons wrote:
> It's hard to believe this to be the case since I assume you've created other
> databases in this instance, but the error on "create database", which is
> essentially a "mkdir" in Unix, makes me
It's hard to believe this to be the case since I assume you've created other
databases in this instance, but the error on "create database", which is
essentially a "mkdir" in Unix, makes me wonder if you don't have a file
permissions error on the datadir directory.
On Wed, May 6, 2009 at 9:14 AM,
John,
Are you loggin in as:
mysql -u 'user' -p
If not, you should (from the local host obviously).
The other thing to check is once you are logged in, run the following command:
mysql> show grants;
This will tell you what the grants are for the user that is logged in
(and whether or not you are
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do thi
On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> is there any command that can set so that admin's privileges on internal =
> admin's privileges on test???
>
> what i'm trying to avoid is manually adjust admin's privileges on test if
> admin's privileges on internal cha
On Wed, 16 Apr 2008, Daniel Brown wrote:
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
hi all, i have an existing database (internal) with a user named 'admin',
everything works fine as far as privileges concern.
i just created a new database (test) and want to grant
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
> hi all, i have an existing database (internal) with a user named 'admin',
> everything works fine as far as privileges concern.
>
> i just created a new database (test) and want to grant admin's privileges
> on test as same
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do this???
i tried (as root):
g
Can you give the output of the command
show grants for admin;
Thank You,
-srini
Hiep Nguyen wrote:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
pr
March 03, 2008 11:15 AM
Subject: Re: grant user
> On Mon, 3 Mar 2008, Hiep Nguyen wrote:
>
> > hi all, i have a user that can only access localhost, how do i grant
this
> > user permission so that can also be accessed from 192.168.1.50?
> >
> i got it. thanks
> t.
On Mon, 3 Mar 2008, Hiep Nguyen wrote:
hi all, i have a user that can only access localhost, how do i grant this
user permission so that can also be accessed from 192.168.1.50?
i got it. thanks
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
GRANT [ALL PRIVILEGES|Appropriate Privileges] *.* TO root@'192.168.1.50'
IDENTIFIED BY '' WITH GRANT OPTION;
Or if you want a root user from a subnet
GRANT [ALL PRIVILEGES|Appropriate Privileges]ON *.* TO root@'192.168.1.%'
IDENTIFIED BY '' WITH GRANT OPTION;
http://dev.mysql.com/doc/refman/5.
You can use the INFORMATION_SCHEMA.TABLES view to generate the GRANT
statements for you. Write a query along these lines:
SELECT CONCAT('GRANT SELECT ON test.', TABLE_NAME, ' to ''foouser'';')
FROM INFORMATION_SCHEMA.TABLES
WHERETABLE_SCHEMA = 'test'
AND TABLE_NAME LIKE 'foo_
It doesn't. That was one of the multiple wildcard variations I
already tried.
David
On Oct 12, 2006, at 3:13 PM, Anders Lundgren wrote:
I think you should try % that is used as wildcard instead for one
or many characters. Granting on 'foo_%' might work.
Regards,
Anders
--
Anders Lundgre
I think you should try % that is used as wildcard instead for one or
many characters. Granting on 'foo_%' might work.
Regards,
Anders
--
Anders Lundgren
Master Software Engineer
Viba IT Handelsbolag
Web: http://www.vibait.se
David Felio wrote:
Assume database 'biggie' with 15 tables, 10 of wh
Firstly, I apologize for my incorrect db level grant in the syntax I posted.
Secondly, by going to mysql.com/grant I found the GRANT syntax page,
which states:
"The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE,
SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative
pr
Thanks Dilipkumar,
the syntax works fine
mysql> grant file on *.* to 'wr'@'localhost';
so the "file" privilege is for ALL databases.
by the way, to allow "alter", the syntax is like :
mysql> grant alter on dr4.* to 'wr'@'localhost';
here the "alter" privilege is specific to a database, o
Dilipkumar wrote:
Dude listen,
You can given file privileges to existing users for all the Db's as
if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED] identifie
Dude listen,
You can given file privileges to existing users for all the Db's as
if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED] identified by 'passwd';
Try
Gilles MISSONNIER wrote:
> Hello
> How to set "FILE privilege enable" to an already defined user ?
>
> It seems that I have to read the all manual for that.
> I cannot find an example in the on line manual.
sheeri kritzer wrote:
> GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passw
Hi,
You can try this option by
grant file on *.* to [EMAIL PROTECTED] identified by 'db123';
Query OK, 0 rows affected (0.03 sec)
For all the Databases.
Gilles MISSONNIER wrote:
Thank you Sheeri for answering,
I guess this syntax works for you, but
for me NO, this DO NOT work ( I run MySQL
Thank you Sheeri for answering,
I guess this syntax works for you, but
for me NO, this DO NOT work ( I run MySQL 4.21 , on Linux Debian sarge )
mysql> GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
the
GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
It won't set up a new account, just add the privilege for you.
-Sheeri
On 5/26/06, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
Hello
How to set "FILE privilege enable" to an already defined user ?
It seems that I have to re
Michael,
Thanks for the detailed response.
First off, it's a network connection, but I forgot to
show the -h in my example. Sorry for the lack of
clarity there.
The error message that I'm getting is:
ERROR 1045: Access denied for user
'myuser'@'host.mydomain.com' (using password: YES)
So then,
Tripp Bishop wrote:
Simple question:
I'd like to create a user that has all privileges for
just one database on the server.
When I try the following:
grant all privileges on my_db.* to
'myuser'@'%.mydomain.com'
identified by 'foobar';
the statement runs fine.
You can verify it worked with
Hello.
EXECUTE is not operational until MySQL 5.0.3. Don't use in 4.1. See:
http://dev.mysql.com/doc/mysql/en/grant.html
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> For some reason, GRANT EXECUTE is possible on the global level,
> but not on the database level:
>
> > For some reason, GRANT EXECUTE is possible on the global
> > level, but not on the database level:
> > "Incorrect usage of DB GRANT and GLOBAL PRIVILEGES"
> >
> > Has anyone got any idea what EXECUTE should do on a global
> > level in MySQL 4.1?
>
> Martin,
>
> EXECUTE is specifically for stor
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: 12 August 2005 09:40
> To: mysql@lists.mysql.com
> Subject: GRANT EXECUTE in MySQL 4.1
>
> Hi there,
>
> For some reason, GRANT EXECUTE is possible on the global
> level, but not on the database level:
> "Inco
At 16:57 -0700 7/4/05, l'[EMAIL PROTECTED] wrote:
I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION
to change the privilege of a user:
GRANT ALL ON mydb.* TO myUser;
The result of this statement is that the query is OK and 0 rows are affected.
WHen I look at the mysql table holding
l'[EMAIL PROTECTED] wrote:
I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION
to change the privilege of a user:
GRANT ALL ON mydb.* TO myUser;
The result of this statement is that the query is OK and 0 rows are
affected.
WHen I look at the mysql table holding the grants: user, the
Hello.
If you want wildcards you could use something like this:
grant all privileges on `%samhain%`.* to [EMAIL PROTECTED] identified
by 'passwd' with grant option;
Mark Sargent <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> trying to create a new user with the below,
>
> GRANT
Mark Sargent wrote:
Hi All,
trying to create a new user with the below,
GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY
'passwd' WITH GRANT OPTION;
but, it gives a syntax error message. mysql version is 4.1.12. What is
wrong with the syntax.? Cheers.
Mark Sargent
Hi,
> trying to create a new user with the below,
>
> GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost'
> IDENTIFIED BY 'passwd' WITH GRANT OPTION;
That should be 'samhain.*', not '*samhain*'.
Regards,
Martijn
--
The information contained in this communication and any attachments
At 11:19 -0500 4/22/05, Scott Purcell wrote:
I am here in the docs.
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
Hi,
> I have a problem connecting to the mysql server. I installed a new
> server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some
> websites running on it using the mysql server. Last friday I had a
> crash of one off my other servers and I copied the websites and db's
> to this new s
Yes, I hadn't thought of that. But at the same time, the way it's presently
set up, you *can,* and must, create a user with no password. That doesn't
seem very safe either.
j- k-
On Tuesday 11 January 2005 05:17, Tom Crimmins said something like:
> [snip]
> It seems that the GRANT syn
have privs to the mysql.user table you definitely should not be
able to do that.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Joshua J. Kugler
Sent: Tuesday, January 11, 2005 1:09 AM
To: mysql@lists.mysql.com
Subject: Re: GRANT can't gra
Right, I understand that, but then *why* can a user create another user, with
all the priveleges they have, but with now password. That seems like a great
security hole. It seems that the GRANT syntax should allow the setting of a
password upon account creation without requiring access to the
Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html
Only clients with access to mysql database can set passwords for
other accounts.
"Joshua J. Kugler" <[EMAIL PROTECTED]> wrote:
> I've read the sections on GRANT's and permissions, and done some googling,
> and
[snip]
Is it possible to grant all these databases in just one GRANT instruction
such as:
GRANT SELECT,INSERT,UPDATE,DELETE ON dbexample*.* TO 'user'@'localhost' BY
'password';
[/snip]
GRANT [privs] ON `dbexample%`.* TO 'user'@'localhost' IDENTIFIED BY
'password';
---
Tom Crimmins
Interface Spec
[EMAIL PROTECTED] wrote:
> I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is
> this: after I run the script to upgrade the grant tables to support the new
> privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust
> the grant tables.
Hi Eric,:
Thanks for responding. Preliminary tests indicate no problems, although it does of
necessity make assumptions about which of the new privileges existing users should
have when upgrading, but they were fairly safe.
Regards,
-Bob
> I would assume that you can since mysql probably doe
I would assume that you can since mysql probably does an internal
select col, col1 to get the grant information and the new tables
contain everything that the old ones do plus some extra privileges.
The only thing I would worry about would be passwords changing. Make a
small test case and let ever
There are precedence rules and these are discussed in the manual.
http://dev.mysql.com/doc/mysql/en/Connection_access.html
Since you are granting at the database level you will see the changes in the
db table and not the user table.
-Original Message-
From: Cam
To: Mysql List
Sent: 7/30/04
I should have looked before I answered. I apologize to you and the rest of
the list for having my head up my a**..
I RTFM (http://dev.mysql.com/doc/mysql/en/GRANT.html) and find:
The EXECUTION, FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION
SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER pr
Sorry,
grant REPLICATION SLAVE on forum to repltest2@'%' IDENTIFIED BY
'replforum';
ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which
privileges can be used.
(using 4.20)
Regard's
Vincent
You were attempting to gr
You were attempting to grant replication rights to all of the TABLES in
the database "forum". Try it again like:
grant REPLICATION SLAVE on forum to repl@'%' IDENTIFIED BY 'replforum';
and see if it works better ;-)
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[E
[EMAIL PROTECTED] wrote:
I am running MySQL 3.23 and want to setup replication. I execute the
following command(copied from MySQL document) on the master server:
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com' IDENTIFIED BY
'slavepass';
And it return the following message:
ERROR 1064: You
Sergei Golubchik wrote:
Hi!
On May 27, [EMAIL PROTECTED] wrote:
Description: Using the GRANT command causes the password to be
deleted until 'FLUSH PRIVILEGES' is executed. This is a security
problem.
Search the bugdb - http://bugs.mysql.com/
the bug is reported there and is already
Hi!
On May 27, [EMAIL PROTECTED] wrote:
> >Description: Using the GRANT command causes the password to be
> deleted until 'FLUSH PRIVILEGES' is executed. This is a security
> problem.
Search the bugdb - http://bugs.mysql.com/
the bug is reported there and is already fixed.
Regards,
Sergei
--
John Ratliff wrote:
I'm trying to use a grant statement to grant privileges to a user on a
set of database names.
e.g. for some user k, I want them to be able to have complete access to
any database named k_*.
I know this can be done. The test database is setup this way by default.
Here is wha
You can accomplish it without granting everyone root privileges.
Just create user accounts and grant them the right to create a database
and to have full access to their own (NOT ALL databases on the server!)
databases.
Babs
||> -Original Message-
||> From: Ron Gilbert [mailto:[EMAIL PR
[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
SHOW DATABASES is a global privilege. It allows the named user to see (with
SHOW DATABASES) dbs he/she cannot work with. If that's really what you
want, the syntax for your 4th line would be:
GRANT SHOW DATABASES ON *.* TO [EMAIL PROTECTED]
You use *.* instead of OSMS.* because this is glob
* Franz Edler
> I have a perhaps simple problem, but it's a problem for me:
>
> I have made the following GRANT statement:
> mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED];
> Query OK, 0 rows affected (0.01 sec)
>
> But when I want to REVOKE the GRANT I get the following syntax error:
>
> mysql
At 9:31 + 2/23/04, [EMAIL PROTECTED] wrote:
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
I am new to most aspects of MySQL administration so I was wondering
if someone can help me figure out what GRANTs I need for a
particular situation.
I have a user who needs to be able to r
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
> I am new to most aspects of MySQL administration so I was wondering
> if someone can help me figure out what GRANTs I need for a
> particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that
> create
At 14:56 -0500 2/21/04, Rhino wrote:
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
"official channels" are for making suggestions about the documentation. I
have some ideas about how to make it better
Mail to [EMAIL PROT
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
"official channels" are for making suggestions about the documentation. I
have some ideas about how to make it better
Rhino
--
MySQL General Mailing List
For list archiv
At 14:30 -0500 2/21/04, Rhino wrote:
More followups below
> >> > 1. Why is this happening? The Load Data article says he needs the
File
>privilege and I've given it to him. He also has all privileges on the NFL
>database. What more do I need to do for him?
>>
>> FILE is a global level
More followups below
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 1:25 PM
Subject: Re: GRANT question
> At 13:09 -0500 2/21/04, Rhino
At 13:09 -0500 2/21/04, Rhino wrote:
Followup questions interspersed below
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
"Rhino" <[EMAI
Followup questions interspersed below
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
> "Rhino" <[EMAIL PROTECTED]> wro
"Rhino" <[EMAIL PROTECTED]> wrote:
> I am new to most aspects of MySQL administration so I was wondering if someone can
> help me figure out what GRANTs I need for a particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that create and load
> tables in a database
Niklas Saers <[EMAIL PROTECTED]> wrote:
>
> I've got a number of users who have their username on the format 'x_n'
> where x is a string and n is a one-decimal number. I want them to have
> full access to one, and only one, database. That means, they should be
> able to do CREATE TABLE but
"W. Bauer" <[EMAIL PROTECTED]> wrote:
>
> Getting confused in the mysqlcc as a [EMAIL PROTECTED], I managed
> that I cannot grant privileges any more. Any hint how I can undo
> that?
If you still have privileges on the database 'mysql' you can set Grant_rpiv to 'Y'
with UPDATE statement.
-
Thanks for the help to ALL
I got it to work.
I do not know how but I think that they might have been hidden
characters in the program doing insert
in the actuall insert statements. I retyped the insert code in the
program and things started to
work. Probably when I ftp the code somethin gel
y the test
database. Fix your privileges and you should be okay.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Gran
or users. One with a password and one without a
password.
The one with connect from anywhere is only allowed to modify the test
database. Fix your privileges and you should be okay.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 1:04 PM
To: [E
your privileges and you should be okay.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant per
13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant permissions problems - help
+---
--+
| Grants for [EMAIL PROTECTED
OK guys this is beyond me.
I just found out that I can NOT insert into my SCHOOL table
when I login into mysql as user nestor on my Mac OS X.
The table is autoincremented. how do I find out what is the next
number to be incremented?
Nestor :-)
Nestor A. Florez
>>> "Nestor Florez" <[EMAIL PRO
I just realized that if I login to mysql as the user I can insert
records.
It must be somehting with my code
I will try the trace_on
It is just amazing that the same code works in my W2K machine
and when I ftp it to the Mac OS X only adding to th eschools fails.
Thanks,
Nestor :-)
Nestor A. F
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'nestor'@'%' I
Hi Nestor. What does the mysql_error() report as the exact error
message? This could help you identify what kind of access control
issue it is.
Alternatively, you could try running the same query from the command
line (using the mysql client) and see if you get the same error.
Also, I'm not rea
execute show grants for nestor@'%' and see what that user has.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 12:21 PM
To: Nestor Florez; [EMAIL PROTECTED]
Subject: Re: Grant permissions problems - help
I forgot to mentioned
I forgot to mentioned that this same code works on the same database on
my W2K
but I am having problems on my Mac OS X (Darwin). I sqldump the
database from my W2K
to my Mac Os X.
Nestor :-)
Nestor A. Florez
>>> Nestor Florez 11/13/2003 10:17:37 AM >>>
I have a mysql db where via a web page I
TECTED]>13/11/2003 11:35 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS
You can't login as testuser and try to give yourself privileges, it just
doesn't work.
Paul DuBois <[EMAIL PROTECTED]>13/11/2003 11:14 AM
To: BORNAY Richard/Engr/STATS/ST [EMAIL PROTECTED] Domain, [EMAIL PROTECTED]
cc:
Subject: RE: GRANT TO SELECTED COLUMNS
At 10:55 AM +0800 11/13/03, [EMAIL PROTECTED] wrote:
>Hi Chris/Lists,
>In fact, I was able to
the Select privilege FROM
mysql.tables_priv.Table_priv WHERE User='testuser' AND Host='%'
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 6:56 PM
To: [EMAIL PROTECTED]
Subject: RE: GRANT TO SELECTED COLUMNS
nly those two columns.
In that case, SELECT * should work. But my impression is that your
table has more than just the two columns.
"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/S
the error Access denied for user
'testuser'
Thanks, Richard
"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS
That second query, byt itself, should have done it, were you logged in as
testuser when you tried to run it?
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: GRANT TO SELECTED COLUMNS
Hel
Thank You. I found out that I had to run mysql_fix_privilege_tables program.
Thanks
Steve
At 08:07 AM 10/28/2003, you wrote:
Hi there,
I guess you are going to have to grant this at the database level,
unfortunately for you. These privileges are stored in the mysql.db and
mysql.host tables, or
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.
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-
> Från: Rory McKinley [mailto:[EMAIL PROTECTED]
> Skickat: den 23 oktober 2003 11:56
> Till: Datatal AB - Gauffin, Jo
Hi 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.?.
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand bina
ECTED]'
Subject: Re: grant by option on querys
At 21:07 -0500 10/2/03, Brad Teale wrote:
>Hi All,
>
>I asked earlier about a query being slow, possibly due to MySQL 'Using
>temporary; Using filesort' when processing the query. I have done some
>testing, and it appe
At 21:07 -0500 10/2/03, Brad Teale wrote:
Hi All,
I asked earlier about a query being slow, possibly due to MySQL 'Using
temporary; Using filesort' when processing the query. I have done some
testing, and it appears that no matter what data set is used, MySQL always
performs a select with a 'gran
Hi,
Thanks for the followup/reply.
On Tue, Sep 30, 2003 at 01:56:11PM +0100, Andy Eastham wrote:
> I've never tried this, so it's pure speculation, but I believe all of the
> grant information is contained in a regular table called user.
I had a look into this and it seems that some of the info
1 - 100 of 160 matches
Mail list logo
