Linux - MySQL [Installl, Launching]설치_On Ubuntu

Linux - MySQL [Install, Launching, Uninstall]설치, 런칭, 제거

Installing DEB packages

On Ubuntu, and other systems that use the Debian package scheme, you can either download and install .deb packages or use the APT package manager.
우분투, 데비안 패키지 방식을 사용하는 다른 시스템에서는 다운로드 뎁 패키지를 설치하거나 APT 패키지 관리자를 사용 할 수 있습니다.

Important

Your Linux distribution includes MySQL Workbench builds where "apt-get install mysql-workbench" will install their build of the MySQL Workbench package.
당신의 리눅스 배포판은 "apt-get install mysql-workbench"은 MySQL의 워크 벤치에 MySQL의 워크 벤치 패키지 자신의 빌드를 설치하는것을 포함합니다.
To use the official MySQL Workbench builds as provided by the MySQL Release team, you must install the official MySQL APT repository and choose the "mysql-workbench-community" package instead of "mysql-workbench".
MySQL의 릴리즈 팀에 의해 제공되는 공식 MySQL의 워크 벤치빌드를 사용하려면, 공식 MySQL의 APT 저장소를 설치하고 "mysql-workbench" 대신 "mysql-workbench-community" 패키지를 선택해야합니다.

For Example

First, install the MySQL APT repository as described in the MySQL APT Repository documentation.

MySQL의 APT 저장소 문서에 설명 된대로 MySQL의 APT 저장소를 설치합니다.

shell> sudo dpkg -i mysql-apt-config_0.5.3-1_all.deb
shell> sudo apt-get update

Next, install MySQL Workbench. You might have multiple Workbench packages available, so choose the "mysql-workbench-community" version.

다음으로, MySQL의 워크 벤치를 설치합니다. "mysql-workbench-community"버전을 선택하면 다중 워크 벤치 패키지를 사용할 수 있읍니다.

shell> sudo apt-get install mysql-workbench      // install
shell> mysql-workbench      // Using

** Message: Gnome keyring daemon seems to not be available. Stored passwords will be lost once quit = >How to fix this issue
A possible workaround was to add this code to the top of file /usr/bin/mysql-workbench

export GNOME_KEYRING_CONTROL=1

 Launching

After MySQL Workbench has been installed, it can be launched by selecting Applications, Programming, MySQL Workbench from the main menu.

MySQL Workbench can also be launched from the command line on Linux. Type the command:

shell> /usr/bin/mysql-workbench --help

This will display the available command-line options:

mysql-workbench [<options>] [<name of a model file or sql script>]

Options:
  --force-sw-render       Force Xlib rendering
  --force-opengl-render   Force OpenGL rendering
  --query [<connection>|<connection string>] 
                          Open a query tab and ask for connection if nothing is specified.
                          If named connection is specified it will be opened, else connection 
                          will be created based on the given connection string, which should 
                          be in form <user>@<host>:<port>
  --admin <instance>      Open a administration tab to the named instance
  --upgrade-mysql-dbs     Open a migration wizard tab
  --model <model file>    Open the given EER model file
  --script <sql file>     Open the given SQL file in an connection, best in conjunction with 
                          a query parameter
  --run-script <file>     Execute Python code from a file
  --run <code>            Execute the given Python code
  --run-python <code>     Execute the given Python code
  --migration             Open the Migration Wizard tab
  --quit-when-done        Quit Workbench when the script is done
  --log-to-stderr         Also log to stderr
  --help, -h              Show command line options and exit
  --log-level=<level>     Valid levels are: error, warning, info, debug1, debug2, debug3
  --verbose, -v           Enable diagnostics output
  --version               Show Workbench version number and exit
  --open <file>           Open the given file at startup (deprecated, use script, model etc.)

 Uninstalling

The procedure for uninstalling MySQL Workbench on Linux depends on the package you are using.

Note

When using apt, the official package name at dev.mysql.com is mysql-workbench-community, whereas most Linux distributions use the name mysql-workbench. Adjust the following commands accordingly.

Uninstalling DEB packages

To uninstall a Debian package, use the following:

shell> sudo apt-get remove mysql-workbench-community

Or, alternatively:

shell> sudo dpkg -r mysql-workbench-community

This command does not remove the configuration files. If you wish to also remove the configuration files, use this command:

shell> sudo dpkg --purge mysql-workbench-community

Uninstalling RPM packages

Note

When using yum, the official package name at dev.mysql.com is mysql-workbench-community, whereas most Linux distributions use the name mysql-workbench. Adjust the following commands accordingly.

To uninstall an RPM package, use this command:

shell> sudo yum remove mysql-workbench-community

Or, alternatively:

shell> sudo rpm -e mysql-workbench-community

This command does not remove the configuration files.

What Is Not Removed

By default, the uninstallation process does not remove your MySQL Workbench configuration directory. This directory includes your MySQL connections, configuration settings, cache files, SQL snippets and history, logs, custom modules, and more. These files are stored under your user's .mysql/workbench/ directory.

Note

By default, the MySQL Workbench configuration directory is ~username/mysql/workbench/ where "~username" is the path to your user's home directory.

Also, the uninstallation process does not remove the .mysqlworkbench schema that MySQL Workbench creates when sharing SQL snippets across a MySQL connection. For additional information about shared snippets, see Section 8.1.5, “SQL Snippets tab”.

The original copy :참고 - dev.mysql.com