Hey everyone!
I'm running into some problems installing a new Drupal site as a subdirectory of a site that is already up and running. I'll do my best to explain.
Steps taken so far:
- Created a new MySQL database, wxyz
- In MySQL ran the command: GRANT ALL ON wzxy.* TO user@'localhost' IDENTIFIED BY 'password';
- Ran the command: FLUSH PRIVILEGES;
- In my /sites folder created a subfolder called: example.com.new-site
- In that folder I created a new files folder and added a fresh settings.php file
- In settings.php I pointed to my new database: $db_url = 'mysqli://user:password@localhost/wxyz';
- I also added this: $base_url = 'http://www.example.com/new-site';
- I added the following to my .htaccess file:
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} ^/new-site/.*
RewriteRule ^(.*)$ /new-site/index.php?q=$1 [L,QSA] - In terminal I added a sym link to point to the new directry: ln -s . new-site
Result? Nada. I get an error message saying user doesn't have access to that database. I've checked and double checked everything. I have four other Drupal sites running on this installation, all using the same credentials. As a test, I pointed my settings.php file to an existing database and it worked fine. As soon as I point it to a new database it fails. I ran the command, SHOW GRANTS FOR user@localhost; and it clearly says I have all privileges on the new database.
At this point I'm stumped. Is there something stupid I'm missing? Any feedback is greatly appreciated.
Thanks!
Andrew
