OpenSolaris

Printable Version Enter a New Search
Bug ID 6636848
Synopsis Create mysql user on Solaris install
State 10-Fix Delivered (Fix available in build)
Category:Subcategory database:mysql
Keywords WebRTI:320884 | opensolaris
Responsible Engineer Sunanda Menon
Reported Against snv_01 , snv_78
Duplicate Of
Introduced In
Commit to Fix snv_84
Fixed In snv_84
Release Fixed solaris_nevada(snv_84)
Related Bugs 6438076 , 6504176 , 6634349 , 6636179 , 6638783 , 6639725 , 6648757 , 6658045 , 6669832 , 6777150 , 6777151
Submit Date 3-December-2007
Last Update Date 27-February-2008
Description
Category
   utility
Sub-Category
   ruby
Description
   Right now it is a lot of work to get going with MySQL on Solaris.  When you download XAMPP for Ubuntu, it's all set up automatically, and MySQL is running and ready to go.  Not so with Solaris.  As of build 78 (after installing CoolStack, which as I understand is being integrated into Solaris as of build 79) you have to do the following:
- Create a mysql user
- Call mysql_installdb
- Start up the mysql daemon using the command-line svc utilities
I ended up in a sorry state when I tried to do this, because I didn't have the mysql user, so I called mysql_installdb as another user, and then the daemon wouldn't start up because it didn't have permissions to the files.
Perhaps this is being fixed as part of the webstack work, but to me the best thing would be that all I have to do is choose a menu choice from the start menu to start the MySQL daemon, and I'm done.
Frequency
   Always
Regression
   No
Steps to Reproduce
   Install Solaris and try to get MySQL started
Expected Result
   It should Just Work out of the box
Actual Result
   It doesn't Just Work out of the box
Error Message(s)
   
Test Case
   
Workaround
   
Submitter wants to work on bug
   No
Additional configuration information
Since we haven't yet figured out how a user should be added to sfwn gate and since the creation of user is very critical for a good user experience for MySQL, I suggest that we create mysql user the way Postgres has created posgres user (on ON workspace)....let me know if anyone disagrees ....
Changing the synopsis for this Bug as create initial DB will be taken care of by the MySQL SMF facility .Refer to CR 6640449 .
Work Around
N/A
Comments
N/A