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
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 |
On Wed, Sep 15, 2010 at 12:10 PM, Gary Roach gary719_li...@verizon.netwrote:
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
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
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi victorsube...@gmail.comwrote:
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 dae...@daevid.com
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
*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 dae...@daevid.com wrote:
I'm a little concerned and disappointed that the GRANT command doesn't
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,
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 wonder
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 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
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 this to be the case since I assume you've
created other
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
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 as
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 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 changed.
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
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
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):
GRANT [ALL PRIVILEGES|Appropriate Privileges] *.* TO root@'192.168.1.50'
IDENTIFIED BY 'password' 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 'password' WITH GRANT OPTION;
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
, 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. hiep
--
MySQL General Mailing List
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
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
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
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, on a
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
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
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
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.
snip
sheeri kritzer wrote:
GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
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';
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]
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 read
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
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
-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:
Incorrect usage
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 stored procedures..
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:
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
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 is
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
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 ALL
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
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 grant with a password?
Right, I understand
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
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
[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
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
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:
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
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
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
[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:
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
--
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
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
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
[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
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
* 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 REVOKE
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 and load
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 run
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 named
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] wrote:
I am new to most aspects of MySQL administration so I
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 [EMAIL PROTECTED] wrote:
I am new to most aspects
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 wrote:
Followup questions interspersed below
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
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
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
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 not
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.
--
For
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
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
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
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'nestor'@'%'
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.
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
13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant permissions problems - help
+---
--+
| Grants for [EMAIL PROTECTED
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 permissions problems - help
.
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: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant
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 permissions problems - help
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
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
'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
. 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/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS
That second query, byt itself, should have
' 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
Hi Chris/Lists,
In fact, I was able to login using both ways, here's what I did.
1. mysql -u
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
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
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 that you have
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
]'
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 appears that no matter what data set is used
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
Shin,
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.
You should be able to copy this information into a temporary table using
select into, then perform regular updates to change the host information to
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
At 12:16 PM -0400 9/17/03, Randy Chrismon wrote:
I have several machines and wander from office to office as part of
the job. As I read the MySQL docs, I have two choices for granting
privileges:
grant ... to randy@'%'
or
grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the
1 - 100 of 153 matches
Mail list logo