MySQL

If you have a MySQL database in your plan then is this installed in your account. you can control your database via PhPMyAdmin in your Hosting Manager Control Panel, or via secure ssh (telnet) your MySQL database.

What is MySQL?
MySQL is an Internet-related Database System this usualy used with combination with PHP or ASP. You can find more information about MySQL on http://www.mysql.com.

On sites like http://www.weberdev.com you can find more information about PHP in combination with MySQL. You can find also more information about PHP here http://php.pagina.nl/

Do you still haven't MySQL in your package?
If you would like to use MySQL database with Personal plan, Starter or Lite plans you can do two things.

1.Extra MySQL database à € 2,- per month / 5 voor € 2,50 per month / 10 for € 3.50 per month.
2.Upgrade to a Lite+ Plan à € 12,50 p/month which already has 5 MySQL databases.

Automatic MySQL Backup to your own FTP folders*

You can make backup for your MySQL database if you login in Secure SSH - Telnet. This backup is in your root directory.

*You should have enogh space for your backup.

Backupschema:
7x a day backup (daily)
4x a week backup (weekly)
1x a month backup (monthly)

If you have any questions Clients Helpdesk

Manual
To connect with your MySQL database, you should to set "localhost" to use it for your applications, but not your domain name.

To make tables you can use this code:
( call the extension of yourscript .phtml or .php )

Replace mydatabase with the name of your database.
Replace username with your user name.
Replace password with your password.
Replace from products with the tabel which you want.

Sometime you have with some installation procedures also change the poort: poort 3306

<P>Titel</P>

<TABLE BORDER="1">

<?
mysql_connect(localhost, username, password);
$result = mysql(mydatabase, "select * from products");
$num = mysql_numrows($result);
$i = 0;

while($i < $num) {
echo "<TR>n";
echo "<TD>n";
echo mysql_result($result,$i,"prodid");
echo "</TD>n<TD>";
echo mysql_result($result,$i,"name");
echo "</TD>n<TD>";
echo mysql_result($result,$i,"price");
echo "</TD>n";
echo "</TR>n";
$i++;}
?>

</TABLE>

* Your username and password are protected and no visitor can see this on your site.

phpMyAdmin for MySQL

The phpMyAdmin is default in your Hosting Manager. If you have a MySQL database in your plan you can login with your FTP-login to phpMyAdmin to can control your database.

Security:
Your database issecured with user & password on your main account.

SSH / Telnet

You have a shared server (where is your site) with ssh with few possibilities. Not for all companies we can give this possibility, but you can contact us and we will see if we can do that for you or not. And not all the askes we get it will be accept it, and the advanced Shell cost € 24,- per year.

Your standard SSH Shell has the following options:

MySQL
You get your own MySQL shell.

Change password
You can via SSH2 change your password, log in with your username and password and follow the steps.