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]
