hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Just bought 1st server - Unknown MySQL server host error - how to fix?
Reply

Forum Jump

Just bought 1st server - Unknown MySQL server host error - how to fix?

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 10-06-2006, 02:27 PM
dtang dtang is offline
Junior Guru Wannabe
 
Join Date: Aug 2001
Location: ithaca, ny
Posts: 30

Just bought 1st server - Unknown MySQL server host error - how to fix?


Hey all,
So, I just bought my first server and am setting things up for the first time. Needless to say, I am a bit lost and would like to seek some advice.

The issue I'm having now is this...

When I try to connect to a mysql DB using the mysql_connect() php function by passing in www.mydomain.com as the host (NOT localhost), I receive the following error:
Unknown MySQL server host 'www.mydomain.com'

My host had originally said it was because DNS info was still propogating. However, it's been several days now and I'm still receiving the same problem.

The reason I use www.mydomain.com at times and not localhost is because I often run scripts from my local machine on the remote DB. I also sometimes query things across domains.

I am currently using WHM/CPanel. Any help would be greatly appreciated! Thanks.

__________________
Blogs - get paid to blog

PHP, CSS, & Javascript tutorials



Sponsored Links
  #2  
Old 10-06-2006, 02:31 PM
KingAdmin KingAdmin is offline
WHT Addict
 
Join Date: Feb 2004
Posts: 163
Please check if you can ping www.mydomain.com from your server, if not check your resolvers.

__________________
ServerWizards Inc ** http://serverwizards.com/ **
** MSN: support@serverwizards.com AIM: serverwizards **
| Complex System Management and Security Solutions Under One Roof |


  #3  
Old 10-06-2006, 02:47 PM
dtang dtang is offline
Junior Guru Wannabe
 
Join Date: Aug 2001
Location: ithaca, ny
Posts: 30
Hmm. For some domains that I've transferred, the ping is successful... for others, it isn't. How long does it take for the DNS propogation to complete?

Also, how do I check my resolvers?

__________________
Blogs - get paid to blog

PHP, CSS, & Javascript tutorials

Sponsored Links
  #4  
Old 10-06-2006, 02:59 PM
KingAdmin KingAdmin is offline
WHT Addict
 
Join Date: Feb 2004
Posts: 163
Quote:
Originally Posted by dtang
Hmm. For some domains that I've transferred, the ping is successful... for others, it isn't. How long does it take for the DNS propogation to complete?

Also, how do I check my resolvers?
Are all your domains resolving for you from your computer for example ? You can check your resolvers in /etc/resolv.conf

__________________
ServerWizards Inc ** http://serverwizards.com/ **
** MSN: support@serverwizards.com AIM: serverwizards **
| Complex System Management and Security Solutions Under One Roof |


  #5  
Old 10-06-2006, 03:10 PM
sirius sirius is online now
Community Liaison 2.0
 
Join Date: Nov 2002
Location: WebHostingTalk
Posts: 8,745
* Moved to Technical and Security Issues....

Sirius

__________________
I support the Human Rights Campaign!
Your welcome guide to Trinity Florida located just north of the Tampa and St Petersburg / Clearwater Beaches!

  #6  
Old 10-06-2006, 03:20 PM
dtang dtang is offline
Junior Guru Wannabe
 
Join Date: Aug 2001
Location: ithaca, ny
Posts: 30
I can successfully ping from my computer. They are all viewable from the browser, as well.

The problem I'm having is only when connecting to the MySQL DB using mysql_connect(). This even happens if the mysql_connect() function is called from the site itself (i.e. mysql_connect('www.mydomain.com' ...) from mydomain.com/connect_to_db.php).

What should I be looking for in my resolvers?

__________________
Blogs - get paid to blog

PHP, CSS, & Javascript tutorials

Reply

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Unusual DNS Error Leads to Internet Outage in China Web Hosting News 2014-01-21 12:16:24
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
Host Europe Group Acquires German Domain Registrar and Web Host domainfactory Web Hosting News 2013-10-29 11:42:04
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2013-08-19 12:25:00


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

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 Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?