RE: ndb_restore is not restoring users and grants

om] Sent: Tuesday, October 30, 2012 12:09 AM To: mysql@lists.mysql.com Subject: ndb_restore is not restoring users and grants Hi, I was able to backup my cluster using ndb_mgm and also restore using ndb_restore. However, when everything looks fine after restore, I see that users and grants

ndb_restore is not restoring users and grants

Hi, I was able to backup my cluster using ndb_mgm and also restore using ndb_restore. However, when everything looks fine after restore, I see that users and grants are not restored. So, does ndb_restore restore all databases including information_schema and mysql databases, plus users and grants

Re: Circular Replication & GRANTs

this? An already-applied grant being reapplied isn't exactly something you easily notice :-) As a first thought, you may have log-slave-updates on, which would cause 206871 to rebroadcast the received grants back to 6871, who will then log them in it's relay log but, normally, ign

Re: Grants for own objects ?

On Wed, Apr 21, 2010 at 2:39 PM, Lentes, Bernd < bernd.len...@helmholtz-muenchen.de> wrote: > The book says it's not possible to use metacharacters like % with GRANT. > The book is wrong. You have to use backticks to quote the lentes_% part, though - it's an annoying quirk. Please ritually burn

RE: Grants for own objects ?

s', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); This should be the same as using

Re: Grants for own objects ?

give grants on their own objects to other users. Following the recommendation in a MySQL-Book, i inserted the following line in the db table: [...] localhost | lentes\_% | lentes | Y | Y | Y | Y | Y | Y | Y | Y

Grants for own objects ?

hello ML, i'm new to MySQL, so i have a very basic question. I have to install a database server for about 15 persons. The server is intended for testing and evaluating. The users should be able to create their own databases and tables. And they should be able to give grants on thei

Re: How do you show ALL grants for a username?

a ride!" On Wed, 2009-07-22 at 12:58 -0700, Daevid Vincent wrote: > (r...@localhost) [(none)]> SELECT CONCAT('SHOW GRANTS FOR \'', user > ,'\'@\'', host, '\';') AS mygrants FROM my

How do you show ALL grants for a username?

(r...@localhost) [(none)]> SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants; +

Table-specific grants problem

Hi, Here is the simplest test case I could boil this down to. I'm running this in 5.0.51a on RHEL4. Preconditions: - mysql.user only contains root user - mysql.db is empty - mysql.tables_priv is empty - mysql.host is empty I login as root, and run the following: CREATE TABLE test.foo (

RE: grants

Grant user for slave: GRANT REPLICATION SLAVE, REPLICATION CLIENT, RELOAD, SUPER on *.* TO 'username'@'IP Slave' IDENTIFIED BY 'password'; ToanDA -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 8:59 PM To: MyS

grants

Hi All, We have setup replication for our production database. We need to do monitoring of the slave and master. I created a user with only "SELECT" privileges, and when i do "show master status" on master db, its saying "Access denied; you need the SUPER,REPLICATION CLIENT privilege for this oper

Grants for mysqldump

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user (minimal grant) that should able to take backup using mysqldump ...can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on

Re: Grants for mysqlbackup

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user(minimal grant) that should able to take backup using mysqldump ...can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on

Grants for mysqlbackup

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user(minimal grant) that should able to take backup using mysqldump ... can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on

Minimal grants for backup

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user that should able to take backup using mysqldump ... can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on *.* to [EMAIL

Re: Show Grants problem

--- Todd Smith <[EMAIL PROTECTED]> wrote: > Hello > Does anyone know why a user would show up in a select from user > query but > not in a show grants command. What I am trying to say is I tried > SHOW > GRANTS FOR 'user1'@'%' and receiv

Show Grants problem

Hello Does anyone know why a user would show up in a select from user query but not in a show grants command. What I am trying to say is I tried SHOW GRANTS FOR 'user1'@'%' and received that there is no such grant defined for 'user1'... But when I run

Replication of GRANTs

Hi, I don't understand how GRANTS are replicated in Mysql 4.0.26 (I can't upgrade to a newer version). The servers were all cleanly installed from scratch (not upgraded) using Mysql's 4.0.26 official rpm. According to the manual GRANT statements should be replicated and after e

Re: GRANTS for tables - why is "create" possible?

Hello. In my opinion, it means that user [EMAIL PROTECTED] is able to create table address in your current database (SHOW GRANTS shows that the name of the database is implicitly added to the table name). "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > Hi there,

