Friday, September 5, 2008

Installing MySQL 5.0 on Solaris 10

Installing MySQL 5.0 on Solaris 10.
At least some basic Unix/Linux administrative skills.
must have FRESH running copy of Solaris 10 6/06.
unstalled MySQL version in the system
.
DownloadsPlease 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).PreparationPlease perform the following as the root user.
Imp point--Make sure that any other previously running copies of MySQL are to be uninstalled from the system.
Step 1.
login as “root”
To list all the packages, type: "pkginfo grep mysql" at the shell.
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.
Step 2.
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. InstallationFollow these steps to perform the installation (perform as "root"):
Step 3.
Create the mysql group by typing “groupadd mysql”.
Create the mysql user by typing “useradd -g mysql mysql”.
Change the directory where the MySQL packages were placed. “cd /usr/files”.
install the package by typing: “pkgadd -d mysql-xxx.pkg”. Just accept the default install directory (/opt/mysql) when prompted and go through the installation process.
Step4.
The MySQL should have been installed in “/opt/mysql/mysql”.
Change the directory to /etc/init.d and edit the "mysql" file with any text editor.
IT is better to keep the copy in desktop before you make edit
Locate the line which states: "datadir=". Change the line to "datadir=/opt/mysql/mysql/data". Save the changes.

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
Change the operating user from “root” to “mysql” by tying: “su mysql”.
Change the working directory to “/opt/mysql/mysql/scripts” by typing: “cd /opt/mysql/mysql/scripts”.
Execute the mysql_db_install script by typing: “./mysql_install_db --user=mysql --ldata=/opt/mysql/mysql/data”.
Change the working directory to "/opt/mysql/mysql/bin”.
Start the database by typing: “./mysqld_safe --datadir=/opt/mysql/mysql/data --user=mysql &”.
Connecting to MySQLTry 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.
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.