I have a MySQL database running on Amazon EC2 and have configured MySQL Workbench to connect to it. I can get into the Workbench Admin screen, but the problem I am facing is the 'Startup/Shutdown' is disabled from Workbench. It displays the following message:
The Options File screen is also disabled:
I was able to fix the issue. Basically I connected the admin GUI to mysqld using root user id. The reason seems to be the admin GUI tried to modify the /etc/my.cnf file which only root has the priviledge. Ofcourse you can create another user id with similar priviledge as root and try it
have you set up remote access for the remote administration?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With