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

Daniel P. Zepeda interchange-users@interchange.redhat.com
Tue Nov 20 17:50:01 2001


On Tue, 20 Nov 2001, Dorothy Puma wrote:
> When running the makecat:
> 
> dbi:mysql:database=NAMEOFDATABASE;host=HOSTNAME:port=3309
> 
> Then on your extra options:
> 
> -u USERNAME -p -h HOSTNAME --port=3309
> 
> 

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

...

run "mysqladmin -u  -p create test_testcat43"? y
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock'
exists!                    


Set to 1 if you want to use MySQL: ...............1
Database to use (will be created): ...............test_testcat45
DBI DSN to use: ..................................dbi:mysql:test_testcat45;HOSTNAME
Username for MySQL (if any): .....................interch
Password for MySQL (if any): .....................interchpass

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_testcat45' 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 interchpass -h HOSTNAME 

Found system commands to run.

Since you selected the MySQL option, you need to create a database named
"test_testcat45". In a default MySQL configuration, any user may create
and drop and modify test_* databases, but some administrators disable this.

run "mysqladmin -u interch -pinterchpass create test_testcat45"? y
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
  

Again, extra options are missing. 


-- 
"Daniel P. Zepeda" <dzepeda@satx.net>