I want to connect and modify my mySQL database directly off the remote server (let's say it's www.mysite.com). So I use programs like mySQL Administrator: server host: mysite.com username: myusername password: mypassword But then it gives out error 1045: "Access denied for user 'myusername@(my ip number here) (using password: YES)" The thing is, if i just set the server host to be "localhost" it would work just fine. But that means I'll be working off my local server (my PC) instead of straight from the site (www.mysite.com) which is not what I want. So is there anyway to directly connect to the remote server? TIA
If you have full access on that db use: grant all on db_name.* to user_name@IP_OR_DOMAIN identified by 'some_password'; flush privileges;