Connecting to Remote MySQL server using SqlYog

Posted on 2006-05-03
Last Modified: 2012-06-22
I have Sql Yog running on my computer.
I have a remote server on the internet that has all of its ports open for my ip address.
I know the root username and password for this server.
but when I try to connect to the server supplying the username and password, SqlYog says:
error No: 1045 access denied for user eggster@x.x.x.x (Using Password: YES)
Question by:eggster34
    LVL 10

    Expert Comment

    Hi eggster34,
    You got a problem . .  MySQL reserves different rights for users logging on from LocalHost, and remotely. You can't set grants for root@% (any host) because that would open your database to anyone who might want to try to hack the root password. If you have a fixed ip address, you might get away with it.

    Regards .. Alan
    LVL 17

    Accepted Solution

    >>I have a remote server on the internet that has all of its ports open for my ip address.

    Sounds like you already have a static ip for your computer.  THis is good.  As ADSaunders said, mysql also has extra level of permissions for people logging in from different IP Address.  This means that the same user logging in from different ip addresses can actually have different permissions.  You can do something like following ....

    GRANT ALL PRIVILEGES ON databasehere.* TO 'eggster'@'x.x.x.x'
      IDENTIFIED BY 'yourpasswordhere';

    For more info on this visit ...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API ( …
    Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now