Running example resetdb or simple1 problem -
10-06-2005
, 09:36 AM
Hi all,
I am using MySQL on a shared Linux server. I got MySQL++ to build
fine.
When I try to run the example program resetdb, however, I don't get
anywere.
The server requires that I use a password to acces the mysql
command-line monitor.
I can't use localhost as my host. Rather, I connect through the
following socket: --socket=/var/lib/mysql/mysql.sock
For example, at the (bash) command line, I type:
mysql --socket=/var/lib/mysql/mysql.sock --user=matthew
--password=myPassword
and this works well. I get to the mysql monitor and I can type SHOW
DATABASES; and see the database that I created.
However, when I try the following, I don't seem to be executing the
program correctly:
../resetdb --socket=/var/lib/mysql/mysql.sock --user=matthew
--password=myPassword
I get the following message:
usage: lt-resetdb [host] [user] [password] [port]
Connects to database "" on localhost using your user
name and no password by default.
and it returns an exit code of 1.
I have also tried various combinations, such as:
../resetdb --socket=/var/lib/mysql/mysql.sock matthew myPassword
../resetdb /var/lib/mysql/mysql.sock matthew myPassword
../resetdb /var/lib/mysql/mysql.sock matthew myPassword 3306
to no avail.
The version information is given below:
$mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.58, for redhat-linux-gnu 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.58
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 14 days 16 hours 17 min 53 sec
Threads: 22 Questions: 20342480 Slow queries: 205 Opens: 83653
Flush tables: 1 Open tables: 64 Queries per second avg: 16.040
---------
I built version mysql++-1.7.40 against the 3.23.58 header files.
Thanks for any help,
Matthew. |