solidzh wrote:
2007/8/21, Jay Pipes <[EMAIL PROTECTED]>:
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
GRANT SELECT
2007/8/21, Jay Pipes <[EMAIL PROTECTED]>:
> Terry wrote:
> > Hello,
> >
> > I want to grant a user all permissions to all DBs on the system as
> > well as any new DBs that show up. I want to avoid having to modify
> > permissions everytime a new DB is added. Is there a way to do this?
>
> GRANT S
ndo on this.
Rolando,
Although I agree with you, I was only trying to answer Terry's question :)
Cheers,
Jay
Rolando Edwards wrote:
> You must be very careful when granting permissions on every database this way.
>
> Here is why:
>
> By giving a user permissions on all data
Terry,
I absolutely agree with Rolando on this.
Rolando,
Although I agree with you, I was only trying to answer Terry's question :)
Cheers,
Jay
Rolando Edwards wrote:
You must be very careful when granting permissions on every database this way.
Here is why:
By giving a user permis
You must be very careful when granting permissions on every database this way.
Here is why:
By giving a user permissions on all databases this way,
you also give away permissions to the 'mysql' schema.
This is where the grant tables live.
A person could
1) insert new users into mysql
Yep.
Terry wrote:
Just to verify, will that include all new databases?
On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote:
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions every
Just to verify, will that include all new databases?
On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote:
> Terry wrote:
> > Hello,
> >
> > I want to grant a user all permissions to all DBs on the system as
> > well as any new DBs that show up. I want to avoid having to modify
> > permissions everyti
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
GRANT SELECT, INSERT, CREATE, ... ON *.* TO 'username'@'hostname'
IDE
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
:53
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Database user Permissions
>
>
> "Jeff" <[EMAIL PROTECTED]> wrote on 10/12/2005 08:43:16 AM:
>
> > Just rebuilt one of my servers and when setting up MySQL
> again an old
> > problem I'
"Jeff" <[EMAIL PROTECTED]> wrote on 10/12/2005 08:43:16 AM:
> Just rebuilt one of my servers and when setting up MySQL again an old
> problem I'd had and worked around came up again.
>
> Why is it that if I grant a user@'%' permissions, that user can a
Just rebuilt one of my servers and when setting up MySQL again an old
problem I'd had and worked around came up again.
Why is it that if I grant a user@'%' permissions, that user can access
the database from any other machine on the network, but that same user
logon accessing
Check tables in mysql database with myisamchk. This might me some kind of table
corruptions.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Eg
At 09:52 AM 10/15/2004, Crouch, Luke H. wrote:
"user permission trouble"
MySQL version? I've been having some trouble with
4.1.5.
Anders
+===+
|Anders Green Email: [EMAIL PROTECTED] |
| Home:
we had a power outtage and for some reason our user permissions didn't seem to come
back? we had a record of granting a 'cfmysql'@'%.ourdomain.com' and it didn't seem to
work at all until I did a flush privileges...and even after that, I had to go in and
set up som
Never mind.
Didn't have 'localhost' in Db table 'Host' field for the database.
> I've got a user, joe, who has all privileges on database 'joe' except GRANT.
> I gave permissions to joe using this command:
> GRANT ALL ON joe TO [EMAIL PROTECTED]
>
> But if I'm logged in as joe to the joe db a
I've got a user, joe, who has all privileges on database 'joe' except GRANT.
I gave permissions to joe using this command:
GRANT ALL ON joe TO [EMAIL PROTECTED]
But if I'm logged in as joe to the joe db and try to create a table, I get
the error:
ERROR 1142: create command denied to user: '[E
In previous installs, I've never been able to do it 'right'
but fresh install (4.1.1), new machine. So I'd like to set it up
so perl Makefile.PL on modules will install without having to pass special
parameters to build process.
First. mysql_install_db sets up the test db so that the anonymous
Can someone please help. I have MySQL for windows installed and I don't understand how
to manage users. I have MySQL Control Center 0.8.10 Beta. The user I'm logged in as
apparently doesn't have permissions to run DDL. I'm trying to take a dump of a remote
db and run it here to install structure
I'm kinda new to administering MySQL. I have a remote db that I want to
backup to my local MySQL server (windows). I can do a dump of the db
from phpMyAdmin on the remote server. I try running it on my local
server through the MySQL Control Center, and it says "Read Only". I
don't have to enter pas
At 12:10 -0800 3/17/03, Mike Whybark wrote:
I just upgraded to
mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc
from 3.23.52. Both packages are via Marc Liyanage's binary
distribution from http://www.entropy.ch/.
following the upgrade, one (and only one) of the databases is
I just upgraded to
mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc
from 3.23.52. Both packages are via Marc Liyanage's binary
distribution from http://www.entropy.ch/.
following the upgrade, one (and only one) of the databases is
affected such that its' user access is disr
i want to add a user to my system that has permissions to backup all the
databases using mysqlhotcopy. i don't want to use the root user. so what
permissions (minium set) should i give the user in order to accomplish this.
thanks in advance,
shon
--
Check out the GRANTS section in the MYSQL manual
-Original Message-
From: Faizal Mangera [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 9:38 AM
To: [EMAIL PROTECTED]
Subject: user permissions in linux
Hi,
I'm new to both MySQL and LINUX, however still managed to ki
Hi,
I'm new to both MySQL and LINUX, however still managed to kind of get them
up and running.
I installed MySQL whilst I was logged in as ROOT. Now I can only run it when
I log is as ROOT. How do change permissions of the other users so they can
also run MySQL or create a new user which will
Thank you so much! That worked.
*big sigh of relief*
Erica
> -Original Message-
> From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 01, 2001 12:48 PM
> To: Erica Douglass
> Subject: RE: User Permissions Issue (Easy questions?)
>
>
grant alter, create, delete, drop, insert, select, update, index ON
name_of_database.* to name_of_database TO username@localhost identified by
"password" with grant option;
then
grant alter, create, delete, drop, insert, select, update, index ON
name_of_database.* to name_of_database TO userna
Hi,
I am working with an internal database. We add a user using the
following statements:
create database name_of_database;
GRANT alter, create, delete, drop, insert, select, update, index ON
name_of_database TO username@localhost identified by "password" with
grant option;
GRANT alter, create
28 matches
Mail list logo
