Results 1 to 7 of 7

Thread: Denied Access

  1. #1
    Join Date
    Jul 2006
    Location
    just north of Boston, MA
    Posts
    1,806
    Thanks
    13
    Thanked 72 Times in 72 Posts

    Default Denied Access

    Last week I was able to connect to my mysql front-end, and the computer was off all weekend. now when I try to connect, it is saying denied access. It will only allow me to connect via the local host, rather then trying to connect via the server directly. So I went into my command prompt to use the root password and its giving me this error

    Code:
     ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

  2. #2
    Join Date
    Jul 2006
    Location
    Canada
    Posts
    2,581
    Thanks
    13
    Thanked 28 Times in 28 Posts

    Default

    Where is your MySql host, on the web, or localhost?
    - Mike

  3. #3
    Join Date
    Jul 2006
    Location
    just north of Boston, MA
    Posts
    1,806
    Thanks
    13
    Thanked 72 Times in 72 Posts

    Default

    both. There is an offline copy on the local host, but I wanted to edit the one on the web.

  4. #4
    Join Date
    Jul 2006
    Location
    Canada
    Posts
    2,581
    Thanks
    13
    Thanked 28 Times in 28 Posts

    Default

    If you want to edit the localhost one:
    Code:
    mysql_connect("sql.myhost.com","user","pass");
    Most of the time you will have to log in with the MySql host, your hosting service provides. Sometimes it will be localhost, though.
    - Mike

  5. #5
    Join Date
    Jul 2006
    Location
    just north of Boston, MA
    Posts
    1,806
    Thanks
    13
    Thanked 72 Times in 72 Posts

    Default

    well what I am trying to do is login using a front-end client call MySQL Admin. It is saying that access is only allowed from local host. but last friday, it let me do whatever I wanted

  6. #6
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    Perhaps your webhost (or the people hosting your MySQL database) changed the configuration of the MySQL server. If you still cannot login with it directly (or even using the php snippet Mburt posted), then you may want to speak with your host directly.

    Hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

  7. #7
    Join Date
    Jul 2006
    Location
    Canada
    Posts
    2,581
    Thanks
    13
    Thanked 28 Times in 28 Posts

    Default

    Quote Originally Posted by pissa
    well what I am trying to do is login using a front-end client call MySQL Admin.
    Personally, I would learn to get a feel for the MySql command line. If you download the MySql server, it comes with it. Either that, or get used to running MySql commands via PHP, I usually create a file called exec.php, or run.php to execute my commands.
    - Mike

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
  •