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