Hosting >> Business >> Database >> MySQLConfiguration 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: mysqlx.7host.com
DB Name: xxxxx
DB username: xxxxx
Hosting >> Business >> Database >> MySQLHow 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 = "mysqlx.7host.com";
$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 = "server=mysqlx.7host.com;db=DB_Name;" &_
"uid=User_Name;pwd=Password;driver=MySQL ODBC 3.51 Driver"
Hosting >> Business >> Database >> MySQLHow 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 >> MySQLHow 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 >> MySQLUse 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.