Brian Leonard's Blog

OpenSolaris 2008.05: Installing MySQL 5

Looking at the MySQL web site, the instructions for Installing MySQL Community Server seem more complicated then they need to be. Maybe that's because there are no instructions for OpenSolaris (yet - I hope). Here are the easy steps that got me up and running.

Install MySQL

• Open the Package Manager: System > Administration > Package Manager (give it a couple of seconds to load the package information):
  
  
  
  
• Enter mysql5 in the Search text box .The list will filter as you type.
  
  
  
  
• Select the check box for SUNWmysql5 and click the Install/Update button in the toolbar;
  
  
  
  
• Wait while package dependencies are checked and then click Next on the Install / Update Confirmation dialog:
  
  
  
  
• Wait while the packages are downloaded and installed:
  
  
  
  
• After which, the Package Manager will show MySQL as installed:
  
  

Start the MySQL Service

• Open System > Administration > Services and scroll down to MySQL RDBMS in the list:
  
  
  
  
• Click the check box to enable the MySQL RDBMS:
  
  
  

Verify the Installation

Note, the MySQL documentation's Installation Layouts page does not cover OpenSolaris, but you'll find the binaries in /usr/mysql/bin and the databases in /var/mysql/data.

• Open a terminal and start the MySQL client:
  
  bleonard@opensolaris:~$ /usr/mysql/bin/mysql -u root
  Welcome to the MySQL monitor. Commands end with ; or \g.
  Your MySQL connection id is 4
  Server version: 5.0.45 Source distribution

  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

  mysql> show databases;
  +--------------------+
  | Database |
  +--------------------+
  | information_schema |
  | mysql |
  | test |
  +--------------------+
  3 rows in set (0.00 sec)
  
  

• If you have NetBeans 6.1 installed it will also show you your MySQL databases in the services tab:
  
  

  
  

Comments

• There is no mysql from the service settings list after installing mysql5 using the package manager. I followed the way how you did it.

  Posted by: khawjg on June 24, 2008 at 11:41 PM

• Interesting. I should have mentioned this in the entry, but you can also start the service from the command line using the following:

  svcadm enable mysql

  Does that work for you?

  Posted by: bleonard on June 25, 2008 at 05:39 AM

• I did a restart of the workstation this morning and the service settings did list the MySQL RDBMS... Thanks Brian!

  Posted by: khawjg on June 25, 2008 at 08:50 PM

• Brian,
  With OpenSolaris 2008.05 you gotta restart the Virtual Image after installing MySQL - only then does it show up in the list of Services. Maybe you should add this step to your instructions.

  Hemant
  hemant at sun dot com

  Posted by: hemant_bedekar on August 29, 2008 at 03:58 PM

• A slightly different way to install MySQL, would be to install the webstack and the webstack gui

  $ pfexec pkg install amp westackui

  or if you are a developer and want developer tools with your amp stack

  pfexec pkg install amp-dev webstackui

  The cool thing with this is the nice GUI that you get in the "Application" -> Developer Tools"

  Fisrt you get a nice tool initialize the stack, and wen that is do there is set of admin tools for the Webstack, nice :)

  And to Hermant's comment on the restart, the issue is that the SMF manifest hasn't been imported to SMF, yiou can do as follows:

  $ pfexec svccfg import /var/svc/manifest/application/database/mysql.xml

  to verify it's OK

  $ svcs -xv mysql

  Cheers,
  Peter

  Posted by: peterkarlsson on September 21, 2008 at 09:40 PM

• Yup, I blogged about the Sun Web Stack here:

  http://blogs.sun.com/observatory/entry/sun_web_stack

  And thanks for the tip on importing the SMF manifest.

  /Brian

  Posted by: bleonard on September 22, 2008 at 07:43 AM

This work is licensed under a Creative Commons License.