Configure MYSQL under Solaris

Solaris has its own mysql server, saving you a lot of trouble. Only a small configuration can be used.

1. log on to the system as the ROOT user and enter/usr/sfw/bin/mysql_install_db on the terminal.

2. Create mysql user and group:

# Groupadd mysql

# Useradd-g mysql

# Chgrp-R mysql/var/mysql

# Chmod-R 770/var/mysql

# Installf SUNWmysqlr/var/mysql d 770 root mysql

3. Copy the MySQL configuration file to the specified location.

# Cp/usr/sfw/share/mysql/my-medium.cnf/var/mysql/my. cnf

4. manually start mysql

#/Usr/sfw/sbin/mysqld_safe -- user = mysql &

5. Set the MySQL root Password (I use 1234 as the password)

# Cd/usr/sfw/bin

#./Mysqladmin-u root password '000000'

Okay, you have done it. Use the mysql-uroot-p1234 command to log on.