I just brought a VPS at hostican. How, i have no idea how to setup my site. In my registrar account : What nameservers should i enter for my domain name ?? I contacted hostican support, and they told me to put nameservers as ns1.xyz.com I dont get the point .. why would i point my nameserver to something that isnt resolved ??? Any kind of help will be really really appreciated.
Well.. if you have as least 2 ips, create custom nameservers in godaddy for your domain, ns1.domain.com (with the first ip) and ns2.domain.com (with the second ip) for example, but i think that if you don't know how to setup the dns you won't be able to manage a vps :S, do you have a control panel in the vps?
Yes, i have lots of control panels there is WHM, cpanel, virtuozzo and what not. Anyway, how do i create a custom private nameserver in godaddy ? Though, Anyway, i used godaddy for the sake of simplicity. My registrar is something else. And i dont see an option for creating "private nameservers".
They call it different things different places. If you don't have some place where you can say ns1.xyz.com is found on IP#00000000 then you need to find a different registrar. Once you do that and host the domain xyz.com in your WHM everything will resolve in a few hours.
Can a registrar NOT have an option for creating private nameservers ?? I actually DO not want to run my own DNS. I just want to host a database on my dedicated VPS ip address. How do i do that ??
Don't know about the first. Who is the registrar? Did you ask them? I think it is possible to use and IP with the mysql_connect function. You may or may not run into firewall problems. You may also need phpmyadmin or some software for management purposes.
I think that non-local connections are disabled by default in mysql because is a potential security risk, you need to enable it in mysql config (if it's not enabled)
Pwner is correct. There's no need for DNS if you're OK with using just the IP address. You will need to configure SQL to accept connections from a remote host, and for security purposes, I would only allow connections from that particular IP. Opening SQL up to the world is not a good idea. I run my own VPS, so if you have additional question, I'm subscribed to this thread - just post 'em here so everyone can benefit.