Connecting to Remote MySQL server using SqlYog

Posted on 2006-05-03
Medium Priority
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

ID: 16596607
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

akshah123 earned 2000 total points
ID: 16597522
>>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 ...


Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

624 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