As the version I was running was very old, there are some notes at the bottom of this post, as if like me you want to move to a more up-to-date implementation.
root@dbserver> pkgadd -d ./mysql-5.0.96-solaris9-sparc-64bit.pkg
The following packages are available:
1 mysql MySQL Community Server (GPL)
(sun4u) 5.0.96
Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]: all
Processing package instance <mysql> from </angela01/mysql/mysql-5.0.96-solaris9-sparc-64bit.pkg>
MySQL Community Server (GPL)(sun4u) 5.0.96
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. All rights reserved.
Use is subject to license terms.
The selected base directory </opt/mysql> must exist before installation is attempted.
Do you want this directory created now [y,n,?,q] y
Using </opt/mysql> as the package base directory.
## Processing package information.
## Processing system information.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.
## Checking for setuid/setgid programs.
This package contains scripts which will be executed with super-user
....
output skipped for brevity
Postinstall script.
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/mysql/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/mysql/bin/mysqladmin -u root -h observer password 'new-password'
Alternatively you can run:
/opt/mysql/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at
http://shop.mysql.com
Installation of <mysql> was successful.
see also :
http://www.developerscrappad.com/172/database/mysql/installing-mysql-5-0-on-solaris-10/
Default options are read from the following files in the given order: /etc/my.cnf /opt/mysql/mysql/etc/my.cnf ~/.my.cnf
# Starting up:
root@dbserver> nohup mysqld -u root &
root@dbserver> mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.96 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
