How do I connect to and use MySQL?

by | Feb 22, 2011 | DNS and Domains, Knowledgebase

Please login to your control panel and follow these steps to create the database, user and its password: Once you login into your control panel, please click on “MySQL Databases” under “Database” section and then a) Use the option “Create MySQL database” to create the database, say “dbname”. The database name will have your username as its prefix username_ i.e. username_dbname b) Create a database user from the same interface and note down the username and password, say username_user c) Grant ALL privileges to this user on the database created using the option “Grant permissions on a MySQL database to a MySQL user” Now you have following ready: Database: username_dbname DB user: username_user DB user passwd: XXXXXX (this is what you setup in step b) host: localhost Now you can use these values in your php or perl script to connect it to the database. To browse your database, you can click on phpMyAdmin in your control...

What is MySQL?

by | Feb 22, 2011 | DNS and Domains, Knowledgebase

MySQL is a very robust database server. It is often used to deliver dynamic content to sites such as forums. The languages most often used to interface with the database server are Perl and PHP, however, C, C++, and Python among others may also be used. The official MySQL Web site may be found at:...

Can I have multiple A records for my domain to have fail over hosting?

by | Feb 22, 2011 | DNS and Domains, Knowledgebase

DNS (domain name system) does not allow multiple A records in a fail over fashion. There are also no priorities with A records. If you create multiple A records, the dns will resolve your domain in a round-robin fashion to all IPs. What this means is that if you have say 2 A records for your domain, and host your domain at two locations, some clients will see site at one location and others on the second one, at the same time, depending on what A record (resolution) they received. To setup a fail over requires much more than that. It involves clustering (expensive and reliable) OR automatic DNS update through some script (cheaper solution and slow). Example of clustering is that you have one device (e.g. a server) that handles the routing of traffic to which ever server is online. If one goes off, it starts redirecting the traffic to other. http://www.linux-ha.org is one such project. Second solution can be that if main server goes off, the DNS hosted at 3rd location updates the A record (which should have a low refresh time e.g. a few minutes). Depending on how fast the dns propagates, the traffic will start flowing to backup/second location. This solution requires custom scripting or 3rd party dns...

Can I view my site using domain name before DNS propagation?

by | Feb 22, 2011 | DNS and Domains, Knowledgebase

To access the website before its domain name starts resolving to the new IP address, please follow the following steps: (while you access the website from a Windows PC) You can setup a HOSTS file entry in the “hosts” file to view the web site. This file is a standard windows file. You can find it in the path below, depending on your windows: Windows 95/98/Me c:/windows/hosts Windows NT/2000 c:/winnt/system32/drivers/etc/hosts Windows XP c:/windows/system32/drivers/etc/hosts or c:/winnt/system32/drivers/etc/hosts STEPS: 1) Open this file in Notepad and 2) Add this line to it: IP www.yourdomain.com (where IP is the IP address of your shared server) 3) Save it 4) Open your browser and type the complete URL www.yourdomain.com. It should work fine and bring you the main page (index.html etc.) from public_html directory. NOTE: Once the domain name is ready, you should edit this file and remove the line above. Please also note that “hosts” is a simple text file without any .txt or any extension. It is a standard way to bypass the DNS servers for testing and...