"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> grant all privileges on *.* to [EMAIL PROTECTED] identified by > '????' with grant option; > Query OK, 0 rows affected (0.09 sec) > > 4. Then, I did the following for the database level: > mysql> grant all on bugs.* to [EMAIL PROTECTED] identified by '????' with > grant option; > Query OK, 0 rows affected (0.11 sec) > > 5. I exit and try to sign back into the bugs database as dba with > the following syntax: > S:\MySQL Server 4.1\bin>mysql -u dba bugs -p???? -h hostname > > (The password (-p????) is the same in steps 3,4 & 5. > > I get the following: > ERROR 1045 (28000): Access denied for user 'dba'@'XP0406OEM' (using > password: YES) > > I have 2 questions: > 1. Why can't I signon to the bugs database as dba? > 2. Is the above steps I did procedurally correct? > I appreciate everyone's help in advance. Thanks. > > J. Wayne Doneker > BAE Systems > York Pa. > 717 225 8109 > Email: [EMAIL PROTECTED] > > Did you literally, actually identify your new account as 'dba'@'hostname' or did you say 'dba'@'XP0406OEM' in the GRANT commands? That could be your problem. MySQL requires that both the user name (to the left of the @) and the hostname from where they are connecting (on the right side of the @) to match before a user is recognized. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
