Followup Question Regarding a PHP site - Install.php Problem

[MikeinSC]

Okay, thanks to Chaloupe, I was able to move forward and modify my config.php file to match the mysql database I created. Now, the second problem I ran into was trying to create the tables with the install.php file. After uploading the contents of the site, I then ran the following from the web browser:

www.mydomainname.com/install.php

The following error was received:

------------------------------
Warning: mysql_connect(): Access denied for user 'mysite_myusername_'@'localhost' (using password: YES) in /home/mysite/public_html/practicesite/install.php on line 6
Access denied for user 'mysite_myusername'@'localhost' (using password: YES)
------------------------

Do I need to modify the install.php file? Any ideas on this?

Thanks,

Mike

[Serra]

Originally Posted by MikeinSC

Do I need to modify the install.php file? Any ideas on this?

Make sure the username and password are right and that the user was added to the database.

[quietFinn]

There are always 5 things regarding databases you have to check:

1. database host, in HostGator it's "localhost".
2. database name, it will always be <username>_<databasename>, i.e. if your username is "tester" and you create a database "db", the actual database name will be "tester_db".
3. database user, the naming is the same as above, and many times database name and database user are the same.
4. database user's password, whatever string (just don't make it too easy to guess).
5. database user must have access to the database (usually all rights).

[MikeinSC]

Okay...I think I am getting closer. Thanks to Serra and Finn for their help.

I think I was able to get the tables to install. However, I did run into a message:

No database selected at row 15

Not sure what this means. Thoughts?

Thanks,

Mike

[quietFinn]

Originally Posted by MikeinSC

Okay...I think I am getting closer. Thanks to Serra and Finn for their help.

I think I was able to get the tables to install. However, I did run into a message:

No database selected at row 15

Not sure what this means. Thoughts?

Thanks,

Mike

It'd be much easier if we saw the row 15

[MikeinSC]

Finn...not a problem. I will be more than happy to show you. Where on my server would I find that information? I am only on the Baby Croc plan. Would I still be able to find that info?

Thanks,

Mike

[MikeinSC]

Okay...I went in to the PHPAdmin area and pulled up the database I created. There are no tables created. So, getting back to my error, do I look in the install.php on row 15, or, in the database itself?

Thanks,

Mike

[Junko]

Might be script error?? Sometimes it can be..

Try to upload again. It works for me tho

Mike,

It sounds as if it's a code issue based on the error received: i.e. it isn't properly working.

I'd recommend contacting the developers of the script for further information!

[Serra]

Originally Posted by MikeinSC

No database selected at row 15

Normally, this means that you are doing a select query without specifing a database with a select command. (sounds oddly like a non answer). Look at mysql_select_db