PDA

View Full Version : I need to know the server name for my SQL


purebeat
12-28-2006, 01:25 PM
Hi guys!I am a new member here and ineed your help as soon as possible. I need to know the server name for my SQL. Basicly i need to install e107 for my Web page and need to put MySQL Server (local host),user name, and password.
Can anyone here help me?

Schelly
12-28-2006, 01:38 PM
I just use localhost -- no space between local and host. From the BH control panel, click into the link under Databases header that says MySQL Databases and scroll down to the header that says "Access Hosts" -- that's what you want.

:)

purebeat
12-28-2006, 01:46 PM
I just use localhost -- no space between local and host. From the BH control panel, click into the link under Databases header that says MySQL Databases and scroll down to the header that says "Access Hosts" -- that's what you want.

:)

plz explain to me how to fill the details to create the database from the installation page of e107
i sent the files to the public_html and i want to install the database

thanks a lot !!! :)

pmcinvest
12-30-2006, 01:14 AM
Don't know e107 but for anyone looking for info on creating a BH db the following may be helpful.

The database is created in Control Panel/MySQL Databases. This step only gives the database a name.

The fields are then created in Control Panel/phpMyAdmin

You will not see the database in your folders. Once data is entered in the fields, the data can be viewed in Control Panel/phpMyAdmin by clicking on your database name, then clicking the "Browse" icon.

You can also view and edit your data with a program called SQLyog. The basic version is free and can be found on any search engine.

Maggilove
12-30-2006, 03:08 AM
Hi guys!I am a new member here and ineed your help as soon as possible. I need to know the server name for my SQL. Basicly i need to install e107 for my Web page and need to put MySQL Server (local host),user name, and password.
Can anyone here help me?

In cPanel, click on MySQL Databases. In the Databases section, type in a name for your database, then click Add Db.

In the Users section, give yourself a username and a password and click Add User.

Then go back to the Databases section... select your username in the User box and your database name in the Db box... check All privileges, and click Add User to Db.

Once you have completed these steps, you will see under Connection Strings the information you need to enter during your installation.

dixieau
12-30-2006, 06:39 AM
plz explain to me how to fill the details to create the database from the installation page of e107
i sent the files to the public_html and i want to install the database


Hi purebeat, just in case you pop back in and haven't been successful, the trick with e107 is to create the database/username first (per maggilove's directions) then fill them in during the install.

When done all should be working fine :) I use e107 on one my sites, it's a nice CMS when up and running, good luck.

Schelly
12-30-2006, 08:43 AM
....as I said in this thread (http://www.bluehostforum.com/showthread.php?t=4381) (double post).

Still haven't heard back from this person.

mwmoriarty
02-10-2007, 02:55 PM
Don't know e107 but for anyone looking for info on creating a BH db the following may be helpful.

The database is created in Control Panel/MySQL Databases. This step only gives the database a name.

The fields are then created in Control Panel/phpMyAdmin

You will not see the database in your folders. Once data is entered in the fields, the data can be viewed in Control Panel/phpMyAdmin by clicking on your database name, then clicking the "Browse" icon.

You can also view and edit your data with a program called SQLyog. The basic version is free and can be found on any search engine.

What settings should I use with SQLyog?
MySQL Host Address:
Username:
Password:
Port:
Default Charset:

hicinbot
03-17-2007, 02:36 AM
What settings should I use with SQLyog?
MySQL Host Address:
Username:
Password:
Port:
Default Charset:

I feel your pain-- I've been beating my head against the wall for the past few days, but I've got SQLYog working on BlueHost now. Here's how:

Note: I believe you must have the paid version in order to use http tunneling. It won't work in non-tunnel mode; they disable remote access for security reasons.

1. Upload the SQLyogTunnel.php to your site. (It's in the SQLYog program directory.) Test it by entering the URL you uploaded to into your browser. If you did it right it will give you a little blurb about what it's used for and how it works.

2. For the MySQL Host Address: localhost
Username/Password : whatever your MySQL username/password is.
Port: 3306
Database: leave blank

3. Go to the second tab (tunnel) and click the check box to enable tunneling. Put in the URL you tested in step 1. Click the "test connection" button and you should be happy.

Hope that helps!

charlesgan
03-17-2007, 06:43 AM
this thread not just double posted.. also, date back to last year
12-28-2006, 01:25 PM ... should we just lock this !