Try using GRANT ALL ON Security.* TO newbuddy@'%' INDENTIFIED BY 'password';
Regards, Kelly Black Linux was very clearly the answer, but what was the question again? -----Original Message----- From: Terrance Win [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 12:57 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Permission Setup Dear Stefan, Sorry for incomplete information and also thank you for your help. Here is the recent condition .. --------------------------------------------------------------- mysql>status; ------------- mysql Ver 12.18 Distrib 4.0.12, for Win95/Win98(i32) Connection id: 338 Current database: mysql Current user: [EMAIL PROTECTED] SSL: Not in use Server Version: 4.0.12-nt Protocol version: 10 Connection: localhost via TCP/IP Client characterset: latin1 Server characterset: latin1 TCP port: 3306 Uptime: 5 hours 42 min 38 sec Threads: 1 Questions: 1796 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables:0 Queries per second avg: 0.087 ------------- mysql>GRANT ALL ON Security.* to [EMAIL PROTECTED] Identified by 'password'; Query OK, 0 rows affected(0,00 sec) mysql>exit Bye C:\mysql\bin>mysql -h network.srv -u newbuddy -p password ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) ---------------------------------------------------------------- Help me please. with Regards, Terry >From: Stefan Hinz <[EMAIL PROTECTED]> >Reply-To: Stefan Hinz <[EMAIL PROTECTED]> >To: "Terrance Win" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: Permission Setup >Date: Tue, 25 Mar 2003 21:00:00 +0100 > >Terry, > > > I 've a problem with permission setup. In my newly install MySQL > > server; First, I log into as 'root' and create a database, lets say >'myDB'. > > Then I Grant a user name 'admin' with password to that database'myDB' in > > hostname 'network.srv'. Then I log out from root account. > >Let's suppose your GRANT statement was okay. Better if you would >provide the statement you issued. > > > I tried to log in as 'admin' using password to the same host. > > %mysql -u admin -network.srv -p > > password:****** > >That should be "mysql -u admin -h network.srv -p". Let's assume you >specified that. > > > In this point the server said "Access Denied to user >[EMAIL PROTECTED], > > blablabla". > >That "blablabla" might hold some information worth posting. > > > Is there any mistake in my job? I'm using W2K server as OS. > >When asking a question like that, you should provide information like >the following sessions info: > >mysql> STATUS; >-------------- >mysql Ver 12.18 Distrib 4.0.10-gamma, for Win95/Win98 (i32) > >Connection id: 7 >Current database: GuideProf >Current user: [EMAIL PROTECTED] >SSL: Not in use >Server version: 4.0.10-gamma-max-nt-log >Protocol version: 10 >Connection: localhost via TCP/IP >Client characterset: latin1_de >Server characterset: latin1_de >TCP port: 3306 >Uptime: 1 day 1 hour 18 min 47 sec > >Threads: 1 Questions: 226 Slow queries: 10 Opens: 102 Flush tables: 1 >Open table >-------------- > >mysql> GRANT ALL ON test.* TO 'someoneelse'@'localhost' IDENTIFIED BY >'youwontguess'; >Query OK, 0 rows affected (0.19 sec) > >mysql> EXIT >Bye > >C:\mysql\bin>mysql -h localhost -u someoneelse -pyouwontguess >Welcome to the MySQL monitor. Commands end with ; or \g. >Your MySQL connection id is 15 to server version: 4.0.10-gamma-max-nt-log > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > >mysql> USE mysql; >ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database >'mysql' >mysql> USE test; >Database changed > >Look at the last couple of lines. They show that the privileges were >granted as expected. > >Regards, >-- > Stefan Hinz <[EMAIL PROTECTED]> > iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > >[filter fodder: sql, mysql, query] > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
