Jump to content

Recommended Posts

Posted

Hii,

 

im a user of ASP.NET(C#), well i know heliohost didnt provide MSSQL for database.

so i converted my codes to MySQL.

i created MySQL databse in CPANEL & use PhpMyAdmin for create my tables. all done perfectly.

now, i need connection string. i dont know how to find this strings. please help me

i will use connection String in ASP.NET web.config file.

for my localdatase in computer i used this>>

 

<add name="myConnString" connectionString="Server=127.0.0.1;Port=3306;Database=ella;Uid=root;Pwd="password" providerName="MySql.Data.MySqlClient"/>

 

now what is the Heliohost connection string.

i need SERVER IP, PORT, ...& what uid & pwd use in this, from MySQL or my main account id/pass.

my website name is ellalanguages.co.cc & username "jessash7"

please tell me what to do

 

thank you.

Posted

Server - localhost

Port - 3306 (usually not needed in PHP applications, but I'm not sure about ASP.NET)

Database* - cpusername_dbname

UID** - cpusername_mysqlusername

Pwd** - mysqlpassword

 

*MySQL Database names are in the format of cpanelusername_database name. For example, if your cpanel username was "heliohost" and your database was called "db123," you would have to put "heliohost_db123" into your app.

 

**To create a MySQL username and password: In your cPanel, go to MySQL Databases (the same place you created a database). Under MySQL Users, enter a username and password (twice) to create a MySQL User. This does not have to be the same as your cPanel username and password. Under Add User to Database, select the new username you just created and the database name (joomla1), then click Add. On the next page, click the box next to All Privileges and then press Make Changes.

 

Please note that your MySQL username also requires your cpanel username and and underscore (like database names), but your password is just the password you created.

Posted
Server - localhost

Port - 3306 (usually not needed in PHP applications, but I'm not sure about ASP.NET)

Database* - cpusername_dbname

UID** - cpusername_mysqlusername

Pwd** - mysqlpassword

 

*MySQL Database names are in the format of cpanelusername_database name. For example, if your cpanel username was "heliohost" and your database was called "db123," you would have to put "heliohost_db123" into your app.

 

**To create a MySQL username and password: In your cPanel, go to MySQL Databases (the same place you created a database). Under MySQL Users, enter a username and password (twice) to create a MySQL User. This does not have to be the same as your cPanel username and password. Under Add User to Database, select the new username you just created and the database name (joomla1), then click Add. On the next page, click the box next to All Privileges and then press Make Changes.

 

Please note that your MySQL username also requires your cpanel username and and underscore (like database names), but your password is just the password you created.

 

Thank You, I will try, if it worked or not...i will inform you ;)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...