#614

[MySQL] Install MySQL server on Solaris

Download generic package (TAR file)

Create group and user :

groupadd mysql
useradd -r -g mysql mysql

Create folder and symbolic link :

mkdir /path/to/mysql/install
chown -R mysql:mysql /path/to/mysql/install
cd /usr/local
ln -s /path/to/mysql/install mysql

Extract the archive and install database :

tar xvf /path/to/mysql-VERSION-OS.tar -C /path/to/mysql/install
scripts/mysql_install_db --user=mysql
cp support-files/my-default.cnf /etc/my.cnf

Update permissions :

chown -R root .
chown -R mysql data

Start database :

bin/mysqld_safe --user=mysql &

Update user/host priviliges :

update user set host='%' where host = "<CURRENT_HOSTNAME>";

Stop/Start database :

mysqladmin shutdown
bin/mysqld_safe --user=mysql &