, 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 are not restored. So, does
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
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, ignore them after that.
--
Bier met grenadyn
Is als mosterd
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 their own
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 | Y
database lentes_1;
Query OK, 1 row affected (0.01 sec)
And now i can assign grants on this database to other users:
mysql grant select on lentes_1.* to 'eitz'@'localhost';
Query OK, 0 rows affected (0.00 sec)
Bernd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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 the
(r...@localhost) [(none)] SELECT CONCAT('SHOW GRANTS FOR \'', user
,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants;
+-+
| mygrants
, 2009-07-22 at 12:58 -0700, Daevid Vincent wrote:
(r...@localhost) [(none)] SELECT CONCAT('SHOW GRANTS FOR \'', user
,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants;
+-+
| mygrants
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 (
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: MySQL General
Subject: grants
Hi
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
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
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
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
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
--- 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 received that there is no such grant
defined for
'user1
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 SELECT * FROM user WHERE User
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
executing
'flush
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,
What is the purpose
Hi there,
What is the purpose of this GRANT statement?
GRANT CREATE ON tablename 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?
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, 1
,
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 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.
What is necessary to propagate every single grant
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
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
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';
But i keep getting this error
ERROR 1044
. :)
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 PROTECTED]'%\' IDENTIFIED BY \'def\';'),
concat('GRANT SELECT
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\';'),
concat('GRANT SELECT ON ',db,'.* TO [EMAIL PROTECTED
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
- 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
GRANT SELECT ON dev_*.*
I have seen
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.
http://dev.mysql.com/doc/mysql/en/GRANT.html
So, if dev is the prefix, you need:
GRANT SELECT ON
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 for 'mysqladmin'@'localhost';
ERROR 1141
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 for 'mysqladmin'@'localhost';
+-+
| Grants
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 totally managed
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 listed
Alle Friday 30 April 2004 15:22, Victoria Reznichenko ha scritto:
Hmm..
Your queries worked fine for me:
ANT REPLICATION SLAVE, REPLICATION CLIENT, SUPER, RELOAD ON *.* TO
'replica'@'B' IDENTIFIED BY PASSWORD '715a443962d324cc'; Query OK, 0 rows
affected (0.00 sec)
mysql show grants
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:
http://dev.mysql.com/doc/mysql/en
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 administrative privilege
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 can be used only on *.* and not on DB.*.
Each of those
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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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
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 paragraph on
SQL
Description:
User has ALL grants to the database.
mysql show grants for [EMAIL PROTECTED];
+---
--+
| Grants for [EMAIL PROTECTED
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 documentation
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 ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'12345678' WITH GRANT OPTION;
GRANT ALL ON *.* TO newuser@% IDENTIFIED BY '12345678
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 PROTECTED]
: 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] wrote:
I just installed MySQL version 4 and as usual, trying to set up users
and grant permissions is a nightmare
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
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 from root account. I am
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
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
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
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 wonder if the command GRANT
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
PG this feature
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
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 the command processor stops
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 error in your SQL syntax near
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
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
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 flush privileges but if not try
[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 flush privileges but if not
try
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 you
don't do
either one
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 within the system. I
have granted, reloaded
[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 flush
privileges
[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 to
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
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 replying to my email but I have tried what you
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 your
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
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
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 syntax near '% IDENTIFIED BY
'pass
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 Anonymous
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:
[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
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:
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
, 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 this database ( so when I load the
data
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 to it before
-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 database created, awaiting the data that is being dropped into
it, but I
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
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
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 your SQL syntax near '' at line 1
What am I
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
now. In General Security I read
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 use SHOW GRANTS I get the
SN following error: ERROR
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'),
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 check
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
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), but
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
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 localhost or
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
try to 'gilbert'@'%'
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
TECTED]
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
Changes History section in the fine man
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
-
Before
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 all
of 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
97 matches
Mail list logo