Setting Up the Application Development Environment in Oracle^® Solaris 11

MySQL Database

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

How to install the MySQL IPS Package

1. Type the following command:

   $ pkg install database/mysql-56

   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

   For more information about tuning ZFS for database, see Tuning ZFS for Database Products in Oracle Solaris 11.3 Tunable Parameters Reference Manual.