solaris10下安装mysql5.5(SMF)

非凡公子

1. 下载
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.9-solaris10-i386.tar.gz/from/http://mysql.easynet.be/

2.建用户和组

1. groupadd -g 1010 mysql
2. useradd -u 1010 -d /export/home/mysql -g mysql -s /bin/false -c "MySQL User" -m mysql

3.解包安装

1. cd /export/home/mysql
2. rm *
3. gzcat /export/home/feifan/soft/mysql-5.5.9-solaris10-i386.tar.gz | tar -xvf -
4. ln -s mysql-5.5.9-solaris10-i386 mysql

4.初始化数据库

1. cd /export/home/mysql/mysql-5.5.9-solaris10-i386
2. scripts/mysql_install_db --datadir=/export/home/mysql/data

1. Installing MySQL system tables...
   
2. OK
   
3. Filling help tables...
   
4. OK
   
5. 
   
6. To start mysqld at boot time you have to copy
   
7. support-files/mysql.server to the right place for your system
   
8. 
   
9. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
   
10. To do so, start the server, then issue the following commands:
    
11. 
    
12. ./bin/mysqladmin -u root password 'new-password'
    
13. ./bin/mysqladmin -u root -h mdc-solsvr password 'new-password'
    
14. 
    
15. Alternatively you can run:
    
16. ./bin/mysql_secure_installation
    
17. 
    
18. which will also give you the option of removing the test
    
19. databases and anonymous user created by default. This is
    
20. strongly recommended for production servers.
    
21. 
    
22. See the manual for more instructions.
    
23. 
    
24. You can start the MySQL daemon with:
    
25. cd . ; ./bin/mysqld_safe &
    
26. 
    
27. You can test the MySQL daemon with mysql-test-run.pl
    
28. cd ./mysql-test ; perl mysql-test-run.pl
    
29. 
    
30. Please report any problems with the ./bin/mysqlbug script!

1. chown -R mysql:mysql /export/home/mysql

5.启动脚本svc-mysql

1. cp support-files/mysql.server /lib/svc/method/svc-mysql
2. chown root:bin /lib/svc/method/svc-mysql
3. chmod 555 /lib/svc/method/svc-mysql

vi /lib/svc/method/svc-mysql
修改

1. basedir='/export/home/mysql/mysql'
   
2. datadir='/export/home/mysql/data'

6.mysql.xml

1. cd /var/svc/manifest/application/database

vi mysql.xml

1. <?xml version="1.0"?>
   
2. <!DOCTYPE service_bundle SYSTEM "/usr/share/lib/xml/dtd/service_bundle.dtd.1">
   
3. <!--
   
4.         ident "@(#)mysql.xml 5.5.9 11/02/22 SMI"
   
5.         By feifan@CU
   
6. -->
   
7. 
   
8. <service_bundle type='manifest' name='mysql'>
   
9. 
   
10. <service
    
11.         name='application/database/mysql'
    
12.         type='service'
    
13.         version='1'>
    
14.         <create_default_instance enabled='false' />
    
15.         <single_instance />
    
16. 
    
17.         <!--
    
18.            Wait for all local filesystems to be mounted.
    
19.         -->
    
20.         <dependency
    
21.                 name='filesystem-local'
    
22.                 grouping='require_all'
    
23.                 restart_on='none'
    
24.                 type='service'>
    
25.                 <service_fmri value='svc:/system/filesystem/local:default' />
    
26.         </dependency>
    
27. 
    
28.         <!--
    
29.            Wait for network loopback to be initialized.
    
30.         -->
    
31.         <dependency
    
32.                 name='loopback'
    
33.                 grouping='require_all'
    
34.                 restart_on='none'
    
35.                 type='service'>
    
36.                 <service_fmri value='svc:/network/loopback' />
    
37.         </dependency>
    
38. 
    
39.         <method_context>
    
40.                 <method_credential user='mysql' group='mysql' />
    
41.         </method_context>
    
42. 
    
43.         <exec_method
    
44.                 type='method'
    
45.                 name='start'
    
46.                 exec='/lib/svc/method/svc-mysql start'
    
47.                 timeout_seconds='200' />
    
48. 
    
49.         <exec_method
    
50.                 type='method'
    
51.                 name='stop'
    
52.                 exec='/lib/svc/method/svc-mysql stop'
    
53.                 timeout_seconds='200' />
    
54. 
    
55.         <exec_method
    
56.                 type='method'
    
57.                 name='restart'
    
58.                 exec='/lib/svc/method/svc-mysql restart'
    
59.                 timeout_seconds='60' />
    
60. 
    
61.         <exec_method
    
62.                 type='method'
    
63.                 name='refresh'
    
64.                 exec='/lib/svc/method/svc-mysql reload'
    
65.                 timeout_seconds='60' />
    
66. 
    
67.         <exec_method
    
68.                 type='method'
    
69.                 name='status'
    
70.                 exec='/lib/svc/method/svc-mysql status'
    
71.                 timeout_seconds='60' />
    
72. 
    
73.         <stability value='Evolving' />
    
74. 
    
75.         <template>
    
76.                 <common_name>
    
77.                         <loctext xml:lang='C'>
    
78.                                 MySQL RDBMS
    
79.                         </loctext>
    
80.                 </common_name>
    
81.                 <documentation>
    
82.                         <manpage title='mysql' section='8' />
    
83.                         <doc_link name='mysql.com'
    
84.                                 uri='http://www.mysql.com' />
    
85.                 </documentation>
    
86.         </template>
    
87. 
    
88. </service>
    
89. 
    
90. </service_bundle>

1. chown root:sys /var/svc/manifest/application/database/mysql.xml
2. chmod 444 /var/svc/manifest/application/database/mysql.xml
3. 
   
4. svccfg -v validate /var/svc/manifest/application/database/mysql.xml
5. svccfg -v import /var/svc/manifest/application/database/mysql.xml
6. 
   
7. svcadm enable mysql
8. svcs -l mysql

#运行sql-bench
cd sql-bench
./run-all-tests
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/perl5/5.8.4/lib/i86pc-solaris-64int /usr/perl5/5.8.4/lib /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int /usr/perl5/site_perl/5.8.4 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/i86pc-solaris-64int /usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .) at (eval 54) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, Sponge.
 at /export/home/mysql/mysql-5.5.9-solaris10-i386/sql-bench/server-cfg line 247
安装DBD
最新的4.018编译有问题,用3.0008通过.

wget http://cpan.develooper.com/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz
gzcat DBD-mysql-3.0008.tar.gz | tar -xvf -
cd DBD-mysql-3.0008

1. perl Makefile.PL \
   
2.     --libs="-L/export/home/mysql/mysql/lib -lmysqlclient -lz" \
   
3.     --cflags=-I/export/home/mysql/mysql/include \
   
4.     --testhost=127.0.0.1

1. make
2. make test # Some minor error messages can be ignored here
3. make install
4. 
   
5. cd sql-bench
6. ./run-all-tests