fierdor Posted July 8, 2010 Share Posted July 8, 2010 Hey I am using XAMPP on Windows. I basically want to access a database running on a remote MySQL server. I have provided the IP of the remote machine. I have also edited the httpd-conf file on the remote machine. I am able to access the remote machine's phpmyadmin.. Like If i enter 172.xx.xx.xx/phpmyadmin I get the console However my application is not able to fetch any data from the database..I get this error.. Host 'xxxx' is not allowed to connect to this MySQL server in database.php on line 2 Could not connect to databaseHost 'xxxx' is not allowed to connect to this MySQL server What other permissions do i have to change? Quote Link to comment https://forums.phpfreaks.com/topic/207132-host-xxx-is-not-allowed-to-connect-to-mysql-server/ Share on other sites More sharing options...
FD_F Posted July 8, 2010 Share Posted July 8, 2010 run this command : GRANT ALL ON Dbname.* TO username@'yourip' IDENTIFIED BY 'yourpassword'; Quote Link to comment https://forums.phpfreaks.com/topic/207132-host-xxx-is-not-allowed-to-connect-to-mysql-server/#findComment-1082994 Share on other sites More sharing options...
fierdor Posted July 8, 2010 Author Share Posted July 8, 2010 Ok that was quick and awesome! Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/207132-host-xxx-is-not-allowed-to-connect-to-mysql-server/#findComment-1083000 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.