50 AM
Subject: Re: Granting all to a user with a db name prefix
Paco Zarabozo A. wrote:
> Hello All,
>
> I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i
> can't find the way to so it on the documentation. Let's assume the usern
Paco Zarabozo A. wrote:
Hello All,
I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i
can't find the way to so it on the documentation. Let's assume the username
is "john". I want him to have all privileges only on databases with the
prefix john, so he can:
- create and
Hello All,
I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i
can't find the way to so it on the documentation. Let's assume the username
is "john". I want him to have all privileges only on databases with the
prefix john, so he can:
- create and drop databases starting ON
I get the following:
ERROR 1045 (28000): Access denied for user
'dba'@'XP0406OEM' (using password: YES)
Did you do FLUSH PRIVILEGES as root after you performed the GRANT?
I don't think that's the problem. You only need to FLUSH PRIVILEGES
when you update the privilege tables directly. When
On Wed, 2006-02-08 at 11:37 -0600, John Doneker wrote:
> I was instructed to create my own userid comparable to root.
> So...
> 1. I decided to call my new userid dba.
> 2. I signon to the bugs (Bugzilla) database as root:
> 3. Then I did the following for the server level:
> mysql> grant all pr
"John Doneker" <[EMAIL PROTECTED]> wrote on 02/08/2006 12:37:01
PM:
> I was instructed to create my own userid comparable to root.
> So...
> 1. I decided to call my new userid dba.
> 2. I signon to the bugs (Bugzilla) database as root:
> 3. Then I did the following for the server level:
> mysql>
I was instructed to create my own userid comparable to root.
So...
1. I decided to call my new userid dba.
2. I signon to the bugs (Bugzilla) database as root:
3. Then I did the following for the server level:
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by ''
with gran
can i create a new user and 'grant all' to that user on all dbs and
THEN add/import new databases and that user will still have all
permissions on those as well?
-
Before posting, please check:
http://www.mysql.com/manual.ph
