Results 1 to 2 of 2

Thread: Enable client MySQL access from external machine

  1. #1
    Junior Member Newbie
    Join Date
    Dec 2005
    Posts
    29

    Default Enable client MySQL access from external machine

    In short, I need to connect to MySQL using an IP (not "localhost"). I will be inserting several rows via a software application that I am writing. Please note that I can connect correctly to MySQL using PHP with the localhost parameter.

    After failing to connect remotely to MySQL by using my server IP (66.249.24.167), I researched a bit and found that I need to run a MySQL "GRANT ALL..." command for that specific user. All attempts to do this however have resulted in an error stating "Access denied for user: 'root@localhost' (Using password: YES)". I have tried this both through PHPMyAdmin as well as SSH.

    Here is my example command i used in SSH (with my password marked out):
    Code:
    mysql> use bent;
    mysql> grant all privileges on *.* to root@'%' identified by '*****' with grant option;
    Any help at all would be greatly appriciated.

    Domain: wearebent.com
    Server IP: 66.249.24.167
    Last edited by schizo; 02-01-2006 at 09:27 AM.

  2. #2
    Junior Member Newbie
    Join Date
    Dec 2005
    Posts
    29

    Default

    Problem solved. I was accessing the mysql prompt as root instead of admin (I forgot that plesk changed these two).

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
  •