Hints, Tips and Installation

Back to -Tutorials -Sapphire (Ruby In Steel) Tutorials -Archives -Hints, Tips and Installation

Ruby On Rails and MySQL - faster with a Visual Studio shortcut

How to add MySQL as an External Tool

When starting a Ruby On Rails application, the first step is often the creation of a database. If you use MySQL you may be in the habit of navigating around on disk and running commands from system prompts in order to do this. In fact, you can create a MySQL database with ever leaving Visual Studio. All you need to do is add a MySQL Admin item to the Visual Studio Tools menu. This is how to do it...

- Select Tools, External Tools
- In the External Tools dialog, click Add
- Enter the details shown in the screenshot below in the Title, Command and Arguments fields (here I assume that there is no password and ‘root’ is your user name; if not change it as appropriate). Enter the path to the directory containing mysqladmin.exe in the Initial Directory field.
- Check off the ‘Prompt for arguments’ option.
- Click OK.

Note: If you have set a password for use with MySQL, you must add this to the argument list after -p; there must be no spaces between -p and the password. So, if your password were xyz, the complete list of arguments which you would need to supply would be:
-u root -pxyz

Now when you want to create a MySQL database, just select MySQL Admin from the Tools menu.

This pops up a dialog which displays your specified arguments: -u root

Edit this by entering create followed by the name of the database you wish to create (such as, say, ‘railsblog_development’).

This is what you should now see in the dialog:

Remember, if you are using a password (such as xyz), this needs to be supplied too (in the form: -pxyz).

When you click OK, the MySQL Admin tool will create the database.

If you prefer to enter database commands at the MySQL Commandline, you can add that to the Tools menu too. Here are the settings I use for this...

Bookmark and Share   Keywords:  ide  tutorial
© SapphireSteel Software 2014
piracetam buy mirtazepine online buy imatinib buy super kamagra buy arpizol sildisoft sildenafil citrate soft viread buy tizan 2mg natamet 5%/3ml buy armodafinil online buy generic bactrim d.s buy super p force buy zithromax 250mg buy armod 150mg buy nexium online buy nizonide sildenafil citrate jelly for sale order duprost buy amlodipine besylate hostacycline 500mg buy vidalista sildenafil citrate order omeprazole buy sildigra online buy generic aldactone buy mesterolone online amisulpride buy modalert online kamagra oral jelly sildenafil citrate oral jelly buy generic tadalafil avana buy generic viagra 100mg buy zyban online buy malegra fxt buy cutivate cream soranib sorafenib buy rifagut buy cernos depot buy generic tenofovir + emtricitabine buy diflucan 200mg buy finpecia online buy snovitra 20mg tadora for sale buy modafinil 200mg testosterone undecanoate 40mg buy doxycycline buy olanzapine buy generic careprost buy tadalafil super active buy anabrez order penegra buy dilantin prosteride buy valif avagra for sale buy terbicip online order generic femara nodict for sale rogaine shampoo for sale buy filagra super active 100mg buy oraxyl 100mg order isotretinion quetiapine buy sustanon ketasma 1mg tadalista for sale modvigil flutivate cream 0.05% buy entecavir online topirol for sale buy irovel online buy piracetam buy bortezomib premarin for sale rapamune 1mg testosterone undecanoate 40mg omnacortil 40mg buy flagyl online buy buspin 10mg buy garlic himalaya online buy generic pelosta buy fluka 150mg buy cipro online qutipin for sale buy tretinoin online buy fincar 5mg buy generic fertyl fluorouracil 5% quinine sulphate 300mg zocor nuvigil buy sildenafil citrate 100mg buy buproprion buy femalegra enalapril maleate vasotec viraday 300mg buy admenta online biduret amiloride diclofenac buy ciplactin online megalis for sale buy generic vega tadasoft for sale prostaglandin 3ml order attentrol buy amlodac online revlimid 5mg buy flagyl online buy memantine buy generic generic imatinib caverta for sale amitryn for sale malegra dxt buy levitra online eriacta viagra buy testosterone gel online order lithosun sr buy tadacip buy forzest baclof for sale silagra viagra buy generic imatib order sildigra xl plus rizact order urimax buy calaptin ranitidine zantac levetiracetam buy erlotinib online fertyl super for sale generic nuvigil armodafinil buy generic lioresal rapacan sirolimus buy pletoz 100mg buy generic gefitinib online buy malegra 100mg calutide for sale buy auvitra 20mg buy cabergoline buy poxet online xtane generic ampicillin buy melanocyl floricot buy avanafil orlistat xenical zhewitra vardenafil sildenafil citrate 100mg buy aurogra online buy tadarise pro 20mg buy vardenafil naltroxene buy arcalion sulbutiamine order acamprol apcalis jelly tadalafil jelly buy tadalafil online buy tadaga buy generic lasix order atorvastatin sildenafil citrate malegra professional for sale rasalect 1mg