A Ruby on Rails MySQL database initial setup

December 1, 2006

So in the past two months I have migrated between three servers. Including my development machine, I have done the same inital setups to get an application going four times in the past 6 months. I always look at bookmarked pages in the MySQL mannual to set it all up. So here I am again doing the setup and documenting, the simple, but often used commands to setup a new application database.

mysql> create database money_maker;
mysql> GRANT ALL PRIVILEGES ON money_maker.* TO 'bam'@'localhost' IDENTIFIED BY 'passw0rd'; 

That’s it. Move on.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: