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

[Daniel P. Zepeda]

On Tue, 20 Nov 2001, Dorothy Puma wrote:

> Daniel,
> See notes below
> 
> > 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

Actually not, DBI can and does parse the line I gave it as a valid DSN. I 
don't pass it the port because I use the default port. 

I know this works 'cause I've got one that working that I just edited the 
config file for, that uses a DSN line exactly as shown (with the correct
hostname of course). 

This part is really irrelevant because this is not used in the mysqladmin
command. 

> 
> >
> > 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

That is what I'm showing. Again, don't have to pass the port because I'm 
using the default port. 

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

Yes. Once for the DBI DSN, and again for the mysqladmin command. And no, it 
doesn't work, that is the problem :-(




> ---
> Dorothy
> 
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
> 

-- 
"InterSAT Technical Support" <support@satx.net>