PDA

View Full Version : Help Connecting mySQL database with application



Bahrook
03-29-2008, 07:19 AM
I have never used mySQL and usually have had people setup database linkages for me when using them. Now that this has been said, I have purchased a software package that uses a mySQL database. In looking at the process on Bluehost and their software package I have setup everything, but unfortunately it does not work.

This is what I have setup on my site:


Ran the mySQL Wizard
Created a database called "WUFCalendar"
Created an account called "admin" to control the access to the database


This is what the software package has requested and I have bold faced with blue the answers I have given it:


Database Host: box103.bluehost.com
Database Username: admin
Database Password: the password that matches the username
Database Name: WUFCalendar
Set Database Type to UTF8: No


I recieve an Access Denied error when I try to access the application.

I am really stuck and cannot find anything that assists me on making the connection. Can somone assist with what entries need to be made.

redsox9
03-29-2008, 09:07 AM
The Database Host should be "localhost" if you are calling from a MySQL database on your BH account.

felgall
03-29-2008, 02:33 PM
# Database Host: localhost
# Database Username: bhaccount_admin
# Database Password: the password that matches the username
# Database Name: bhaccount_WUFCalendar

where bhaccount is the account name for your BlueHost account.

obmadox
04-14-2008, 02:11 AM
i have a network diagram website, with servers, that i want to be interacting with its servers, but i dont know how can i connect them together and add a username and password, even if its one username & password.

felgall
04-14-2008, 02:22 AM
To do that you'd need to configure remote access to the databases on each server and then replace localhost with the appropriate value to connect to that server along with the appropriate database name and login details for that database on that server. That sort of thing is usually only done when you have multiple servers for your site, not when you have a small fraction of one server and are sharing the server with lots of others the way everyone does at BlueHost.