Ubuntu 10.04でのSSH tunnelの不具合が解消されたMySQL Workbench 5.2.17

MySQL :: Download MySQL Workbench
http://dev.mysql.com/downloads/workbench/5.2.html

Ubuntu→SSH踏み台Server→MySQL Server
と違うnetwork segmentのMySQL Serverに繋ぎたい時、Ubuntu 9.10 + Workbench 5.2.16はokだったがUbuntu 10.04 + Workbench 5.2.16はSSH tunnelを認識しなかったが、Ubuntu 10.04 + Workbench 5.2.17ではok。

2/18 MySQL 5.1.44, Connector/J 5.1.12

MySQL 5.1.44
http://dev.mysql.com/downloads/mysql/5.1.html
Connector/J 5.1.12
http://dev.mysql.com/downloads/connector/j/5.1.html

2/1 MariaDB 5.1.42 released

Manual:MariaDB 5.1.42 Release Notes - Askmonty.org
http://askmonty.org/wiki/index.php/Manual:MariaDB_5.1.42_Release_Notes
http://askmonty.org/wiki/index.php/MariaDB:Download

Ubuntu 8.04～10.04まで.debがありまする。



MariaDBの公開、迫る | エンタープライズ | マイコミジャーナル
http://journal.mycom.co.jp/news/2010/01/19/036/
MariaDB 5.1.42登場、同バージョンのMySQLに対応 | エンタープライズ | マイコミジャーナル
http://journal.mycom.co.jp/news/2010/02/02/054/

Ubuntu 10.04のmysql gui toolsはopenSUSE

https://launchpad.net/ubuntu/lucid/+package/mysql-query-browser

Published versions
* mysql-query-browser 5.0r12-1ubuntu2 in amd64 (Release)
* mysql-query-browser 5.0r14+openSUSE-2 in amd64 (Release)
* mysql-query-browser 5.0r12-1ubuntu2 in armel (Release)
* mysql-query-browser 5.0r14+openSUSE-2 in armel (Release)
* mysql-query-browser 5.0r12-1ubuntu2 in i386 (Release)
* mysql-query-browser 5.0r14+openSUSE-2 in i386 (Release)
* mysql-query-browser 5.0r12-1ubuntu2 in ia64 (Release)
* mysql-query-browser 5.0r14+openSUSE-2 in ia64 (Release)
* mysql-query-browser 5.0r12-1ubuntu2 in powerpc (Release)
* mysql-query-browser 5.0r14+openSUSE-2 in powerpc (Release)
* mysql-query-browser 5.0r12-1ubuntu2 in sparc (Release)
* mysql-query-browser 5.0r14+openSUSE-2 in sparc (Release)

これは酷い・・・

https://launchpad.net/ubuntu/lucid/+source/mysql-gui-tools/5.0r14+openSUSE-2

mysql-gui-tools (5.0r14+openSUSE-2) unstable; urgency=low

* debian/control:
+ Build depend on liblualib50-dev instead of liblua50-dev
+ move section to database
+ Add build depends on libgnomeprint2.2-dev

mysql-gui-tools (5.0r14+openSUSE-1) unstable; urgency=low

* New upstream release (closes: #548782, #527652 )
* Lots of fixes thanks to great people at OpenSUSE. They were brave
enough to wrestle this monster of a release into something that not
only compiles, buy actually works.
* Use git as the source tarball. Too many binary changes to make
this work with original upstream tarball and diffs.
* debian/control
+ Add Vcs-* info to debian/control
+ Use libgtkgtml3.14 instead of deprecated 3.8 (closes: #542015)
-- Ilya Barygin

まだ依存関係はぐちゃぐちゃ

1/20 MySQL connector/J 5.1.11, 1/21 Workbench 5.2.14

MySQL :: Download Connector/J
http://dev.mysql.com/downloads/connector/j/

MySQL :: Download MySQL Workbench
http://dev.mysql.com/downloads/workbench/5.2.html


Connector/Jのmvnへの登録
$ tar xf mysql-connector-java-5.1.11.tar.gz
$ cd mysql-connector-java-5.1.11
$ mvn install:install-file -Dfile=mysql-connector-java-5.1.11-bin.jar -DgroupId=mysql -DartifactId=mysql-connector-java -Dversion=5.1.11 -Dpackaging=jar
$ cd src
$ jar -cf src.jar com org
$ mvn install:install-file -Dfile=src.jar -DgroupId=mysql -DartifactId=mysql-connector-java -Dversion=5.1.11 -Dclassifier=sources -Dpackaging=jar

これで
~/.m2/repository/mysql/mysql-connector-java/5.1.11
に
mysql-connector-java-5.1.11.jar
mysql-connector-java-5.1.11.pom
mysql-connector-java-5.1.11-sources.jar
が入る


Workbenchのinstall
$ sudo dpkg -i mysql-workbench-oss-5.2.14-1ubu910-i386.deb
10.04だと標準的なMySQL Serverのpackageの他
$ sudo apt-get install libmysqlclient15off libzip1 python-paramiko
が必要かも。5.1をまれに起動する位で5.2ははじめてなのでよく分からないがsshがついた。


参考?
Manage SSH Tunnels with Gnome SSH Tunnel Manager | Ubuntu Geek
http://www.ubuntugeek.com/manage-ssh-tunnels-with-gnome-ssh-tunnel-manager.html

1/10 phpMyAdmin 3.2.5

http://sourceforge.net/projects/phpmyadmin/files/

Fedora 12 + MySQL 5.1

installするpkgはmysql-server

$ su -
$ /etc/init.d/mysqld start
$ mysqladmin -u root password 'new-password'
or
$ mysqladmin -u root -h fedora.home password 'new-password'
でちきんと設定されているか
$ mysql -u root -p
で実際にloginして確認する。

その他commandは
http://salvan.web.fc2.com/programming/mysql/mysql.cheatsheet.html
やMySQLのdocumentを参照。

MySQL 5.0は12/31でactive supportが終わりらしい

MySQL :: MySQL Lifecycle Policy
http://www.mysql.com/about/legal/lifecycle/#calendar

5.1も結構短いな・・・。