Dear support officer,
The followings are generated by the mysqlbug script:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: yuzh
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
<precise description of the problem (multiple lines)>
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: <submitter ID>
>Originator: Greg Yu
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-3.23.39-max (Official MySQL-max binary)
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for pc-solaris2.8
>on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.39-max
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 2 hours 11 min 0 sec
Threads: 1 Questions: 22 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.003
>Environment:
<machine, os, target, libraries (multiple lines)>
System: SunOS ictest 5.8 Generic_108529-12 i86pc i386 i86pc
Architecture: i86pc
Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/3.0.1/specs
Configured with: ../configure --with-as=/usr/local/bin/as --with-ld=/usr/local/bin/ld
Thread model: posix
gcc version 3.0.1
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1588040 Nov 17 07:10 /lib/libc.a
lrwxrwxrwx 1 root root 11 Nov 20 11:48 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 943052 Nov 17 07:10 /lib/libc.so.1
-rw-r--r-- 1 root bin 1588040 Nov 17 07:10 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Nov 20 11:48 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 943052 Nov 17 07:10 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max
--disable-shared --with-berkeley-db --with-innodb
Perl: This is perl, version 5.005_03 built for i86pc-solaris
1. libaray file libncurses.so.5 is missing.
yuzh@ictest[/usr/local/mysql/bin] 231# mysql_fix_privilege_tables
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions or
want to use the more secure passwords.
If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!
If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name' or
'Table 'func' already exists'. You can safely ignore these!
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file
or directory
Killed
Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file
or directory
Killed
Creating the new table and column privilege tables
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file
or directory
Killed
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any errors from this
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file
or directory
Killed
Fixing the func table
You can ignore any Duplicate column errors
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file
or directory
Killed
2. Access denied for user defined in mysql group:
yuzh@ictest[/home/yuzh] 213# mysqlshow mysql
mysqlshow: Access denied for user: '@localhost' to database 'mysql'
yuzh@ictest[/etc/rc3.d] 249# mysqlshow
mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
Please tell me how to fix the about problems.
Thanks!
--
Regards
Greg Yu
----------------------------------------------------------------------
Zhi Huan Yu
Computer Systems Administrator
School of Engineering & Mathematics
Edith Cowan University Email: [EMAIL PROTECTED]
100 Joondalup Drive Tel: int +61 8 9400 5846
Western Australia 6027 Fax: int +61 8 9400 5811
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
