PDOException: SQLSTATE[HY000] [1045] Access denied for user 'name'@'address' (using password: YES) in lock_may_be_ava | Opigno LMS | Learning Management System based on Drupal

gavriela

Mon, 10/01/2018 - 09:19

Forums

I have a website were an Opigno platform was added and now I want to transfer this platform to another website of mine. I used filezilla to access the server with ftp and added the opigno backup. When I tried to go to the appropriate link where the platform should be, I get this error: PDOException: SQLSTATE[HY000] [1045] Access denied for user 'name'@'address' (using password: YES) in lock_may_be_available() (line 167 of /var/www/vhosts/websitename/httpdocs/opigno24/includes/lock.inc). Since i am really new to servers and Opigno itself, i contacted my hosting company in case they could help somehow. They told me everything seemed to be fine (passwords, myphpadmin etc).I guess there is a problem with the passwords but I have no idea on how to deal with it. Could you please help? Thank you

James Aparicio

Mon, 10/01/2018 - 12:58

Hi,

Seems to me like your settings.php sites/default/ does not have the correct settings for the db.

Did you replace the '[email protected]' in the message? that is the error. The server is trying to login to mysql with username 'name' to the server 'address' but cannot.

Either the db server address is incorrect, or the username is incorrect, or the password is incorrect, or your server is blocked from comunicating with the 'address' server. One of those 4.

Best regards

gavriela

Mon, 10/01/2018 - 16:09

Reply

Hi, Thanks for the reply. Yes, I replaced the name and the address just for the post. I checked the settings.php file and the username and password seem to be fine. I had the opigno backup along with the database and i uploaded the backup on the new server, but since I am new to all these, i do not know where to add the database (where in the server) and what to do next in order to get a new opigno platform password. I tried to find out where to add the database but I can only find instructions for creating a new one. I would appreciate it if someone could enlighten me.

James Aparicio

Tue, 10/02/2018 - 11:01

Hi gavriela,

There is nothing specific to Opigno in that regard.

How to import/export databases:

https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb

Best regards