GRANTS for tables - why is "create" possible?

Hi there, What is the purpose of this GRANT statement? GRANT CREATE ON TO [EMAIL PROTECTED]; eg: GRANT CREATE ON address TO [EMAIL PROTECTED]; It's possible, but what is it supposed to do? I can understand this grant on a global (server) and database level, but on a table level? With regards

Re: Grants not entirely propagated to slaves?

> Hi, > it seems my Grants are not entirely propagated from the master to the slave > (some are active, some are not). > The slave is configured to replicate all databases, and the replication > client > has all privileges on the master. > > What is necessary t

Re: Grants not entirely propagated to slaves?

Atle Veka wrote: What version of MySQL are you using? Also, are you issuing only "GRANT .." statements or modifying the privilege tables manually as well? Search for 'GRANT': http://dev.mysql.com/doc/mysql/en/replication-features.html Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri,

Re: Grants not entirely propagated to slaves?

On Fri, 1 Apr 2005, Nico Sabbi wrote: > Hi, > it seems my Grants are not entirely propagated from the master to the slave > (some are active, some are not). > The slave is configured to replicate all databases, and the replication > client > has all privileges on the master. &g

Grants not entirely propagated to slaves?

Hi, it seems my Grants are not entirely propagated from the master to the slave (some are active, some are not). The slave is configured to replicate all databases, and the replication client has all privileges on the master. What is necessary to propagate every single grant? Thanks, -- Nico

Re: Grants

am facing some really > stupid issue :) > > I logged in as root without probleme create a database xoops which shows > when i do a show databases > > Now i try to give grants to a user on that datase via grant all on xoops.* > to [EMAIL PROTECTED] identified by 'something&#x

Grants

Hi, I juste installed mysq. 5.1 (alpha) and i guess i am facing some really stupid issue :) I logged in as root without probleme create a database xoops which shows when i do a show databases Now i try to give grants to a user on that datase via grant all on xoops.* to [EMAIL PROTECTED

Re: grants to multiple DBs at once

cs you list are for 4.1. I guess I will have to wait until 4.1. :) In the meantime, this works well: SYSTEM rm /var/mysql/tmp/grants-tmp.sql; SELECT DISTINCT concat('GRANT SELECT ON ',db,'.* TO [EMAIL PROTECTED]'%\' IDENTIFIED BY \'abc\';'),

Re: grants to multiple DBs at once

