Skip navigation links

MySQL Forums :: MySQL Workbench :: Re: MySQL Workbench: Remote Server Administration using SSH


Advanced Search

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


Subject Views Written By Posted
Re: MySQL Workbench: Remote Server Administration using SSH 6710 Mike Lischke 01/17/2011 02:10AM
Re: MySQL Workbench: Remote Server Administration using SSH 1805 Thomas Hatton 03/24/2011 01:49PM
Re: MySQL Workbench: Remote Server Administration using SSH 900 Alfredo Kengi Kojima 03/24/2011 08:24PM
Re: MySQL Workbench: Remote Server Administration using SSH 1529 Thomas Hatton 03/25/2011 10:48AM
Re: MySQL Workbench: Remote Server Administration using SSH 903 Alfredo Kengi Kojima 03/25/2011 09:27PM
Re: MySQL Workbench: Remote Server Administration using SSH 1408 Thomas Hatton 03/25/2011 11:49PM


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.