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 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)
Did you do FLUSH PRIVILEGES as root after you performed the GRANT? - Julian -- Julian C. Dunn Systems Administrator e: [EMAIL PROTECTED] p: 416-363-6316 x292 f: 416-363-6102 Devlin eBusiness Architects 185 Frederick St. Toronto, ON M5A 4L4 http://www.devlin.ca/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
