ホーム > 開発環境 > mysql workbench

mysql workbench

2012 年 3 月 8 日 コメントをどうぞ コメント

開発環境としてxamppが入ってる(eclipse pleiades のパッケージ)。

このmysqlをeclipse上から参照とか(DBviewer)していたが、効率が悪い・・・。

もっと権限管理とか機能の多いものがほしいと思い「」(http://www-jp.mysql.com/products/workbench/)をインストールした。

ちなみにphpmyadminはあるが、webサーバを起動しないといけないのでローカルでは不便。

 

アカウント登録は必要だが無料

zip版とインストーラ版があったので、とりあえずzip版をダウンロードし解凍。

しかし上手く動かない・・・。create table とかでエラーが出る。英語なので読めない。

仕方なくインストーラでインストール。

あとはDB接続設定

mysql workbench
local環境なのでそのまま、default schemaは特に指定なしでOK。ユーザもフルコントロールのできるroot指定。

これで、スキーマの管理はここでできる。

 

次に、ユーザ管理とかいろいろ。

はじめ、「New Server Instance」から登録しようとしたが、うまくいかない。

window management
window management というところで何も出ず先に進めない。

mysql単体のインストーラでインストールした場合は出るのかもしれないが、今回使用するのはxamppのものなので設定が別に必要らしい。

で、「Manage Server Instance」から登録

mysql workbench admini
System Profileタブの設定をする。

system type:  windows

Installation type: Custom

Configuration File: mysqlの設定ファイル(mysqlのbinの中にある.iniか.conf)

これで設定OK。ユーザ管理とかできるようになった。

windows以外だと起動・停止コマンドも設定できるようだが、windowsは指定できなかった。

いろいろ機能はあるみたいだが、今使ってみたいのはユーザ管理くらいで英語も読めないので解析はまた今度。

とりあえずこれで少し便利になった。

関連する記事

Now we’re talking! Who better than David Fincher and Aaron Sorkin to tell us wholesale nfl jerseys the story of another arrogant, somewhat misogynistic blowhard whose products we use every day? And they even had Christian Bale on board as Jobs . for like 15 minutes, before it all fell apart.”I’m sorry, but my MySpace Tom dream project just opened up.”Remember, every opportunity you miss is one you opponent might claim.Rule 4 Set Aside Personal Biases You might be fiercely loyal to a particular team or certain players. That said, fantasy football is not personal, it’s a game. Don’t get in the habit of loading your team with players you love if the facts don’t support your action. You can see this particular gear right here rubbing just a little bit, and this barrel adjuster is for fine tuning those gears. You http://www.cheapnfljerseysshop.com just keep playing with that barrel adjuster until you get those gears functioning perfect. And that is how you adjust a derailleur.. And there aren many in NFL Jerseys Cheap this country. We have a very good record in this country. you intrigued by the idea of corruption? asked This Morning co host Charlie Rose.it sales come on, Charlie. This is a bestseller, it a thriller, it suspense. You got to have corruption, you got to have somebody taking money out of some dead bodies. Anyways, you probably better off using cheat engine, it has a builting tutorial and works very similar to this. the thing http://www.cheapjerseys11.com you explaining is a hex editor, woah, exactly what this isdude, I DO know what I talking about. then you should also know that if it only changes RAM, it would only change variables the RAM Wholesale China Jerseys changes, which means it would only work for the time you booted up the game. The victim didn’t have a view of the action; the perpetrator was so intent on what he was doing that he didn’t stop to look. “The play was Replica Oakley Sunglasses a blur,” said Taylor. “I had taken the outside. I was thinking: keep him in the pocket and squeeze him. Then I broke free.” Why he broke free he couldn’t say, Cheap Jerseys China as he didn’t actually notice who was trying to block him. On Saturday, in the team of four duplicate event, the Azad Hind team comprising B. Majumdar, Sandeep Dutta, Kastub Bindre, Aniket Sanghvi, Kaustub Nandi and S. Basak was leading with 118 VPs at the end of the first set of round robin league. Top Flight team comprising S. Vijayaraghavan, Sapan Desai, B. Baroi, A. Gayen, S. Sowmik and S. Tiwari was second with 85 VPs. Prasad, Bala Vamshi, Angad Singh and T. Gaurav was third with 59 VPs.Some of the difficulties of getting a program off the groundUnlike High School where more than half of the players have already played lacrosse, the youth teams, especially new programs have almost all new players. New players means programs must recruit from a pool of boys, girls and their parents that know nothing about lacrosse. That’s 10 to 15 families that you must convince that lacrosse is a sport their son or daughter should play.

関連する記事

カテゴリー: 開発環境 タグ: ,
  1. コメントはまだありません。
  1. トラックバックはまだありません。