I am trying to set up drupal without Fantastico. I started on my home computer as a development server and now want to upload to hostican.
I wanted to create two versions of drupal so I could run several drupal sites in more than one version.. So I created directories and installed the appropriate drupal on each one.
http://myname.com/dw57/sites/sitename1.com
http://myname.com/dw62/sites/sitename2.com
I uploaded all the files by FTP, created a dbname for sitename1 and a user name and password for the dbname.
Then I changed my settings.php in the main sitename1 directory to reflect the user name and password for dbname in the string
$db_url = 'mysql://dbusername

assword@localhost/dbname';
$db_prefix = '';
It still doesn't grant me access. I have my shared hosting user name that I can prefix to shared hosting. like $db_url = 'mysql://sharedhostingname_dbusername

assword@localhost/sharedhostingname_dbname';
But that doesn't work either. The $db_prefix = ""; line is for creating multiple sites in drupal, as I understand it, each with their own prefix in a common database. That is for having cookie cutter dbs, which I don't plan on, I believe.
What am I missing here? Why can't I get in? Do I have to include the sharehostingname_ as part of the dbname and dbusername? I've tried it both ways. Neither way works. Why can't I find this question answered anywhere in these forums? Doesn't anybody struggle with the same things as me?