#StackBounty: #mysql AWS ECS SSH Mysql remote access

Bounty: 50

I have a aws ec2 ubuntu, apache server setup with mysql. My issue is I am able to connect to mysql via the command line. However if I try to use like Mysql Workbench or a program like that to connect to the database I am able to login to the server and see all databases and tables but not able to run any select queries or do anything with the database other then see it.

I tried doing a

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345';

However it does not seem to fix the issue?
I get an error that says

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I confirmed I have the bind-address set to 0.0.0.0 . When I look at the users table on the command line I do see a row for user root with host % listed.


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.