Development Applications
MySQL
Sun supply an instance of MySQL in /usr/sfw however it's a touch elderly. MySQL recommend you use their binary downloads! In this instance, the Sol 10 pkg for 5.0.15.
su groupadd mysql useradd -g mysql mysql passwd -l mysql pkgadd -d .../mysql-standard-5.0.15-solaris10-i386.pkg
A little post-install work:
# the cd should take you to /usr/local/mysql/mysql-standard-5.0.15-solaris10-i386 cd /usr/local/mysql/!$:t:r ./scripts/mysql_install_db --user=mysql chown -R root . chown -R mysql data chgrp -R mysql . cat <<EOF > /etc/init.d/mysql #!/bin/sh MYSQL_TOP=${PWD} ( cd \${MYSQL_TOP} ./support-files/mysql.server \$1 ) EOF chmod a+x /etc/init.d/mysql ln /etc/init.d/mysql /etc/rc3.d/S50mysql ln /etc/init.d/mysql /etc/rc3.d/K50mysql
Twirl with the MySQL configuration file (noting that basedir will be set to something like /usr/local/mysql/mysql-standard-5.0.15-solaris10-i386) and watch out for the embedded newlines in this sed script:
# set up my.cnf file or edit the existing one! sed -e '/^.mysqld.$/a\ basedir = '$PWD' ' support-files/my-medium.cnf > /etc/my.cnf
Finally create root password entries (root as in admin user).
Note
We create passwords for the user for both localhost and our hostname ($(uname -n)) as it's never terribly clear when applications decide to use which.
./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h $(uname -n) 'new-password'
Document Actions