mysql5.0.19在solaris8平台上的安装问题

sunnycn

系统介绍：\r\n硬件是sun280r机器，1颗900MHz cpu，2GB内存。\r\n操作系统：Solaris8操作系统，相关推荐补丁已经全部安装安装。\r\nmysql5.0.19的软件包是在mysql网站下载的\r\nmysql-debug-5.0.19-solaris8-sparc.pkg.gz包，使用gzip -d解压缩后为pkg包，如下：\r\nmysql-debug-5.0.19-solaris8-sparc.pkg\r\n使用pkgadd安装之前：\r\n创建了mysql用户，mysql组。如下：mysql:101:100::/home/mysql:/bin/sh          mysql::100:\r\n\r\n然后使用pkgadd -d mysql-debug-5.0.19-solaris8-sparc.pkg\r\n安装完成后，更改/opt/mysql目录属主\r\n#chown -R mysql /opt/mysql\r\n可在/usr/local/mysql目录下能看到一个如下的连接文件lrwxrwxrwx   1 root     other         16  4月  9 22:16 mysql -> /opt/mysql/mysql\r\n不知道这个目录的属主如何修改。\r\n启动mysql过程\r\n# pwd\r\n/opt/mysql/mysql/bin\r\n\r\n# ./safe_mysqld --user=mysql\r\n错误信息如下：\r\n# ./safe_mysqld --user=mysql\r\nStarting mysqld daemon with databases from /usr/local/mysql/data\r\nSTOPPING server from pid file /usr/local/mysql/data/dtsfw.pid\r\n070409 22:47:14  mysqld ended\r\n查看错误日志文件信息如下：\r\n# more dtsfw.err\r\n070409 22:39:00  mysqld started\r\n070409 22:39:00  InnoDB: Database was not shut down normally!\r\nInnoDB: Starting crash recovery.\r\nInnoDB: Reading tablespace information from the .ibd files...\r\nInnoDB: Restoring possible half-written data pages from the doublewrite\r\nInnoDB: buffer...\r\n070409 22:39:00  InnoDB: Starting log scan based on checkpoint at\r\nInnoDB: log sequence number 0 36808.\r\nInnoDB: Doing recovery: scanned up to log sequence number 0 43655\r\n070409 22:39:00  InnoDB: Starting an apply batch of log records to the database.\r\n..\r\nInnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21\r\n22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48\r\n 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 7\r\n5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99\r\nInnoDB: Apply batch completed\r\n070409 22:39:00  InnoDB: Started; log sequence number 0 43655\r\n070409 22:39:00 [Note] Recovering after a crash using mysql-bin\r\n070409 22:39:00 [Note] Starting crash recovery...\r\n070409 22:39:00 [Note] Crash recovery finished.\r\n070409 22:39:00 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table\r\n \'mysql.host\' doesn\'t exist\r\n070409 22:39:00  mysqld ended\r\n\r\n070409 22:47:13  mysqld started\r\n070409 22:47:14  InnoDB: Database was not shut down normally!\r\nInnoDB: Starting crash recovery.\r\nInnoDB: Reading tablespace information from the .ibd files...\r\nInnoDB: Restoring possible half-written data pages from the doublewrite\r\nInnoDB: buffer...\r\n070409 22:47:14  InnoDB: Starting log scan based on checkpoint at\r\nInnoDB: log sequence number 0 36808.\r\nInnoDB: Doing recovery: scanned up to log sequence number 0 43655\r\n070409 22:47:14  InnoDB: Starting an apply batch of log records to the database.\r\n..\r\nInnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21\r\n22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48\r\n 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 7\r\n5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99\r\nInnoDB: Apply batch completed\r\n070409 22:47:14  InnoDB: Started; log sequence number 0 43655\r\n070409 22:47:14 [Note] Recovering after a crash using mysql-bin\r\n070409 22:47:14 [Note] Starting crash recovery...\r\n070409 22:47:14 [Note] Crash recovery finished.\r\n070409 22:47:14 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table\r\n \'mysql.host\' doesn\'t exist\r\n070409 22:47:14  mysqld ended\r\n\r\n#

