On 4/9/01 4:36 PM, "Cory Whitesell" <[EMAIL PROTECTED]> wrote:
> I have been happily using a program I developed that uses mysql to store
> technical support articles that I ancounter regularily. A new person is
> starting work here tomorrow, so suddenly, I need this to work over the
> network. The touble is, when I try to connect from the other workstation, I
> get the error: Access denied for user "ABCD@CORYE" (CORYE is the computer
> name on the network). ABCD is the username with which I connect locally, and
> it works fine. Do I need to set up the user ABCD differently? If so, how?
>
your database right?
you have GRANT privileges, right?
as you, from a machine that connects
GRANT ALL ON yourdatabase.* TO ABCD@% IDENTIFIED BY 'yourpassword';
then you will be able to connect from any machine you want, even from the
otherside of the world.
lookup the GRANT and REVOKE statements in the online manual at www.mysql.com
once you read them, it is much easier to control access rights.
oh, to make sure your changes take effect immediately, do FLUSH PRIVILEGES
in the mysql client to reload the security model.
---------------------------------------------------------------------
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
