ma3743 Posted July 21, 2005 Share Posted July 21, 2005 I’ve made my PHP site in my machine (local host) with dreamweaver and IIS web server. How can I Upload my database to remote web server? When I want to connect to mysql server on the remote web server I receive following error: Error: 1130 Host xxx.xxx.x.xx is not allowed to connect to this MySQL server Thanks in advance Quote Link to comment Share on other sites More sharing options...
ecstasy Posted July 23, 2005 Share Posted July 23, 2005 I’ve made my PHP site in my machine (local host) with dreamweaver and IIS web server. How can I Upload my database to remote web server? When I want to connect to mysql server on the remote web server I receive following error: Error: 1130 Host xxx.xxx.x.xx is not allowed to connect to this MySQL server Thanks in advance 256175[/snapback] Maybe you should try to connect to MySQL server using a local user for your MySQL remote server. I mean, a user local for that machine, not for your. Try to dump your local database and then run that DUMP on the remote machine. Have you? Enjoy! Quote Link to comment Share on other sites More sharing options...
jeremywesselman Posted July 23, 2005 Share Posted July 23, 2005 I’ve made my PHP site in my machine (local host) with dreamweaver and IIS web server. How can I Upload my database to remote web server? When I want to connect to mysql server on the remote web server I receive following error: Error: 1130 Host xxx.xxx.x.xx is not allowed to connect to this MySQL server Thanks in advance 256175[/snapback] You'll need to go into your cpanel(if you have one) and add your ip address to the "access hosts" list in the mysql databases page. It should be close to the bottom. You might have to create a new username and password to access from your computer also. Jeremy Quote Link to comment 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.