I have an Apache2 ubuntu AWS EC2 server which I just installed mysql on.
However I do not seem to be able to connect remotely to the database via mysql workbench.
I am wondering what step did I miss to be able to remotely access the mysql via mysql workbench
I am getting the below error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
OK so now I am able to connect to the ssh via ssh but still not able to connect via my mysql workbench
In ssh once connected to mysql I ran the below command which is then the credentials I use in my mysql workbench . Of course i have a real password instead of the ***** for the password
CREATE USER 'mysqladmin'@'localhost' IDENTIFIED BY '******';
GRANT ALL PRIVILEGES ON . TO 'mysqladmin'@'localhost' WITH GRANT OPTION;