CONGRATULATION - SOLVED - PERMANENT - BOOKMARK IT!!!!! now...

[hello world]

Please read carefull, because its solved.

i spend 5 weeks as newbie and got no help for solaris10, and have a to z configure listed for futer newbies so that you can save your time now.., thanks me if you want.

1. download mysql (i am in solaris10) to
/sbin direcotry
ht t p:/ /dev.mysql.com/get/Downloads/MySQL-5.0/mysql-standard-5.0.27-solaris10-i386.pkg.gz/from/http://mysql.belnet.be/

2. unzip the file which you downloaded in /sbin directory
#gunzip mysql-standard-5.0.27-solaris10-i386.pkg.gz

3. install the package from /sbin direcotry
#pkgadd -d mysql-standard-5.0.27-solaris10-i386.pkg

4. it will be installed in /usr/local/mysql or /opt/mysql/mysql

5. copy the mysql configuration file to one global place, which you can define easyly.
#cp /usr/local/mysql/support-bin/my-small.cnf /etc/my.cnf

6. edit the my.cnf file
#vi /etc/my.cnf

7. add 3 lines under /etc/my.cnf
[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/var/lib/mysql/mysql

save this configurations it

8. mysqld startup method, (like starting services)
#/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql
#/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql

9. congratulation, you saved your 5 weeks time in 5 minutes.

10. check its running or not!.
#ps -ef | grep mysql

11. login to mysql promt. and startup your database and table and query.
#/usr/local/mysql/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.27-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


note: if you force to start use /etc/init.d/mysql start, make one thing clear that mysqld.sock is created by mysqld startup. its not related with mysql package.