SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    I'm not a human
    Join Date
    Aug 2006
    Location
    India
    Posts
    281
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql return "mysql error number 1045 Access denied" when tried to connect!!

    hi

    when i tried to connect to the remote server from the local machine using mysql query browser, it returns the following error:

    MYSql Error Number 1045

    Access denied for 'root'@'122.122.34.44' (Using password:YES)
    I checked whether it contacting the server using ping and it's getting proper reply but couldn't connect.

    What would be the problem?
    Regards,
    Vijay
    Follow me on twitter @vijaycbe
    World Holiday Calander || My Cricket Blog

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    the root user probably doesn't have rights to connect from a remote machine.

  3. #3
    I'm not a human
    Join Date
    Aug 2006
    Location
    India
    Posts
    281
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm the admin for the site and I'm using Cpanel Software for managing the site.

    For every table i've granted all the privileges for the user.

    If i haven't provided the permission to access from remote machine , how can i grant that permission?
    Regards,
    Vijay
    Follow me on twitter @vijaycbe
    World Holiday Calander || My Cricket Blog

  4. #4
    SitePoint Member Andy_MoreNiche's Avatar
    Join Date
    Mar 2008
    Location
    Nottingham
    Posts
    9
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try and update the root users access location to %, this means anybody can access as root with correct password, it maybe set to localhost at the moment.
    Andy
    MoreNiche.com - Affiliate Program
    Soula.com - Website Design
    ICQ me: 47041822 Email: andy at moreniche.com


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
  •