MySQL Installation Guide On SOlaris10

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.


I hope this will help those who are trying to install the MySQL 5.0 database on the Solaris 10 OS for the first time. These pieces of software are some of the greatest works which were created by some of the most beautiful minds ever existed. Enjoy…



OTHER VERSION

2.6. Installing MySQL on Solaris
To obtain a binary MySQL distribution for Solaris in tarball or PKG format, http://dev.mysql.com/downloads/mysql/5.1.html.
If you install MySQL using a binary tarball distribution on Solaris, you may run into trouble even before you get the MySQL distribution unpacked, as the Solaris tar cannot handle long file names. This means that you may see errors when you try to unpack MySQL.
If this occurs, you must use GNU tar (gtar) to unpack the distribution.
You can install MySQL on Solaris using a binary package in PKG format instead of the binary tarball distribution. Before installing using the binary PKG format, you should create the mysql user and group, for example:
groupadd mysql
useradd -g mysql mysql
Some basic PKG-handling commands follow:
• To add a package:
• pkgadd -d package_name.pkg
• To remove a package:
• pkgrm package_name
• To get a full list of installed packages:
• pkginfo
• To get detailed information for a package:
• pkginfo -l package_name
• To list the files belonging to a package:
• pkgchk -v package_name
• To get packaging information for an arbitrary file:
• pkgchk -l -p file_name
For additional information about installing MySQL on Solaris, see Section 2.13.3, “Solaris Notes”.