Raised This Month: $ Target: $400
 0% 

MySql


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Migs Davis
Junior Member
Join Date: Mar 2006
Location: Wilton, CT
Old 04-07-2006 , 08:09   MySql
Reply With Quote #1

I've never had to connect to a database where host wasn't localhost, so this issue is somewhat confusing. The host of the MySql database is somewhat restrictive, and as expected the access error is:
Access denied for user: 'username@youcanresolvethisanywayh@)(0rs!' (Usin...

However, we are able to adminstrate our MySQL databases via cpanel, ergo phpmyadmin. In CPanel it has an option titled "Add Access Host". Is that what I'm looking for? I would assume not because I feel like I'm the accessing client not host... but why else would they give us that?

I know this isn't explicitly scripting related but I am getting the error in that context and I find these forums more helpful than most forums, thanks!
__________________
www.kdoubt.net - CS Syndicate website
------
(they need website hits \/\/\/)
www.awesomejon.com - friend's site (check galleries)
www.jednet.com - Friends website (check galleries)
www.djpeak.net - DJ website
Migs Davis is offline
Send a message via AIM to Migs Davis
Janet Jackson
Veteran Member
Join Date: Mar 2005
Location: far, far away from here
Old 04-07-2006 , 08:20   Re: MySql
Reply With Quote #2

Quote:
Originally Posted by Migs Davis
In CPanel it has an option titled "Add Access Host". Is that what I'm looking for?
Yep.
Quote:
I would assume not because I feel like I'm the accessing client not host... but why else would they give us that?
Look at it this way : your gameserver is a host that wants to access your database.
__________________
Janet Jackson is offline
Migs Davis
Junior Member
Join Date: Mar 2006
Location: Wilton, CT
Old 04-07-2006 , 08:47  
Reply With Quote #3

Alright thanks, but I need to look at another problem. Right now I'm testing it on a server I'm running off my computer, but when I add the access host, my ip address (with the last digit as the wildcard just out of safety, I still get the access denied error!
__________________
www.kdoubt.net - CS Syndicate website
------
(they need website hits \/\/\/)
www.awesomejon.com - friend's site (check galleries)
www.jednet.com - Friends website (check galleries)
www.djpeak.net - DJ website
Migs Davis is offline
Send a message via AIM to Migs Davis
Migs Davis
Junior Member
Join Date: Mar 2006
Location: Wilton, CT
Old 04-07-2006 , 08:52  
Reply With Quote #4

SORRY nevermind it just started working? Maybe it took sometime for the access list to update. Thanks Janet! I loved your last superbowl performance, that ring was a lil too freaky tho
__________________
www.kdoubt.net - CS Syndicate website
------
(they need website hits \/\/\/)
www.awesomejon.com - friend's site (check galleries)
www.jednet.com - Friends website (check galleries)
www.djpeak.net - DJ website
Migs Davis is offline
Send a message via AIM to Migs Davis
Janet Jackson
Veteran Member
Join Date: Mar 2005
Location: far, far away from here
Old 04-07-2006 , 08:54  
Reply With Quote #5

It wasn't me.
__________________
Janet Jackson is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:31.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode