Hi Adam,
> client keeps saying "Access denied for user: 'adouglas@' (Using
password:
> YES)".
Suggestion: Try: GRANT ALL ON *.* TO adouglas@localhost IDENTIFIED BY
"your_password"
This will grant you access from localhost, i. e. the client tool (e. g.
MySQL Monitor, mysql.exe, or PHP script, or whatever) and server
(mysqld.exe) are running on the same machine.
For remote connects you will have to type something like this: GRANT ALL
ON *.* TO adouglas@% TO ... (as above)
This will grant access from *anywhere* (%) to the MySQL server.
In case you edit mysql.user directly (e. g. with PhpMyAdmin) you will
have to call FLUSH PRIVILEGES from the command line, or restart the
MySQL server.
Hope it helps.
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Adam Douglas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 7:17 PM
Subject: MySQL GUI Client
> Hi, I just downloaded the MySQL GUI Client and was trying to set it
up. The
> client keeps saying "Access denied for user: 'adouglas@' (Using
password:
> YES)". I've typed in the Host Name (IP Address) and have the proper
user
> name. Also I have the proper grant tables set for adouglas to access
it from
> the machine I'm on. I'm also using port 3306. Do you have any ideas on
how
> to solve this problem?
>
> ---
> Adam Douglas
> Webmaster
> Venmar CES Inc.
> E-mail: [EMAIL PROTECTED]
> Ph: (306) 242-3663 x285
> Fx: (306) 242-3484
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
