PDA

View Full Version : Accessing MySQL outside of powweb?

php-junkie
2-2-06, 09:17 AM
Possible?
tbonekkt
2-2-06, 09:36 AM
No - remote connections to the MySQL servers are disabled.
YvetteKuhns
2-2-06, 10:44 AM
The no remote connections rule is nice for added security.
php-junkie
2-2-06, 03:42 PM
I'm a dedicated powweb fan. You guys will make lots of money off me. In fact my current package is full with serviced domains and the next website a build will require a new package. So how about making it possible? Allow your customers to add ip addresses to mysql accounts.
tbonekkt
2-2-06, 03:45 PM
That's not going to happen. Back when remote connections were allowed, the servers were not reliable at all. Closing down the connections vastly improved reliability and performance.
YvetteKuhns
2-2-06, 04:04 PM
Are you trying to share a database with more than one website? Is it possible for more than one PowWeb hosted site to connect to the same PowWeb hosted mysql database?
BerksWebGuy
2-2-06, 04:22 PM
Is it possible for more than one PowWeb hosted site to connect to the same PowWeb hosted mysql database?

Sure. Example, have sites from 2 packages hit one database. As long as you're within the powweb realm, you shouldn't have any real problems.
YvetteKuhns
2-2-06, 04:35 PM
I was wondering if that was something php-junkie would consider. I thought it was possible, but I was hoping for confirmation from someone who was doing it successfully. ;)
php-junkie
2-2-06, 06:27 PM
It's a game server that I need to dump data from for viewing characters and character stats, as well as doing character/guild searches and viewing top waring guilds from my site. I need to be able to access this db from my game server.

I'd set up mysql on the game server but my server app is written 100% in C# using the .net framework and we all know that mysql can be a resource hog on a windows machine because it wasn't designed for windows and because of this installing mysql on my game server isn't a option. My server app eats a mad amount of resources.

I'd hate to have to get a new server just for running mysql on freebsd.
php-junkie
2-4-06, 07:59 AM
Wow, where does this give? I can't remotely access MySQL on powweb and I can't access a remote MySQL server from powweb.

Database access error 1130: Host 'clust10-www02.powweb.com' is not allowed to connect to this MySQL server