until 4.1. :) In the meantime, this works well: SYSTEM rm /var/mysql/tmp/grants-tmp.sql; SELECT DISTINCT concat('GRANT SELECT ON ',db,'.* TO [EMAIL PROTECTED]'%\' IDENTIFIED BY \'abc\';'), concat('GRANT SELECT ON ',db,'.* TO [EMAIL PR

Re: grants to multiple DBs at once

This is documented in the manual: Note: the '_' and '%' wildcards are allowed when specifying database names in GRANT statements that grant privileges at the global or database levels. So, if dev is the prefix, you need: GRANT SELECT ON

Re: grants to multiple DBs at once

- Original Message - From: "Brian C. Hill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 16, 2004 4:22 PM Subject: grants to multiple DBs at once > I have about 20 DB's with the same prefix. > > How can I do something like &g

grants to multiple DBs at once

I have about 20 DB's with the same prefix. How can I do something like GRANT SELECT ON dev_*.* I have seen examples for the _other_ DB software, like msql, that does something like: SELECT 'GRANT SELECT ON '+name+' TO webuser;' from s

Re: grants for non-root

I have MySQL 4.0.18-standard on RH 9 and it works fine + mysql> grant all on *.* to 'mysqladmin'@'localhost'; Query OK, 0 rows affected (0.06 sec) mysql> show grants f

grants for non-root

I try to set *all* privileges to a user, which should not called 'root' but should have its privileges (I'm connected as root): mysql> grant all on *.* to 'mysqladmin'@'localhost'; Query OK, 0 rows affected (0.00 sec) But now I get mysql> show grants

Re: Replication and Grants nightmare

Alle Friday 30 April 2004 16:44, hai scritto: > At 16:22 +0200 4/30/04, Nico Sabbi wrote: > >Alle Friday 30 April 2004 15:51, hai scritto: > >> >P.S. the manual doesn't say that grants super, reload, replication > >> > client and replication slave

Re: Replication and Grants nightmare

At 16:22 +0200 4/30/04, Nico Sabbi wrote: Alle Friday 30 April 2004 15:51, hai scritto: >P.S. the manual doesn't say that grants super, reload, replication client > and replication slave can be used only on *.* and not on DB.*. Each of those privileges is listed as an administrativ

Re: Replication and Grants nightmare

Alle Friday 30 April 2004 15:51, hai scritto: > >P.S. the manual doesn't say that grants super, reload, replication client > > and replication slave can be used only on *.* and not on DB.*. > > Each of those privileges is listed as an administrative privilege here: >

Re: Replication and Grants nightmare

0 rows > affected (0.00 sec) > > mysql> show grants for replica@'B'; > +------ >--

Re: Replication and Grants nightmare

P.S. the manual doesn't say that grants super, reload, replication client and replication slave can be used only on *.* and not on DB.*. Each of those privileges is listed as an administrative privilege here: http://dev.mysql.com/doc/mysql/en/Privileges_provided.html There are not list

Re: Replication and Grants nightmare

n doesn't even start. > Even worse is the fact that grants seems to be totally managed at random, > as you can see: > > (A and B obviously are fake names). > mysql A> GRANT REPLICATION SLAVE, REPLICATION CLIENT, SUPER, RELOAD on *.* TO > 'replica'@'B

Replication and Grants nightmare

Hi, I'm running mysql-max 4.0.18 on two servers on separate networks, master is A and slave is B. The problem is that if I don't grant on the master the full range of privileges to the slave the replication doesn't even start. Even worse is the fact that grants seems to be tot

RE: grants for START/STOP SLAVE

From: Paul DuBois [mailto:[EMAIL PROTECTED] > At 11:31 -0500 1/15/04, Mike Johnson wrote: > >This is in reference to 4.0.16, FWIW... > > > >I can't find any direct references to the actual grant permission > >for controlling a slave thread in the online docs. The closest I saw > >was the 5th par

Re: grants for START/STOP SLAVE

At 11:31 -0500 1/15/04, Mike Johnson wrote: This is in reference to 4.0.16, FWIW... I can't find any direct references to the actual grant permission for controlling a slave thread in the online docs. The closest I saw was the 5th paragraph on http://www.mysql.com/doc/en/Replication_HOWTO.html.

grants for START/STOP SLAVE

ileging the user, which I'd like to avoid if possible. Can anyone confirm that it's SUPER that grants permissions for START/STOP SLAVE? Is this actually documented anywhere? Thanks in advance! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL Ge

Grant problem, existent grants ended to work (fwd)

SQL Description: User has ALL grants to the database. mysql> show grants for [EMAIL PROTECTED]; +--- --+ | Grants for [EMAIL PROTEC

Re: User and permissions/grants - HELP!

;; <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 6:23 PM Subject: Re: User and permissions/grants - HELP! > > > i dont think there's any privilege called "ALL PRIVILEGES". You need to say > > just "ALL", like: > > > > GRANT ALL O

Re: User and permissions/grants - HELP!

> i dont think there's any privilege called "ALL PRIVILEGES". You need to say > just "ALL", like: > > GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY > '12345678' WITH GRANT OPTION; > GRANT ALL ON *.* TO newuser@"%" IDENTIFIED BY '12345678' WITH > GRANT OPTION; Maybe you should read the docum

Re: User and permissions/grants - HELP!

WITH GRANT OPTION; Enjoy Nitin - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 7:43 PM Subject: Re: User and permissions/grants - HELP! > "C. Reeve" <[EMAIL PROTECTED]> wr

Re: User and permissions/grants - HELP!

"C. Reeve" <[EMAIL PROTECTED]> wrote: > > I just installed MySQL version 4 and as usual, trying to set up users > and grant permissions is a nightmare. > I followed the instructions in the MySQL manual and granted permissions > to a user, like below: > > GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROT

User and permissions/grants - HELP!

Hi, I just installed MySQL version 4 and as usual, trying to set up users and grant permissions is a nightmare. I followed the instructions in the MySQL manual and granted permissions to a user, like below: GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY '12345678' WITH GRANT OPTIO

Re: Mysql original database and GRANTS.

Sohail Hasan <[EMAIL PROTECTED]> wrote: > > I want to bring back my mysql original database as well as root GRANTS > as was during the installation because i installed an application that > modified my root GRANTS and now I am not able to see my mysql database > as I login

Mysql original database and GRANTS.

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any

Re: GRANTs Options

Thnx for the hint Paul, I will do that. Regards.. From: Paul DuBois <[EMAIL PROTECTED]> To: "Miguel Perez" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: Re: GRANTs Options Date: Thu, 19 Jun 2003 18:57:15 -0500 At 18:47 -0500 6/19/03, Miguel Perez wrote: Hi everyone: I

Re: GRANTs Options

At 18:47 -0500 6/19/03, Miguel Perez wrote: Hi everyone: I wonder if the command GRANT could be alered. I mean if I have the following privileges over certain database: +--+ | Grants for [EMAIL PROTECTED

GRANTs Options

Hi everyone: I wonder if the command GRANT could be alered. I mean if I have the following privileges over certain database: +--+ | Grants for [EMAIL PROTECTED

re: row level grants ?

Paul, Thursday, October 10, 2002, 5:59:39 PM, you wrote: PG> i would like to know if row level grants are in development PG> or are planned to be soon. PG> i am writing a software and i need row level grants, PG> so i would like to know if i'd better wait for mysql to include

row level grants ?

bonjour, i would like to know if row level grants are in development or are planned to be soon. i am writing a software and i need row level grants, so i would like to know if i'd better wait for mysql to include this feature or write a sort of grant feature myself in the software (n

re: Bug at Hostname parameter for SHOW GRANTS FOR ...?

Moestl, Monday, September 23, 2002, 9:54:33 AM, you wrote: MW> If you have a host having the minus character '-' in the name the mysql command SHOW GRANTS FOR fails. MW> Example: MW> SHOW GRANTS FOR root@MY-COMUPTER results in the error message MW> "You have an er

Bug at Hostname parameter for SHOW GRANTS FOR ...?

Hi, If you have a host having the minus character '-' in the name the mysql command SHOW GRANTS FOR fails. Example: SHOW GRANTS FOR root@MY-COMUPTER results in the error message "You have an error in your SQL syntax near '-COMPUTER' at line 1". It looks like t

MySQL GRANTS

1. IN 4.0.3 I CREATE 3 USERS using 3 different clients and get slightly different results when I then run SHOW GRANTS FOR XXX; The user created by MySQL Front has a slightly different set of privileges even though the GRANT displayed by

RE: Grants UGGH! Not working for some reason ...

[snip] > I have a user that I am specifying for one database within the system. I > have granted, reloaded, deleted, re-done, and screamed at the server. None > the less, it still will not allow this user to do mysqlimport, ... [/snip] Figured it out. The user must have FILE privileges in order t

RE: Grants UGGH! Not working for some reason ...

> > [snip] > if you don't restart MySQL after changing the grants > priviliges, you have to > issue the "flush privileges" command from the MySQL Monitor. > If you don't do > either one your privilege changes will not take affect. > > not su

Re: Grants UGGH! Not working for some reason ...

Hi, - Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 7:01 PM Subject: Grants UGGH! Not working for some reason ... > Hi all! > > I have a user that I am specifying for one database with

RE: Grants UGGH! Not working for some reason ...

EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: FW: Grants UGGH! Not working for some reason ... [snip] if you don't restart MySQL after changing the grants priviliges, you have to issue the "flush privileges" command from the MySQL Monitor. If

FW: Grants UGGH! Not working for some reason ...

[snip] if you don't restart MySQL after changing the grants priviliges, you have to issue the "flush privileges" command from the MySQL Monitor. If you don't do either one your privilege changes will not take affect. not sure if when you said "reloaded" you meant

RE: Grants UGGH! Not working for some reason ...

if you don't restart MySQL after changing the grants priviliges, you have to issue the "flush privileges" command from the MySQL Monitor. If you don't do either one your privilege changes will not take affect. not sure if when you said "reloaded" you meant "

Grants UGGH! Not working for some reason ...

Hi all! I have a user that I am specifying for one database within the system. I have granted, reloaded, deleted, re-done, and screamed at the server. None the less, it still will not allow this user to do mysqlimport, as follows; mysqlimport --user=rcr_user --password=thepassword -f --fields-te

Re: GRANTs and %

Kaan, Tuesday, June 11, 2002, 11:04:36 AM, you wrote: KO> Thanks Dan And Okan for replying to my email but I have tried what you have KO> said but I still get the same problem. KO> GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; KO> ERROR 1064: You have an error in your SQL syntax

Re: GRANTs and %

On Tuesday 11 Jun 2002 11:04 am, Kaan Oglakci wrote: > Thanks Dan And Okan for replying to my email but I have tried what you have > said but I still get the same problem. > > GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; > ERROR 1064: You have an error in your SQL syntax near ''cl

Re: GRANTs and %

On Tue, 11 Jun 2002 09:04:36 +0100 Kaan Oglakci <[EMAIL PROTECTED]> wrote: > Thanks Dan And Okan for replying to my email but I have tried what you have > said but I still get the same problem. > > GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; > ERROR 1064: You have an error in y

RE: GRANTs and %

GRANT ALL ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123'; TO Simon -Original Message- From: Kaan Oglakci [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:05 To: '[EMAIL PROTECTED]' Subject: GRANTs and % Thanks Dan And Okan for replyi

GRANTs and %

Thanks Dan And Okan for replying to my email but I have tried what you have said but I still get the same problem. GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; ERROR 1064: You have an error in your SQL syntax near ''clients'@'%' IDENTIFIED BY '123'' at line 1 GRANT ALL ON newste

Re: GRANTs and %

In the last episode (Jun 10), Kaan Oglakci said: > Hi, > For some reason when I try to set up grants for a database by typing this > GRANT ALL ON newstesting.* to clients@% IDENTIFIED BY 'pass'; > > I get this error > ERROR 1064: You have an error in your SQL s

GRANTs and %

Hi, For some reason when I try to set up grants for a database by typing this GRANT ALL ON newstesting.* to clients@% IDENTIFIED BY 'pass'; I get this error ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY 'pass'' a t line 1 But when I typ

Re: Grants, rights, permissions

Thomas, Wednesday, May 01, 2002, 9:39:24 PM, you wrote: TS> I am having some trubble understanding, how permissions work with MySQL: TS> I've set up user, database, and host permissions: TS> User: Hosts:PW: Permissions: TS> tps Any pwAll TS> Anonymo

RE: Grants, rights, permissions

[snip] Now, if I understand correctly I might connect to database "duwt" as user "tps" from any host. But trying this I can't connect to database "duwt". Why? [/snip] Did you flush your privileges either using MySQL monitor or mysqladmin? Jay Blanchard ---

Grants, rights, permissions

Hi! I am having some trubble understanding, how permissions work with MySQL: I've set up user, database, and host permissions: User: Hosts:PW: Permissions: tps Any pwAll Anonymous 192.168.107.204 ''None Database: User: Hosts: Perm

RE: Question about grants/priviledges

Did you FLUSH the permissions? (aka, reload the server, in phpMyAdmin) Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Mark Roberts [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 14, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: Question about grants

Question about grants/priviledges

I created a database named: rcs I then granted access as such: grant all on rcs.* to rcs@localhost identified by 'password' with grant option; I then tried to run an sql file as such: ./mysql -h localhost -u rcs rcs -p < database_schema.sql Then I get the following error message: [robert@ser

Re: Grants to a database table that doesn't exist yet

To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 10:44 AM Subject: Grants to a database table that doesn't exist yet > > Is there someway I can force a Grant to take if the database table doesn't > exist yet? > > I have the datab

RE: Grants to a database table that doesn't exist yet

45 AM To: MYSQL-List (E-mail) Subject: Grants to a database table that doesn't exist yet Is there someway I can force a Grant to take if the database table doesn't exist yet? I have the database created, awaiting the data that is being dropped into it, but I want to set up privileges

Grants to a database table that doesn't exist yet

ould do this by editing the tables directly, there is just a bit more work involved ( user and tables_priv inserts ). I would really like the server to do the work though through the grant though I could create the table first, then make the grants, then delete the tables, BUT I have a slave replicating

Re: column level grants

You are restricted to SELECT, INSERT, and UPDATE privileges on columns. ALL won't work. Regards, Doug On Thu, 28 Feb 2002 11:31:15 -0600, Kenneth Hylton wrote: >Howdy - > >I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly >book and can't find an example of how to do c

column level grants

Howdy - I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly book and can't find an example of how to do column level security. We are running 3.23.46-Max on Red Hat 7.2 Here is what I am trying: mysql> GRANT ALL (BatchControlUri, IndustryId, UpdateId) ON dbEngine.BatchCo

SHOW GRANTS not returning anything?

Søren, Saturday, February 16, 2002, 2:59:02 PM, you wrote: SN> I'm a total newbie to MySQL, so I'm reading the documentation right SN> now. In "General Security" I read that "SHOW GRANTS" should give me a SN> picture of who has what rights, but if I us

Re: SHOW GRANTS not returning anything?

You can SHOW GRANTS FOR foo which gives you information about user 'foo'. To show info about everyone, use SELECT * FROM user; hth Doug On Sat, 16 Feb 2002 13:59:02 +0100, Søren Neigaard wrote: >I'm a total newbie to MySQL, so I'm reading the documentation right >no

SHOW GRANTS not returning anything?

I'm a total newbie to MySQL, so I'm reading the documentation right now. In "General Security" I read that "SHOW GRANTS" should give me a picture of who has what rights, but if I use "SHOW GRANTS" I get the following error: ERROR 1064: You have an error in

Grants on tables

Hello, I need to create a user ('x', for instance) that only has permission to access (Select, insert, update, delete) only 2 tables in a database ('test'). Assuming that 'x' does not exist, I execute the folowing statments ('a' and 'b' are the tables whose access I want to grant to 'x'), conne

Re: Grants question..

> Everything works great, except that I can't access a database created > by root as another user. When I grant privileges, from the command > line or phpmyadmin, things seem to work fine (no error message), but > access is still denied. I did restart MySQL after granting rights. You can also che

Re: Grants question..

At 4:10 PM -0400 9/4/01, Gil G. wrote: >Hello, > >I recently started using MySQL on FreeBSD. >Everything works great, except that I can't access a database created by root >as another user. When I grant privileges, from the command line or phpmyadmin, >things seem to work fine (no error message),

Grants question..

Hello, I recently started using MySQL on FreeBSD. Everything works great, except that I can't access a database created by root as another user. When I grant privileges, from the command line or phpmyadmin, things seem to work fine (no error message), but access is still denied. I did restart MyS

Re: HELP getting grants in order

Gilbert C Healton wrote: > On Wed, 11 Jul 2001, Gerald Clark wrote: > > >>> On Wed, 11 Jul 2001, Gilbert Healton wrote: >>> >>> The key commands are: >>> >>> grant all privileges on Baseball.* to gilbert identified by "first" >>> with grant option; >> > cut cut cut

Re: HELP getting grants in order

On Wed, 11 Jul 2001, Gerald Clark wrote: >> On Wed, 11 Jul 2001, Gilbert Healton wrote: >> >> The key commands are: >> >> grant all privileges on Baseball.* to gilbert identified by "first" >> with grant option; cut cut cut >try to 'gilbert'@'%' >or replace % with l

Re: HELP getting grants in order

Gilbert C Healton wrote: > I've been attempting to create a mySql database while granting > administration user permissions on just that database to a > particular user. I suppose I'm overlooking something simple, but I > just can't get it after a full day of playing. My root user and its

HELP getting grants in order

I've been attempting to create a mySql database while granting administration user permissions on just that database to a particular user. I suppose I'm overlooking something simple, but I just can't get it after a full day of playing. My root user and its password work fine, but my other u

Re: Show grants ??? Doubt

jan <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, April 01, 2001 1:10 PM Subject: Re: Show grants ??? Doubt > Hello. > > You seem to use an older version of MySQL which did not support SHOW > GRANTS. Too see when a feature was introduced, have a look at the >

Re: Show grants ??? Doubt

Hello. You seem to use an older version of MySQL which did not support SHOW GRANTS. Too see when a feature was introduced, have a look at the Changes History section in the fine manual. Bye, Benjamin. On Sun, Apr 01, 2001 at 12:27:13PM +0530, [EMAIL PROTECTED] wrote: > Hello

Show grants ??? Doubt

Hello all !! mysql> show grants for root@localhost; ERROR 1064: You have an error in your SQL syntax near 'grants for root@localhost ' at line 1 Could anyone please tell me where i'm going wrong .. Thank you Sajan --

Subsidies, Grants, Loans, Financing

the Canadian Subsidy Directory, a guide containing more than 2300 direct and indirect financial subsidies, grants and loans offered by government departments and agencies, foundations, associations and organizations. In this new 2001 edition all programs are well described. The Canadian