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;
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.