This is a discussion on Remote access denied within the MySQL Database forums, part of the Database Forums category; I am trying to access a DB that is hosted on a remote server. Whe I try to log in (...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
I am trying to access a DB that is hosted on a remote server.
Whe I try to log in (as root, with no pw) I get the following msg: ERROR 1045 (00000): Access denied for user: 'root@office.evans.ru' (Using password: NO) Accessing the DB locally (SSH into the server an then log in) works perfectly. I've tried remotely from both command line and from MySQL Quesry browser. Any ideas? Thanks. |
|
|||
|
Max wrote:
> I am trying to access a DB that is hosted on a remote server. > Whe I try to log in (as root, with no pw) I get the following msg: > ERROR 1045 (00000): Access denied for user: > 'root@office.evans.ru' (Using password: NO) > Accessing the DB locally (SSH into the server an then log in) works > perfectly. > I've tried remotely from both command line and from MySQL Quesry > browser. > Any ideas? > > Thanks. > Your system only allows root to sign in from localhost (which is good, IMHO). You need to grant privileges to allow a user at other than localhost to connect. See <http://dev.mysql.com/doc/refman/5.1/en/grant.html> -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ================== |