Re: Not able to connect to server
Posted by:
Nick Roper
Date: August 31, 2004 03:24PM
Russell
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
See:
http://dev.mysql.com/doc/mysql/en/GRANT.html
Nick
--
Nick Roper
Subject
Written By
Posted
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.