Jump to content
  • Advertisement
Sign in to follow this  
Noods

[web] mySQL connection problems

This topic is 5414 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Im upgrading my host and my forums. Im going from Ikonboard to Invision. To do this, Im running a php converter that SHOULD connect to mySQL (on my personal server) from my new host and convert all the information to my invision board on my new host. However, every time I try and run through the php converter, it tells me it couldnt connect to my database (on my personal server) I have the IP, database name, user name and password correct. What else can cause this? I cant look at it right now, but what are some things I can try when I get home? Thanks in advance! -Noods

Share this post


Link to post
Share on other sites
Advertisement
Are you an administrator on the mysql box?

If so, all you need to do is change the allowed hostname of the user from localhost to * or, anybody. Or add a new user with the same name but with the host you're running the converter on, and some password (or the same) of course.

It *could* also be a firewall disallowing foreign mysql connections.

If not, just ask your admin to allow it. Hopefully he will, but you might need to buy him a few beers if he's in a bad mood.

Share this post


Link to post
Share on other sites
I think you may be on to something. The connection gets dropped right away, more like its rejected then failed to find it. I am the administrator, but how exacatly do you change the allowed hostname? I set this up a few years ago, and stumbled through it the whole way, Im not very familiar with mySQL.

I considered it being my router, but I byppassed it totally, and still no luck. I have no firewall otherwise.

Share this post


Link to post
Share on other sites
uhhh.... my mysql admin skills are rusty.

I think it might have a command to do this by itself, check the manual.

Barring that, the hard way looks something like

use mysql;
select * from users where username='joebob';
insert into users (exact stufff, "put new hostname in there", exact stuff);

not exact, and I'd check the mysql manual for how to do this teh right way first.

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

GameDev.net is your game development community. Create an account for your GameDev Portfolio and participate in the largest developer community in the games industry.

Sign me up!