sunnycn

类似的问题我已经在本论坛中找到处理的方法，但最终还是没有解决，目前mysql还是不能启动。不知道是不是/usr/local/mysql目录连接的权限问题所造成的。

sunnycn

执行如下命令时，出现的问题，不知道是什么原因找不到mysql_install_db:my_print_defaults呢？\r\n# ./mysql_install_db --user=mysql\r\n./mysql_install_db: my_print_defaults: 没找到\r\nInstalling all prepared tables\r\nFill help tables\r\n\r\nTo start mysqld at boot time you have to copy support-files/mysql.server\r\nto the right place for your system\r\n\r\nPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !\r\nTo do so, start the server, then issue the following commands:\r\n/opt/mysql/mysql/bin/mysqladmin -u root password \'new-password\'\r\n/opt/mysql/mysql/bin/mysqladmin -u root -h dtsfw password \'new-password\'\r\nSee the manual for more instructions.\r\n\r\nNOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run\r\nthe /opt/mysql/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be\r\nable to use the new GRANT command!\r\n\r\nYou can start the MySQL daemon with:\r\ncd . ; /opt/mysql/mysql/bin/mysqld_safe &\r\n\r\nYou can test the MySQL daemon with the benchmarks in the \'sql-bench\' directory:\r\ncd sql-bench ; perl run-all-tests\r\n\r\nPlease report any problems with the ./bin/mysqlbug script!\r\n\r\nThe latest information about MySQL is available on the web at\r\nhttp://www.mysql.com\r\nSupport MySQL by buying support/licenses at https://order.mysql.com

sunnycn

现在mysql启动了，但当进入mysql数据时出现如下错误。\r\n$ mysql -uroot -p\r\nEnter password:\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 1 to server version: 5.0.19-debug-log\r\n\r\nType \'help;\' or \'\\h\' for help. Type \'\\c\' to clear the buffer.\r\n\r\nmysql> 段错误\r\n$\r\n然后，终端就死了。

susbin

没用过 debug 版的。\r\n要搞清楚你的 Solaris8 是32-bit 还是 64-bit.\r\n楼主可以从这里下个5.0.37 试试。\r\n\r\nSolaris (pkgadd packages) downloads\r\nhttp://dev.mysql.com/downloads/mysql/5.0.html#solaris-pgadd

sunnycn

我是安装在solaris 8 32位平台上。

sunnycn

$ mysql --user=root mysql\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 8\r\nServer version: 5.0.37-log MySQL Community Server (GPL)\r\n\r\nType \'help;\' or \'\\h\' for help. Type \'\\c\' to clear the buffer.\r\n\r\nmysql>\r\n段错误\r\n$\r\n依照你的要求，下载了这个新的安装包，安装完成后，mysql可以正常启动，但不能进入mysql数据进行任何操作。

susbin

建议楼主去 MySQL 版提问。

sunnycn

原帖由 susbin 于 2007-4-10 01:36 发表\r\n没用过 debug 版的。\r\n要搞清楚你的 Solaris8 是32-bit 还是 64-bit.\r\n楼主可以从这里下个5.0.37 试试。\r\n\r\nSolaris (pkgadd packages) downloads\r\n[url]http://dev.mysql.com/downloads/mysql/5.0.html#solaris- ...

\r\n\r\n已经下载并安装了，结果是一样的。\r\n操作系统我觉得应该没有什么问题。这个不能确定，因为上面运行着防火墙呢！

sunnycn

防火墙卸载了。solaris8系统重新安装了。故障依然，问题依然。搞不清楚是什么问题 。\r\n如果安装成solaris9估计应该是不是就可以了。\r\n真是郁闷，不知道是不是我的solaris8的安装介质的问题，但这个盘是原装的光盘，估计问题不大。