I am not real savvy when it comes to installing scripts and working with SQL databases so I will try to explain this so that it is as understandable as possible. I am installing a script to create interactive websites. I use Hostgator and have numerous domains set up under one account as subs. I want this script to run in conjunction with one of the sub-domains. The instructions call for the script to be uploaded to public_html, I uploaded it into the sub-domain folder since that is where I want it to coordinate. It calls then for me to set up a SQL db which I did (the db is definately there). Then to actually install the script it calles me to fill some install info in, one of the fields being the DB name but for some reason it keeps telling me that I have not defined.chosen my DB which I have. I filled in the name exactly as it shows up in MySQL. Not sure where I am going wrong here... if the script should have been uploaded to public_html rather then the sub folder (if so, how can I connect the script to the actual domain I want it to work with). Any advise would be greatly appreciated.
Are use entering the FULL DB name? Normal syntax on cPanel hosting for both DB name and username are. cpanelusername_datbasename This detail hides in the fine print of the connection string info which you should see from the mysql tab of your control panel.
This is what my connection string shows: Connection Strings Perl $dbh = DBI->connect("DBI:mysql:dearaewi_vip:localhost","dearaewi_vip","<PASSWORD HERE>"); PHP $dbh=mysql_connect ("localhost", "dearaewi_vip", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("dearaewi_vip"); The Install Wizard calls for the following info and info I entered: DB Host - localhost DB Name - dearaewi_vip DB Username - dearaewi (or dearaewi_vip) DB Password - *password* Does this help to explain anything any better.... or show where I am goofing up? You don't think it has to do with the placement of the script? Thanks!
No, it should have nothing to do with the location as it clearly states that your DB is not defined... In your information above, you show that the DB name and DB username are the same. Is this infact the case? Is the name of the database the same as the username you entered?
Did you create a user for the DB and add the user to DB? It looks like you trying to use the DB name as the user. If you want to change your cPanel password and PM me the login info I will look at for free. And fix it if that is all it is.
The DB name and DB username ARE the same ( I have nemerous BD and they are all functional like that without any problems)
I have never done one that way but if you have and it works okay. Maybe the script can not handle that. What script are you trying to install?
I am trying to install VIP Interactive Website Creator. I usually just use Fantastico to install any scripts like Wordpress and it configures DB name and DB username the same so I just did the same. Not sure, have never installed scripts or DB 'manually'
Does your password include any "illegal" characters such as !@#$%^&*()_ ? If so, you may want to convert your password to something alphanumeric to see if this is possibly the cause. I know a few script I have used, and even created, sometimes fails the DB connect when I am using odd characters in the username or password.
No, I have a password generator and have never had a problem with the passwords... it is a straight alphanumeric password. The DB and username connected just fine, just can't seem to get the script and DB to connect.
OK, did you also manually add the user to the database by using the "Add User To DB" function within the DB function page?
The last bit worked!! We have success!! Thank you SOOOOOO much! Couldn't have done this without you!!