Hey,
Today I tried to move my Drupal 7 website from localhost to your server. I exported the database from phpmyadmin and created a new DB and DB user to a new server and imported the database. After that I copied my website files to the new server's httpdocs folder root. When this was done, I edited the configure.php and set DB name, username and password to correspond the database I created. Still I receive the error message below:
Error
The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[28000] [1045] Access denied for user 'in2atmnet'@'84.38.227.121' (using password: YES) in lock_may_be_available() (line 167 of/var/www/vhosts/in2atm.net/httpdocs/includes/lock.inc).
Do you know why this error message appears? I Would really need to get my Drupal 7 site to go online. I really have no clue how to fix this error. I hope you can help!
Comments
Did you follow the
Did you follow the documentation (which answers these questions 90% of the time)?
You do mention whether you gave you db user all (or all relevant) privileges on the db.
Digit Professionals
Limited phpmyadmin
Hey!
I don't have full control over phpmyadmin, so I don't know how to change the user privileges. Here's a picture from my phpmyadmin control panel:
http://dl.dropbox.com/u/75717543/phpmyadmin.jpg
If you do have instructions on how to get this work, I would really appreciated to share your information!
I have tried to to put the website on the new server few times now, but I'm getting the same error every time.. I know it's something really simple but what could that be?
Regards,
Niko
Kind regards,
Niko Huhtaniemi
If you have the right on the
If you have the right on the server to create a database and a user you must be able to add privileges. On cPanel there is a separate interface which you often must use for creating db users. Or you can do it from command line. Just Google for the answer. To save your time (not that I am not busy!) I googled for you http://drupal.org/documentation/install/create-database
The command line method is there.
Generally it is best to talk to the person who is managing the server about how to get a site working on their server. Any real Drupal specialist hosting will sort out this problem quickly. If the person managing the server is not providing the support and access you need, best move the site to a new server.
Digit Professionals
is the problem only privileges?
Is the problem only with privileges then? The error message above appears because of privileges are somehow wrong? Do I need to give my database user which I created admin privileges? And how do I do this? I'm using really good server provider (uniserver.nl), but last time I contacted their support he didn't know Drupal, so I didn't receive any help.
Kind regards,
Niko Huhtaniemi
The concept of database
It might be a problem with databas privileges, though it is also possible there is some other problem. The concept of database privileges is outlined in the page I linked in my last post. They are not same as server privileges. If you have read it and still do not understand it, post again, but please read it first because it does take time repeating this stuff.
A Drupal specialist hosting company does cost more but is probably worth the extra in time saved (and often a faster page load).
Digit Professionals
hostname
The problem is now fixed. The problem was the hostname, I really was using a wrong hostname, embaressing.. :)
Kind regards,
Niko Huhtaniemi