Ask Ubuntu is a question and answer site for Ubuntu users and developers. It only takes a minute to sign up.
Sign up to join this community
In terminal I run next commands:
sudo apt-get install mysql-server
sudo apt-get install mysql-admin
sudo apt-get install mysql-query-browser
With first command - all ok.
But for latest two commands: Unable to locate package.
My question: Why I can't install admin and query browser?
MySQL has officially declared EOL (End of Life) for Query Browser. You can check it on http://dev.mysql.com/doc/query-browser/en/
MySQL Workbench is its replacement and its now available in Ubuntu 12.04 repositories:
sudo apt-get install mysql-workbench
All features are supported by Workbench.
Bummer: https://bugs.launchpad.net/ubuntu/+source/mysql-gui-tools/+bug/896463
There is mysql-workbench ... https://launchpad.net/~olivier-berten/+archive/misc
aptitude show mysql-query-browser
aptitude show mysql-workbench
aptitude show tora
Well, the workstation running 12.04 on which I found mysql-query-browser, was updated from 10.04 to 12.04 - it was retained across the upgrade - so that is a different situation than a non-upgrade clean install of 12.04 .
Also, I have found a PPA:
http://www.tolaris.com/2012/05/16/added-to-precise-repository-handbrake-mysql-query-browser/
I found precise instructions and the packages that worked for me without any hassle here. Hope this helps people.
PS: Do not forget to reload the repositories.
After about 2 years since I stopped using MySQL Admin and MySQL Query Browser because for me they were the best and I was force to use MySQL Workbench, I am posting this answer here to let others that used to use Admin and Query Browser because of their ease of use (Which was removed in Workbench) to know that the current MySQL Workbench has gotten to a point where, it is not only as great as Admin / Query Browser, but also incorporate the best of Workbench and other similar MySQL tools.
It is currently awesome. Here are some images of how it now looks (Last timed I used workbench as 2 years ago).
So right now, MySQL Workbench (This would be the first time I say this) offers everything MySQL Admin and MySQL Query Browser offered several years ago, plus a lot of new things to play with. Gave me a reason to install it again.
If you think as many others that unfortunately mysql-workbench is not a good and a simple tool to do quick and fine things, you can install previous deleted tools directly from the repository manually. You just have to download and install the following .deb packages:
https://launchpad.net/ubuntu/precise/amd64/mysql-gui-tools-common/5.0r14+openSUSE-2.2ubuntu2 https://launchpad.net/ubuntu/precise/amd64/libmysqlclient16/5.1.58-1ubuntu5 launchpad.net/ubuntu/precise/amd64/mysql-query-browser/5.0r14+openSUSE-2.2ubuntu2 launchpad.net/ubuntu/precise/amd64/mysql-admin/5.0r14+openSUSE-2.2ubuntu2
Of course this is for amd64 architecture, for the i386 just change the link.
See http://www.tolaris.com/2012/05/16/added-to-precise-repository-handbrake-mysql-query-browser/
Summary: add the Tolaris "Precise" repository to /etc/apt/sources.list, GUI Tools should then be available to be installed.
Update: does not seem to work with Xenial, have not discovered a way to get the old GUI tools to work.
