MySQL Forums
Forum List  »  Newbie

Re: Not able to connect to server
Posted by: Nick Roper
Date: August 31, 2004 03:24PM


Each connection is identified by a combination of username & host. So, as far as MySQL is concerned, a user named admin connecting from localhost is a different user to admin connecting from <machinename>. Permissions on the server are set for a combination of username & host. You may find that you have permissions set for admin@localhost but not for admin@<machinename>. If you want the admin user to be able to connect from any machine with the same permissions/password, then try granting privileges for admin@%, e.g:

GRANT ALL PRIVILEGES ON database.* TO admin@% IDENTIFIED BY password



Nick Roper

Options: ReplyQuote

Written By
Re: Not able to connect to server
August 31, 2004 03:24PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.