Lentes, Bernd skrev:
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
Carsten Pederseb wrote:
First, don't mess around with the grant tables. Many years
ago, that was indeed the way to control user access, but
things have progressed since then. How old is that MySQL book?
It's from 2005 and about MySQL-version 5.
Remove the manual edits you have made
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
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 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
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 of
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
Hello.
If you replicate the privilege tables in the mysql database and update
those tables directly without using the GRANT statement, you must issue
a FLUSH PRIVILEGES statement on your slaves to put the new privileges
into effect.
Nico Sabbi [EMAIL PROTECTED] wrote:
Hi,
it
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 Apr 2005,
Well i think i found a bug or a change un behavior between mysql 5.0.0 ans
mysql 5.0.1
The behavior i describe does not happen.
Can anybody else confirm this ?
Thanks
Yann
On September 22, 2004 21:51, Yann Larrivée wrote:
Hi,
I juste installed mysq. 5.1 (alpha) and i guess i am facing
Hi Michael,
Thanks for the reply.
It doesn't work, at least not with 4.0.18. I also tried without
the _ to simplify the case, but the grant statement isn't wild about
the wildcard. :)
The docs you list are for 4.1. I guess I will have to wait
until 4.1. :)
That's my fault. It does work with 4.0.18. (The manual is usually pretty
good at specifying when something is 4.1 only, by the way.) You need to
quote the db string with backticks, not single quotes (as I did in my
example). So, you would use
GRANT SELECT ON `dev\_%`.* TO [EMAIL
- 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 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
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
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
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 it
and
The user might need the FILE permission, I'm not sure.
Also might need the LOCK TABLES permission.
http://www.mysql.com/doc/G/R/GRANT.html
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Jay Blanchard [mailto:[EMAIL
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 but
[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
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'' a
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
[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
Hi Luc,
I don't know if this will help you but you can do:
GRANT DELETE,SELECT,UPDATE on qbslive.* TO .
But this will give permission to ALL tables in qbslive database...
Gurhan
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 10:45 AM
Luc,
I think you have to do the manual inserts to make this work before the
tables are there. I wrestled with this problem briefly, before writing a
quick script.
Scott Helms
Director of Technology, ZCorum
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To: MYSQL-List
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
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
35 matches
Mail list logo