Installing mysql on solaris

Downloads

Please obtain a copy of MySQL 5.0 from http://dev.mysql.com/downloads/mysql/5.0.html. For the Solaris 10 MySQL packages, please scroll the page down the section of “Solaris (pkgadd package) downloads”. Choose the appropriate processor architecture of the package (either x86 or SPARC). Download the packages (both Standard and Max) and save them in an appropriate directory. I will use “/usr/files” as the directory where the mysql-xxx.pkg.gz files were placed through out the tutorial (Please take note that the xxx is the version number and is to be replaced by the actual text in the file name).

Preparation

Please perform the following as the root user. We have to make sure that any other previously running copies of MySQL are to be uninstalled from the system.

1. login as “root”
2. To list all the packages, type: "pkginfo | grep mysql" at the shell.
3. If you see any listed packages, you may remove them by typing “pkgrm ” The names of the packages are list at the second column of after executing pkginfo.
4. Change the directory to the place where you’ve downloaded the mysql-xxx.pkg.gz files. (e.g. “cd /usr/files”). If the files were compressed by gzip and you can see the .gz extension at the end of the files, you may decompress them by typing “gzip –d mysql-xxx.pkg.gz”. Decompress the downloaded mysql-xxx.pkg.gz files.

Installation

Follow these steps to perform the installation (perform as "root"):

1. Create the mysql group by typing “groupadd mysql”.
2. Create the mysql user by typing “useradd -g mysql mysql”.
3. Change the directory where the MySQL packages were placed. “cd /usr/files”.
4. First install the “Standard” package by typing: “pkgadd -d mysql-standard-xxx.pkg”. Just accept the default install directory (/opt/mysql) when prompted and go through the installation process.
5. Next, install the “Max” package by typing: “pkgadd –d mysql-max-xxx.pkg”. Just accept the default directory when prompted and go through the installation process.
6. The MySQL should have been installed in “/opt/mysql/mysql”.
7. Change the directory to /etc/init.d and edit the "mysql" file with any text editor. Locate the line which states: "datadir=". Change the line to "datadir=/opt/mysql/mysql/data". Save the changes.
   
8. After the installation, change the path to "/opt" and type this: “chown -R mysql:mysql mysql”. This is to change the ownership of the whole mysql directory.

Initiallizing the Database

1. Change the operating user from “root” to “mysql” by tying: “su mysql”.
2. Change the working directory to “/opt/mysql/mysql/scripts” by typing: “cd /opt/mysql/mysql/scripts”.
3. Execute the mysql_db_install script by typing: “./mysql_install_db --user=mysql --ldata=/opt/mysql/mysql/data”.
4. Change the working directory to "/opt/mysql/mysql/bin”.
5. Start the database by typing: “./mysqld_safe --datadir=/opt/mysql/mysql/data --user=mysql &”.

Connecting to MySQL

Try to connect to the MySQL database by typing “mysql” as the root user. You should be able to see the “mysql>” prompt for the successful connection. The only user which could connect to the database now is the root user and it doesn't require a password. For more information on user account management, please visit http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html.