MySQL Forums
Forum List  »  MySQL Workbench

Re: MySQL Workbench: Remote Server Administration using SSH
Posted by: Thomas Hatton
Date: March 25, 2011 10:48AM

"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.

Options: ReplyQuote

Written By
Re: MySQL Workbench: Remote Server Administration using SSH
March 25, 2011 10:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.