FAQs
How do I set up MySQL on MyServerWorld?
The database itself does not exist as a file that you can upload or download using FTP. You can connect to the database in three ways Telnet, ODBC compliant software and via PHP version 3 or later.
Connecting to MySQL via SSH Telnet
You can connect to the server using SSH Telnet, once logged into the system you can access MySQL directly using the following command:-
mysql -u username -p databasename
You will then be prompted for the password for the database. This will then place you at the MySQL prompt, for information of the commands that you can then use please refer to the online documentation at the MySQL web site.
Connecting to MySQL via PHP
For direct integration of the database into your web pages for dynamic updates - we provide the HTML-embedded scripting language PHP.
The basic command that you need to use in your PHP script is this:-
$mysql_link = mysql_connect("DOMAIN NAME", "USERNAME", "PASSWORD");
This is the command needed to connect to the database. For details on the commands needed to handle the database please visit the PHP Web Site.
For further details on using PHP on your Host Europe virtual server please visit our PHP page.
Connecting to MySQL using MyODBC and an ODBC database
You can tie a database written in a PC based database package that is ODBC compliant - Microsoft Access, FoxBase and Dbase Pro are all ODBC compliant. To integrate this connection you will require drivers that convert the communication - you can download these drivers for Windows 95/98/ME and Windows NT/2000 from http://www.mysql.com/downloads/api-myodbc.html
The settings that you will require are:-
Hostname - Your domain name MySQL database name - the name of the database Username - database username Password - database password Port - 3306
Back to FAQs index
...
