Databases: mySQL setup

This is the process for using mySQL with nimbits.

The default db user name and password is root / nimbits.

Please see the How to Configure Nimbits WIKI On how to set user names, passwords and connection urls. If you run our setup script setup.sh it will instal a local instance of mySQL on the localhost.

If you want to install mySQL on another machine, the mySQL.sh script is something we use to automate this. You can clone the repo and run it for easy setup. The, point the url in your config above for a two tier system.

Edit the file sudo vi /etc/mysql/my.cnf to meet your needs, such as data store location. To access this server from another machine, edit the line:

bind-address = 0.0.0.0

The above setting is the most open and least secure, so tune this to meet your needs.

For each nimbits instance you want to use this server, login to sql and run the following command to give it access:

GRANT ALL ON nimbits.* TO me@'1.2.3.4' IDENTIFIED BY 'password';

Where 1.2.3.4 is the is the ip of the nimbits machine and me/password is the sql user password you set in your connection parameters in the system configuration

Manual OSX Install

• Download mySQL Community Edition and install. It will most likely give you a temporary root password during the install which you should copy.

• Install mySQL Workbench, a free download from the same site.

• Start mySQL Server - on a mac, you can do this in the preferences or use the scripts in the mysql installation folder bin.

• Use mySQL Workbench to connect to your localhost and follow the prompts to reset the root password. This tutorial uses password as the password and we connect as root, but do consider a more secure production environment!