Re: MySQL Workbench: Remote Server Administration using SSH

[Thomas Hatton]

"You don't need root to admin log in, only for executing admin commands like starting mysqld or stopping. So you can use an ordinary account for ssh, and use sudo to execute the actual commands."

True enough for a regular ssh command-line shell, but that's not the point. I was saying you can't set up the MySQL Workbench (GUI) for RemoteAdmin with a "regular" account because of the root issue.

If you try to set up remote admin in Workbench with a non-root account, it fails trying to do any admin process, because it's not a root account

e.g. set it up with a non-root account that can ssh in, and then when it tests (again, it tells you the account needs to have root powers, so this is no surprise) you get the error message:
"What check_admin_commands
Operation failed: /etc/init.d/mysql start is invalid"

And you can't use root for the ssh login for Workbench because root is not allowed to ssh in, as described earlier.

So, can't use MySQL Workbench to remote admin, at least not securely. Which is a shame, since it would be a great tool to have to monitor/control.



Edited 1 time(s). Last edit at 03/25/2011 07:19PM by Edwin DeSouza.