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.