MySQL Workbench is available on a number of operating systems and platforms. For information about those platforms that are officially supported, see http://www.mysql.com/support/supportedplatforms/workbench.html on the MySQL Web site.
General requirements and considerations that apply to all operating systems.
MySQL server: Although it is not required, MySQL Workbench is designed to have either a remote or local MySQL server connection. For additional information about connecting to a MySQL server, see Chapter 5, MySQL Connections. For additional information about installing a MySQL server, see Installing and Upgrading MySQL.
Data modeling does not require a MySQL server connection.
Simultaneous client connections: Opening a MySQL connection from the MySQL Workbench home page opens a new connection tab in MySQL Workbench for that connection. Each of these tabs requires two MySQL connections to perform basic tasks, such schema discovery and SQL execution. Additionally, performing management related tasks, such as Server Status, requires two additional MySQL connections. Essentially, this means that each MySQL connection tab in MySQL Workbench requires four available connections to MySQL. For additional information about "Too many connection" related errors, see Too many connections.
This connection requirement doubles with each connection tab opened in MySQL Workbench, even if the two connection tabs point to the same MySQL server. SQL editor tabs share their connections, so having multiple SQL editor and SQL results tabs does not affect the number of required connections.
On startup, the application checks the OpenGL version and chooses between software and hardware rendering. To determine which rendering method is being used, open the Help menu and choose the System Info item.
The requirements for Linux are embedded within their respective packages. Use the platform specific tool (for example, yum or apt) to install the package and their dependencies.
The "Save password in keychain" functionality requires
gnome-keyring to store the passwords. Note
that on KDE systems, the
daemon is not started by default.
For Linux and OS X, the MySQL server administration features require sudo privileges to execute several commands. The sudo user must be capable of executing the following system commands:
/usr/bin/sudo /usr/bin/nohup /usr/bin/uptime /usr/bin/which /usr/bin/stat /bin/bash /bin/mkdir /bin/rm /bin/rmdir /bin/dd /bin/cp /bin/ls
Additionally, the sudo user must keep the
HOME environment variable when executing
system commands, which means adding the following to
For MySQL Workbench to execute MySQL Enterprise Backup commands, the sudo user must also be able to execute the MySQL Enterprise Backup binary.