Viper114 Posted April 11, 2012 Share Posted April 11, 2012 A few days ago, we had our Static IP address changed by our ISP. Since then, it seems a Debian machine we use to connect to a remote MySQL database and back it up is forbidden again from connecting to it since it was set to read by IP address. I've been trying to apply permission again to allow this machine to connect, but the database is refusing to allow it. I've tried the following:grant all on DBNAME.* to 'root'@'newipaddress' identified by 'password';flush privileges;When I test to see if it will work, I get the error 1045 "Access denied for user 'root'@'domainname' (using password: YES) when trying to connect". I've even tried the above but putting in the domain name instead of the IP address, but it still gets refused. I'm not sure what else to try. Any ideas? Link to comment Share on other sites More sharing options...
Viper114 Posted April 15, 2012 Author Share Posted April 15, 2012 Nevermind, I decided to go from DBNAME.* to *.*, that worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.