Knowledge Base

Result search in category MySQL New Search
Hosting >> Business >> Database >> MySQL
Configuration data MySQL

The data configuration data of your MySQL database can be recovered in the control panel clicking on the link "MySQL" visible only if the service has been activated.
Typically the data are as follow:

Host Name:
DB Name: xxxxx
DB username: xxxxx
Password: xxxxx
Port: 3306

Hosting >> Business >> Database >> MySQL
How to connect to MySQL DB using PHP or ASP

On 7Host servers you can connect to your MySql database from PHP pages and from ASP pages, using MyODBC driver.

Example of connection in PHP
$dbhost = "";
$dbname = "DB_Name";
$dbuser = "User_Name";
$dbpassword = "Password";
$db = mysql_connect($dbhost, $dbuser, $dbpassword);

Example of connection in ASP
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = ";db=DB_Name;" &_
"uid=User_Name;pwd=Password;driver=MySQL ODBC 3.51 Driver"

Hosting >> Business >> Database >> MySQL
How to manage your MySQL DB

You can connect and manage your MySQL DataBase using one of the following methods:
1. using MyphpAdmin is available in the control panel of your webspace where the service has been activated

2. using one of the MySQL Database Manager consoles available in the market place. 7Host recommeds EMS MySQL Manager, that you can download for trial.

MySQL data connection are available in the web space control panel into the "MySQL Administration" section.

Hosting >> Business >> Database >> MySQL
How to setup a MySQL DB

To activate your MySQL DB it is necessary to upgrade your account to MySQL service or if it is included in the plan choosen (Plus or Premium). It is possible to upgrade to MySQL service in the control panel, clicking on the "Upgrade" button of the domain where the service is associated.

Once you receive the activation confirmation of the service, you can create the MySQL DB through the control panel of the domain where you have activated the service, clicking on the link "Manage MySQL", where to insert the following data:
- DB Name
- DB Username
- DB Password

Hosting >> Business >> Database >> MySQL
Use of MySQL DB for more web spaces

It is possible to use your MySQL DB on other web spaces.

Please note that the renewal has to be done only if the web space to which it is linked is not expired. In this case, you can request to move the association of your MySQL DB to another web space contacting us on the HelpDesk.

New Search
This website uses cookies. Some of these cookies have been set already. More information can be read in our privacy policy.
You can accept our cookies by clicking here or by continuing to use the site