Professional Web Applications Themes

Remote access denied - MySQL

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: '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....

  1. #1

    Default Remote access denied

    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:
    '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 Guest

  2. #2

    Default Remote access denied

    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:
    '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 Guest

  3. #3

    Default Re: Remote access denied

    Max wrote: 

    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.
    net
    ==================
    Jerry Guest

  4. #4

    Default Re: Remote access denied

    On 13 Mar 2007 03:59:23 -0700, Max wrote: 

    Yes. This is working properly. Root access is disabled via network until
    a human being configures it otherwise explicitly. I strongly advise
    *not* turning network access for root without a password. I even advise
    not turning on root access via network *at all*. If you must use a shiny
    GUI tool as root to do something, ssh tunneling is the right way to do
    it.

    --
    41. Once my power is secure, I will destroy all those pesky time-travel
    devices.
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  5. #5

    Default Re: Remote access denied

    Thanks.
    Where is this controlled? I cannot log in under any other userneam
    either.

    Max Guest

  6. #6

    Default Re: Remote access denied

    On 16 Mar 2007 02:33:00 -0700, Max wrote: 

    http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

    You'll have to do this by ssh into the server and connecting to the
    mysql service using the CLI. The "Securing the Initial Accounts" section
    referred to there is particularly useful.

    --
    Windows gives you a nice view of clouds so you can't see any potentially
    useful boot time messages.
    -- Bill Hay in the Monastery
    Peter Guest

Similar Threads

  1. Remote Access snap-in "access is denied"
    By alex in forum Windows Server
    Replies: 0
    Last Post: June 7th, 07:48 PM
  2. Access denied when creating Access application object
    By Bill Murphy in forum ASP Database
    Replies: 7
    Last Post: July 31st, 05:37 PM
  3. Remote Assistance - Permission Denied
    By Patrik in forum Windows Setup, Administration & Security
    Replies: 1
    Last Post: July 9th, 03:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139