Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench unable to startup/shutdown from remote

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:

Workbench Remote Administration is disabled

The Options File screen is also disabled:

Workbench options screen disabled

like image 618
user1241438 Avatar asked Apr 19 '12 03:04

user1241438


2 Answers

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

like image 90
user1241438 Avatar answered Nov 14 '22 23:11

user1241438


have you set up remote access for the remote administration? WB remote admin settings

like image 41
borrel Avatar answered Nov 15 '22 00:11

borrel