I have successfully loaded and configured one drupal based site using and XAMPP sandbox on a Windows XP machine. I have uploaded it to the linus public server and everything works well.
I have now started on another site, created the database in phpMyAdmin, set up root username and setup a password.

I have setup the following string in my setup.php file;
mysql://root:'mypassword'@localhost/drupal-5.1/rts/rts
The first 'rts' is the home directory of the new site and the second rts is the name of the database for the site.
Now when I try to get access to phpMyAdmin I get an access denied message;

'phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.'
I have modified the config.inc.php to include my username and password, I have checked that WinmysqlAdmin panel as the correct username and password in the setup.ini panel, though I never had to touch this or config.inc.php in my first installation.

I have uninstalled xampp and reinstalled it about 9 times now and still I get Access Denied. I use it initially to create the database.
My site is all ready to be uploaded to the server but I cannot create my backup sql file before doing that.
I have tried the command line interface to mysql, but run into syntax problems I have not been able to solve with;
GRANT SELECT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, INDEX ON rts.* TO root@localhost/drupal-5.1/rts IDENTIFIED BY 'mypassword';
This command reports a syntax error within the string starting with /drupal-5.1 to 'mypassword'. I have tried different quote marks around the password.

Thanks very much for the anticipated help.
Patrick

Comments

venkat-rk’s picture

Did you grant all privileges to the root username for the second site's db? This might be the reason.

----
Previously user Ramdak.

muddypaws’s picture

I think I did, but now there is no way I can check as I can't seem to access the database through phpMyAdmin or via the dos interface.
If you have any ideas, I would be very grateful.

Patrick

muddypaws

Novark’s picture

Try changing it to
mysql://root:'mypassword'@localhost/rts

The sql config should not care what directory your site is in, just what database it needs

muddypaws’s picture

Thanks Novark,
I tried this before and I just tried it again.
No luck.
I shut down Apache and MySql and then restarted them and tried again, no luck I am afraid.
If you have any other ideas I would be very grateful.

As a matter of interest I have typed the following in dos

mysql -u root -p 'password' < c:/xampp/htdocs/drupal-5.1/rts/rts
and it says cannot find database of that name.
I created a database using that name and even when I do a search of the drive I cannot find any files myself of that name with an sql or mysql extension.

Patrick

muddypaws