Re: Permission Setup

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Terrance Win wrote:
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)


You need to grant permission for '[EMAIL PROTECTED]'. The text 
after the @ part in the grant statement is for the client hostname, not 
the server hostname.

	-Mark

- -- 
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+gNhktvXNTca6JD8RAlF3AKCRawjWoAfgG8LIApyAOksFKex1/wCgpju8
CRnElYsq0fgzRungVEjd4hI=
=c7be
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]