Skip to main content

Installing MYSQL Instance on Mac

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


Comments

Popular posts from this blog

GIT/GITHUB

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...

Installing MYSQL Test Environment on Mac using XAMPP package

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...

Tableau

Tableau Command Line:     Check the status of Tableau service:           tabadmin status --v       Start/stop/restart Tableau service     tabadmin stop     tabadmin start     tabadmin restart       Saving configuration changes:           tabadmin config Tableau Configuration:     Update Logo:           tabadmin customize sign_in_logo "<png_image_path>"      tabadmin customize header_logo "<png_image_path>"     Configure Tableau Desktop Reporting      Tableau Upgrade:      1. Backup:           tabadmin backup <backupfilename> -d            -d will ...