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]
