MySQL Database

The MySQL database is available as an IPS package. For information on using MySQL, see MySQL 5.5 Reference Manual

How to install the MySQL IPS Package

1. Type the following command:

   $ pkg install database/mysql-55

   After the installation is complete, you must start the database.

2. Start the database:

   $ svcadm enable mysql

3. Type mysql in a terminal window to access the mysql> prompt.

   For example:

   mysql> show databases;
   Database
   information_schema 
   mysql 
   test
   3 rows in set (0.01 sec)
   
   mysql> quit;
   Bye