CommunityData:MySQL

If you need to use a MySQL database for research, you'll need to create a database on Kibo. Kibo has MySQL already installed. You'll also need to create a user with access to that database. Doing these two steps will require access to MySQL using the MySQL "root" user.

MySQL credentials on Kibo
First, you'll need an account on Kibo. CommunityData:Kibo has details on how to do this but it will require a NU NetID and a bunch of other steps. Alas. Once you have this account, you'll need to use the following steps:


 * To find username and password credentials to access MySQL, you'll need to get a shell as root. Type  to get a root shell first.
 * Change to the  directory by typing.
 * You'll find the file labeled  that contains the username and password to access MySQL on kibo.

Making a new MySQL database and user
Before you start, you'll need to decide on a name for your database, a name for your user , and a password. The password should be secure. I generate mine with a shell command like  or some other secure password generator. I typically make the database name and username the same.

Run the following shell commands (replacing  with the name of the database you want to create):



Once you have done that and entered the password, you will put into the MySQL shell. Youll need to run these two commands (replacing things as appropriate):



Now exit the MySQL shell with Ctrl-D or similar. You should be good to go! You'll need to enter your your username and password into any scripts you write that will be reading from and/or writing from the database.

It is also possible to create users with only read access to the database, and similar. Details on how to do that are available in MySQL documentation on the web.