Databases

From StudentDevWiki

Jump to: navigation, search

myRPI-space offers both MySQL and postgreSQL databases for users. You are not limited to choose one type over the other, each database you create can run on different engines. That said, you total SQL database count (which has a maximum limit) is the sum of your MySQL databases + your postgreSQL databases.

As of 2008-03-01, the studentdev box is running:

  • MySQL - 5.0.45-community
  • postgreSQL - 8.1.11

Database GUI's

myRPI-space has system wide instances of phpMyAdmin and phpPgAdmin running to provide a web based route to interact with any database you've created. Both of these tools are listed in the Databases sections of your control panel, and are bound to your system login information (i.e you cannot connect to these tools using a database specific username).

These tools will allow you to interact with any database you've previously created, but will not allow you to add/remove entire databases (you can create/drop tables). To add/remove an entire database, use the appropriate link in your control panel for the database engine you'd like, MySQL Databases or postgreSQL Databases. Similarly, the ability to create users and assign permissions is only available through the CPaenl interface, and not in php(My/Pg)Admin or via the command line.

Retrieved from "http://wiki.myrpi.org/Databases"
Personal tools