Solaris10 Install Mysql5.0

1. download mysql5.0GA
ftp://ftp.cs.pu.edu.tw/Unix/mysql/Downloads/MySQL-5.0/mysql-max-5.0.24-solaris10-x86_64.pkg.gz
2. unzip and pkgadd
groupadd mysql
useradd -g mysql mysql
gunzip mysql-max-5.0.24-solaris10-x86_64.pkg.gz
pkgadd -d mysql-max-5.0.24-solaris10-x86_64.pkg
3. change root password
default root’s password is ‘’
mysqladmin -u root password new_password
or
shell> mysql -u root mysql
mysql> SET PASSWORD FOR root=PASSWORD(’new_password’);
4. Add LAN Access
shell> mysql -u root mysql -p
Enter password: password
mysql>
mysql>use mysql;
mysql>select host, user from user;
+———–+——+
| host | user |
+———–+——+
| localhost | |
| localhost | root |
| loghost | |
| loghost | root |
+———–+——+
mysql>GRANT ALL PRIVILEGES ON *.* TO root@’%’
IDENTIFIED BY ‘123′ WITH GRANT OPTION;
OR
mysql>INSERT INTO user (Host,User,Password)
VALUES(’%',’root’,PASSWORD(’123′));
mysql> FLUSH PRIVILEGES;

now:
mysql>select host, user from user;
+———–+——+
| host | user |
+———–+——+
| % | root | —> net access
| localhost | |
| localhost | root |
| loghost | |
| loghost | root |
+———–+——+

5. winxp MySQLAdministrator you can use; root & 123

reference:
1. #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