MySQL Community Server 5.5.24 installation on Solaris 11 (x64)

[cah]

1. Download Solaris package from mysql.com

mysql-5.5.24-solaris11-x86_64.pkg.gz

2. Unzip it

3. Install the package

Code: Select all

pkgadd -d mysql-5.5.24-solaris11-x86_64.pkg

.......
## Executing postinstall script.

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/opt/mysql/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/mysql/bin/mysqladmin -u root -h orautil02 password 'new-password'

Alternatively you can run:
/opt/mysql/mysql/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems with the /opt/mysql/mysql/scripts/mysqlbug script!


Installation of <mysql> was successful.

NOTICE: Without explicitly grant privileges to root user, MySQL Workbench was unable to connect to it.

Grant all privileges to root user:

Code: Select all

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql4dm1n' WITH GRANT OPTION;