[ic] SQL database on another server, Still having wizard problems

Dorothy Puma interchange-users@interchange.redhat.com
Tue Nov 20 17:57:00 2001


Daniel,
See notes below

> Oh, I've tried this. When I put -u USERNAME -p -h HOSTNAME  on the extra options line, I get
> an error which is telling me it is trying to connect to a local MySQL server. Notice the 'run'
> prompt doesn't show any of my extra options.
>
> Here is the relevant portion of the makecat run if I don't put a username
> and password when prompted:
>
> Set to 1 if you want to use MySQL: ...............1
> Database to use (will be created): ...............test_testcat43
> .........................dbi:mysql:test_testcat43;HOSTNAME

At this point you need the whole line:

dbi:mysql:database=test_testcat43;host=HOSTNAME:port=3309

>
> Username for MySQL (if any): .....................
> Password for MySQL (if any): .....................
>
> We can try and use mysqladmin to create the database in
> MySQL. In many default MySQL distributions, any user can create
> a database beginning with "test".
>
> Use the next option to add parameters. If your MySQL is password-protected
> (and you know the password) you may want to add "-u root -p".
>
> Set to 1 to create 'test_testcat43' with mysqladmin: ..1
>
> To create the database you may need to supply a password and
> username. To do that, add the option "-u USERNAME -p", where
> USERNAME is a MySQL user with permission to create databases.
> This is often the user "root".
>
> Extra options for creation: ......................-u interch -p -h HOSTNAME

At this point do the:

-u USERNAME -p -h HOSTNAME --port=3309

You're adding the host name and port number twice, but it works.
---
Dorothy