Live Helper Chat support forum.. Old google groups forum can be found here

You are not logged in.

Announcement

#1 2018-11-09 00:45:34

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.

Offline

#2 2018-11-09 02:12:28

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.

Offline

#3 2018-11-09 16:10:29

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 3,116
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 smile

Have a great end of the week!


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]

Offline

Board footer