Hello community

I recently installed Solaris 10 on a sparc server. I have download and installed so far apache 2.2.22 and phpmyadmin 3.5.1 . Mysql seems to be running on the server . Can someone point me where the configurations are located? Any tips or links that you can share to properly configure the mysql on this production server?

svcs -a | grep mysql
online          9:58:48 svc:/network/cswmysql5:default
pkginfo -l CSWmysql5
   PKGINST:  CSWmysql5
      NAME:  mysql5 - Multithreaded SQL database
  CATEGORY:  application
      ARCH:  sparc
   VERSION:  5.5.30,REV=2013.02.10
   BASEDIR:  /
    VENDOR:  http://www.mysql.com/ packaged for CSW by Maciej Blizinski
    PSTAMP:  [email protected]
  INSTDATE:  Apr 10 2013 15:47
   HOTLINE:  http://www.opencsw.org/bugtrack/
     EMAIL:  [email protected]
    STATUS:  completely installed
     FILES:      233 installed pathnames
                   7 shared pathnames
                  44 directories
                  84 executables
              522354 blocks used (approx)

asked 11 Apr '13, 17:07

joepr's gravatar image

joepr
1445
accept rate: 0%


Configuration location has been discussed in this question: "Where is my.cnf in CSWmysql5?". As a general rule, configuration of all programs packaged by OpenCSW is stored in /etc/opt/csw. There's also a corresponding section in the manual: Configuring Services.

permanent link
This answer is marked "community wiki".

answered 11 Apr '13, 17:28

automaciej's gravatar image

automaciej ♦♦
93273037
accept rate: 55%

Thanks for the links!!

permanent link

answered 11 Apr '13, 19:39

joepr's gravatar image

joepr
1445
accept rate: 0%

Hello

I have the mysql running however I still can't find the my.cnf file

I read that OpenCSW provides an example my.cnf file which can be found at: /opt/csw/mysql5/my.cnf Edit this file according to your needs and copy it to one of the above given locations

However I don't have a mysql5 folder on that location /opt/csw

Running this

# mysql --verbose --help

Shows

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /etc/opt/csw/my.cnf ~/.my.cnf

Thanks!

permanent link

answered 11 Apr '13, 21:06

joepr's gravatar image

joepr
1445
accept rate: 0%

The my.cnf file doesn't exist after the installation. You need to create it from scratch. It's not necessary for MySQL to run, you only need to create it if you need to modify anything.

(12 Apr '13, 00:25) automaciej ♦♦

One more thing: the /opt/csw/mysql5 directory is not used any more.

(12 Apr '13, 00:27) automaciej ♦♦

Thanks its working without any issues.

permanent link

answered 16 Apr '13, 17:50

joepr's gravatar image

joepr
1445
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×4

question asked: 11 Apr '13, 17:07

question was seen: 44,914 times

last updated: 02 Feb '16, 14:18

powered by OSQA