Using MySQL with 3rdRail

MySQL is the default database for 3rdRail. During 3rdRail installation, you have the option of installing MySQL.

Here are some commonly used MySQL tasks:

  1. Assuming that MySQL installed correctly, you have at least one user called root with a password you selected at install time. To start the MySQL client at the command line:
    mysql -u root -p
    When prompted, enter your password. This starts the interactive client.
  2. To get help:
    mysql> help;
  3. To list the current databases:
    mysql> show databases;
  4. To create a new database:
    mysql> create database {database_name};
Related Concepts The MySQL Database Website
Corporate LogoCodeGear brand and product names are service marks, trademarks or registered trademarks of Borland Software Corporation in the United States and other countries.