Install MySQL on Solaris

MySQL can be installed on Solaris using a binary package which is the native Solaris PKG format, instead of using the binary tarball distribution. The installation package has a dependency on the Oracle Developer Studio 12.6 Runtime Libraries. This needs to be installed before running the MySQL installation package.

The installation package ensures that the runtime libraries only are installed, instead of having to install the full Oracle Developer Studio. This package can be used by downloading the corresponding mysql-VERSION-solaris11-PLATFORM.pkg.gz file.

Uncompress Solaris Package

This needs to be uncompressed after being downloaded. Below is a sample code to do the same −

shell> gunzip mysql-8.0.25-solaris11-x86_64.pkg.gz

Installing new packages

If you need to install a new package, you need to use the "pkgadd" option and follow the on-screen prompts.

Additionally, the user must have root privileges to perform this operation.

shell> pkgadd -d mysql-8.0.25-solaris11-x86_64.pkg
The following packages are available:
1 mysql MySQL Community Server (GPL)
(i86pc) 8.0.25
Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]:

The PKG installer installs all the files and tools that are needed, and initializes the database as well (if it doesn't exist).

To complete the installation, the root password for MySQL has to be set based on the instructions provided at the end of the installation. Otherwise, there is another way to do this- The 'mysql_secure_installation' script has to be run, which comes with the installation.

By default, the PKG package installs MySQL under the root path, i.e /opt/mysql. The installation root path can be changed only if 'pkgadd' is used. This can be used to install MySQL in a different zone of Solaris.

Safe startup and shutdown

If MySQL needs to be automatically enabled during startup and closed when the system is shut down, a link needs to be created between this file and the 'init' script directories.

To ensure safe startup and shutdown of MySQL, the below commands can be added to the correct links.

shell> ln /etc/init.d/mysql /etc/rc3.d/S91mysql
shell> ln /etc/init.d/mysql /etc/rc0.d/K02mysql

If the Solaris package file format needs to be upgraded, it needs to be removed before installing the updated package Existing package installation. When a package is removed, it does not delete existing information on the database. It will only remove the server, binaries and support files.

The above is the detailed content of Install MySQL on Solaris. For more information, please follow other related articles on the PHP Chinese website!