Probleme bei MySQL Installation unter WARP3

[Holger.Tschirschky_(at)_nokia.com]

Hallo,

ich habe die Binary-Version 3_22_26a unter OS2 Warp3 installiert.

Der Server lässt sich starten, ebenso der client: z.B mit >mysql mysql.

Leider lässt sich kein Benutzer angeben "mysql -u root mysql". Der Client
wird dann mit Process terminated by SEGSEGV beendet.
Ebenso sind da Probleme mit dem Setzen des Passwortes für einen bestimmten
Nutzer (vorerst root). 
Siehe dazu folgende Kommandos:


*******************************LOG
STARTS***************************************** 

[D:\prog_os2\mysql\bin]mysql -h
mysql: option requires an argument -- h
mysql  Ver 9.35 Distrib 3.22.26a, for pc-os2_emx (i386)
By TCX Datakonsult AB, by Monty
This software comes with ABSOLUTELY NO WARRANTY.

Usage: mysql [OPTIONS] [database]

  -A, --no-auto-rehash  No automatic rehashing. One has to use 'rehash' to
                        get table and field completion. This gives a quicker
:
:
:
  -E, --vertical        Print the output of a query (rows) vertically
  -w, --wait            Wait and retry if connection is down

Possible variables for option --set-variable (-O) are:
max_allowed_packet    current value: 25165824
net_buffer_length     current value: 16384

[D:\prog_os2\mysql\bin]mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.22.26a-log

Type 'help' for help.

mysql> show tables;
+-----------------+
| Tables in mysql |
+-----------------+
| columns_priv    |
| db              |
| func            |
| host            |
| tables_priv     |
| user            |
+-----------------+
6 rows in set (0.02 sec)

mysql> select * from user;
+-----------+------+----------+-------------+-------------+-------------+---
----------+-------------+-----------+-------------+---------------+---------
-----+-----------+------------+-----------------+------------+------------+
| Host      | User | Password | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |
Process_priv | File_priv | Grant_priv | References_priv | Index_priv |
Alter_priv |
+-----------+------+----------+-------------+-------------+-------------+---
----------+-------------+-----------+-------------+---------------+---------
-----+-----------+------------+-----------------+------------+------------+
| localhost | root |          | Y           | Y           | Y           | Y
| Y           | Y         | Y           | Y             | Y            | Y
| Y          | Y               | Y          | Y          |
| loopback  | root |          | Y           | Y           | Y           | Y
| Y           | Y         | Y           | Y             | Y            | Y
| Y          | Y               | Y          | Y          |
| localhost |      |          | N           | N           | N           | N
| N           | N         | N           | N             | N            | N
| N          | N               | N          | N          |
| loopback  |      |          | N           | N           | N           | N
| N           | N         | N           | N             | N            | N
| N          | N               | N          | N          |
+-----------+------+----------+-------------+-------------+-------------+---
----------+-------------+-----------+-------------+---------------+---------
-----+-----------+------------+-----------------+------------+------------+
4 rows in set (0.40 sec)

mysql> quit
Bye

[D:\prog_os2\mysql\bin]mysql -u root

Process terminated by SIGSEGV

[D:\prog_os2\mysql\bin]mysql -u root mysql

Process terminated by SIGSEGV

[D:\prog_os2\mysql\bin]mysql -p
Enter password:
ERROR 1049: Unknown database '-p'

[D:\prog_os2\mysql\bin]mysql -u root -p mysql

Process terminated by SIGSEGV

[D:\prog_os2\mysql\bin]

****************************************************************************
***********
********************** Versuch, ein neues Passwort zu setzen
**************************

[D:\prog_os2\mysql\bin]mysqladmin ver
mysqladmin  Ver 7.11 Distrib 3.22.26a, for pc-os2_emx on i386
TCX Datakonsult AB, by Monty

Server version          3.22.26a-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             \socket\MySQL
Uptime:                 7 min 20 sec

Threads: 1  Questions: 12  Slow queries: 0  Opens: 10  Flush tables: 1  Open
tab
les: 6

[D:\prog_os2\mysql\bin]mysqladmin -u root password 'pwnew'

Process terminated by SIGSEGV

[D:\prog_os2\mysql\bin]mysqladmin password 'pwnew'

[D:\prog_os2\mysql\bin]mysqladmin -p ver
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root_(at)_localhost' (Using password: YES)'

[D:\prog_os2\mysql\bin]mysqladmin -p pwnew ver
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root_(at)_localhost' (Using password: YES)'

[D:\prog_os2\mysql\bin]mysqladmin -p 'pwnew' ver
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root_(at)_localhost' (Using password: YES)'

[D:\prog_os2\mysql\bin]mysqladmin --password ver
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root_(at)_localhost' (Using password: YES)'

[D:\prog_os2\mysql\bin]mysqladmin --password='pwnew' ver
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root_(at)_localhost' (Using password: YES)'

[D:\prog_os2\mysql\bin]mysqladmin --password=pwnew ver
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root_(at)_localhost' (Using password: NO)'

[D:\prog_os2\mysql\bin]
*******************************LOG
ENDS***************************************** 

Da dies meien ersten Datenbankerfahrungen sind, bitte ich um Hilfe.
Was mache ich falsch?

Gruß Holger
 

---
*** Abmelden von dieser Mailingliste funktioniert per E-Mail
*** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe