MohansKB

Download the MYSQL from http://dev.mysql.com/downloads/mysql/ Choose Mac OS X 10.10 (x86, 64-bit), DMG Archive (latest) Install the software, easy steps, just Next Next Finish Go to System Preferences and find MySQL. Open it and Start MYSQL Server. If the XAMPP instance is already running, it must be stopped before starting the above one And then the mysql install path should be added to the PATH variable. : vi ~/.bash_profile :export PATH=$PATH:/usr/local/mysql/bin

SID - SQL Interactive Demonstrator is a web based MYSQL client. Written in PHP. Hence it requires a web server that supports PHP to use it with a standard browser. There is an excellent cross platform package called XAMPP that includes, MYSQL, The Apache Webserver, PHP and a bunch of other things. Steps: 1. Installing XAMPP 2. Setting up MYSQL users 3. Installing SID 1 - Installing XAMPP Make sure that no other web server is running. Also Skype runs (I think this applies to windows only b/c my Skype is still running on my Mac) on the same port as the web server and it will prevent Apache from running. So it turn it off before installing XAMPP. - Download and install XAMPP for OS X from apachefriends.org (or from here http://bw.org/ldcsql/) - Launch the Finder window in Mac. Go to Applications > XAMPP and drag manager-osx application to the task bar - Launch the manager-osx. Provide the administrator password and start the My SQL database from the Manage Servers...

GIT for source code management. To see where is GIT installed: $ which git To get the version of GIT: $ git --version Configuration: Three places where GIT stores configuration information System -     /etc/gitconfig User -       ~/.gitconfig Project -   my_project/.git/config Update configuration: For System:   $ git config  --system For User:   $ git config --global For project: $ git config $ git config --global user.name "Mohan Donthabhaktuni" $ git config --global user.email "mohand.bi@outlook.com" To view the configuration details: $ git config user.name   (shows the user name) To view all the configuration details: $ git config --list These configuration details get stored in the .gitconfig file under the users home directory Setup Auto-completion: $ ~ mohand$ cd ~ $ ~ mohand$ curl -OL https://githum.com/git/git/raw/master/contrib/completion/git-completion.bash $ mv ~/gi...