Database export to Cpanel
Hi
I am having some problems, I have done my drupal site on WAMP server, all well and good and uploaded my files to the live server using an ftp client, this worked fine.
I have exported my database threw wamp and uploaded it threw Mysql in Cpanel successfully but receive an error message as below when trying to access my new site, I have gone threw the forums and tried changing the path $db_url = 'mysql in settings.php but no results.
"If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.
The mysql error was: Access denied for user 'root'@'localhost' (using password: YES)."
Is there a step by step guide available that I am missing?
Your help and comments will be much appreciated
Thanks
Phillip
The line in settings.php
The line in settings.php should look like
'mysql://username:password@localhost/databasename';where username, password and databasename reflect the names you used on the live server when creating the database. With you can generally find the correct values under "mysql administration"
Success
I had to use the Cpanel username + my database username and the same with the database name, for example
//cpanelusername_username:password@localhost/cpanelusername_databasename';