[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] SQL database on another server, Still having wizard problems
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>
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users