Announcement

najeeb

New member

Registered: 2018-11-09

Posts: 2

Installed LHC on EC2 AWS

So, everything is going fine instead of the database connectivity.
I created a local mysql database;
grant a local user all the permission;
filled out the form at page 2 with correct username, password, 127.0.0.1 localhost IP and default mysql port, which I verified from mysql.

Error it is returning is as under;
Cannot log in with provided logins. Returned message:
SQLSTATE[HY000] [1045] Access denied for user 'username'***'localhost' (using password: YES)

Although I am trying to solve the problem but any help or previous experience sharing might help.

najeeb

New member

Registered: 2018-11-09

Posts: 2

Re: Installed LHC on EC2 AWS

I found out the a thread at askubuntu helpful, it solved the problem

cann't insert links so copying the post.

First, connect in sudo mysql

sudo mysql -u root
Check your accounts present in your db

SELECT User,Host FROM mysql.user;
+------------------+-----------+
| User             | Host      |
+------------------+-----------+
| admin            | localhost |
| debian-sys-maint | localhost |
| magento_user     | localhost |
| mysql.sys        | localhost |
| root             | localhost |
Delete current *** account

mysql> DROP USER 'root'***'localhost';
Query OK, 0 rows affected (0,00 sec)
Recreate your user

mysql> CREATE USER 'root'***'%' IDENTIFIED BY '';
Query OK, 0 rows affected (0,00 sec)
Give permissions to your user (don't forget to flush privileges)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'***'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0,00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0,01 sec)
Exit MySQL and try to reconnect without sudo.

PeopleInside

Administrator

From: Italy

Registered: 2014-04-10

Posts: 4,046

Website

Re: Installed LHC on EC2 AWS

Hi najeeb , welcome on the live helper chat forum and thank you for your first two post!
Sorry for the limited right to post links, we need avoid spam on the forum that sometimes is really aggressive.

I'm happy to read you found a solution also because usually i cannot help with localhost installations.
Hope you enjoy

Have a great end of the week!

---

PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]