MySQL DBA - Tips and Techniques Magazine

13 Nov 2014

Install MYSQL on SOLARIS

  1. Download the correct version.  There are two versions – a tar file and a package.  The package version installs as part of the Solaris OS , but then means we can have no further mysql installs.  So we tend to download the tar version e.g. mysql-advanced-gpl-5.1.47-solaris10-x86_64.tar

 

  1. Put the download into the bin directory eg /ebilldb-master/mysql-bin

 

  1. untar the download file, this creates a directory called mysql-advanced-gpl-5.1.47-solaris10-x86_64

 

  1. change permissions i.e.

 

chown -R mysql:mysql mysql-advanced-gpl-5.1.47-solaris10-x86_64

 

  1. create a softlink to the untarred directory called mysql 

 

ln -s mysql-advanced-gpl-5.1.47-solaris10-x86_64 mysql

 

 

  1. copy a my.cnf and put into the  …/mysql-data dir
  2. edit the my.cnf

-change the bind address to the same as that in /etc/hosts

- change the path names

- if it's a slave then make sure the server-id is different from the master

 

  1. Populate the mysql Database Tables and check logs for any errors

 

cd …/mysql-bin/mysql

 

      ./scripts/mysql_install_db --user=mysql --basedir=/ebilldb-master /mysql-bin/mysql --datadir=/ ebilldb-master /mysql-data --defaults-file=/ ebilldb-master /mysql-data/my.cnf

 

 

 

No comments:

Post a comment