LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Other *NIX Forums > Solaris / OpenSolaris
User Name
Password
Solaris / OpenSolaris This forum is for the discussion of Solaris, OpenSolaris, OpenIndiana, and illumos.
General Sun, SunOS and Sparc related questions also go here. Any Solaris fork or distribution is welcome.

Notices


Reply
  Search this Thread
Old 01-11-2008, 11:49 AM   #1
bigearsbilly
Senior Member
 
Registered: Mar 2004
Location: england
Distribution: Mint, Armbian, NetBSD, Puppy, Raspbian
Posts: 3,515

Rep: Reputation: 239Reputation: 239Reputation: 239
installing mySQL on solaris 10 x86


any advice on this?


I download mysql5 ( CSWmysq ) from blastwave and can't seem to get the
server going.

i get this,
Code:
# svcs -x
svc:/network/cswmysql5:default (?)
 State: maintenance since Fri Jan 11 17:08:19 2008
Reason: Restarting too quickly.
   See: http://sun.com/msg/SMF-8000-L5
   See: /var/svc/log/network-cswmysql5:default.log
Impact: This service is not running.
log file says nothing, useful or the Sun message.
i tried various install_db (as root) and the db_test thig was ok.


I then noticed that solaris comes with it already, as SUNWmysql.

any advice?

should I remove the new one or run with it?


postgres was easy
 
Old 01-11-2008, 02:44 PM   #2
bigearsbilly
Senior Member
 
Registered: Mar 2004
Location: england
Distribution: Mint, Armbian, NetBSD, Puppy, Raspbian
Posts: 3,515

Original Poster
Rep: Reputation: 239Reputation: 239Reputation: 239
got it,
here

mysql_install_db --user=mysql
 
Old 01-11-2008, 11:55 PM   #3
UltraSoul
Member
 
Registered: Dec 2004
Location: Japan
Distribution: REDHAT9.0, Mandrake10.1
Posts: 404

Rep: Reputation: 31
Hi, bigearsbilly


1> ============= Taken from your post =================
See: /var/svc/log/network-cswmysql5:default.log
Impact: This service is not running.

==> So, what /var/svc/log/network-cswmysql5:default.log says,
tail -10 <svc_log> to show me even though you said it is not useful

2> As you said, mysql comes with solaris also, but no needs to remove these
mysql SUNW packages, I running another mysql5 on my soalris10 without any problem.

mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.33-standard-log Source distribution

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

mysql>


3> can you run the following command to see what SMF controlls your mysql service. I remember the default mysql for soalris10 is version4
and should be controller by /etc/rc3.d/S##mysql script. I am not sure where is your cswmysql5 from. Did you install mysql5 via blastwave?


# svcs -a | grep mysql


4> mysql_install_db --user=mysql is based on the mysql version on your Soalris OS, I am running sun coolstack as follows.

# /opt/coolstack/mysql_32bit/bin/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/coolstack/mysql_32bit/bin/mysqladmin -u root password 'new-password'
/opt/coolstack/mysql_32bit/bin/mysqladmin -u root -h SB100 password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /opt/coolstack/mysql_32bit/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /opt/coolstack/mysql_32bit ; /opt/coolstack/mysql_32bit/bin/mysqld_safe &

Last edited by UltraSoul; 01-11-2008 at 11:57 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Installing Solaris 10 x86 on a. Dell X620? as400 Solaris / OpenSolaris 5 11-04-2007 10:15 AM
LXer: Compiz on Solaris x86 - Eye Candy for Solaris’s Desktop LXer Syndicated Linux News 1 05-30-2007 02:31 PM
great solaris website for newbies http://solaris-x86.org/ feetyouwell Solaris / OpenSolaris 2 12-06-2006 12:14 AM
Installing Apache,PHP,MYSQl on Solaris 7 saravanan1979 Linux - Networking 3 09-03-2003 03:23 AM

LinuxQuestions.org > Forums > Other *NIX Forums > Solaris / OpenSolaris

All times are GMT -5. The time now is 12:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration