Thanks for the details! I'm afraid I'm a bit green all the way around. Let
me describe what I need to do with mysql and maybe you could direct me to
what I need to research.
I need to build a db from a SQL Server table export. Then try to run
standard sql command line even (found this in the documentation).
After that I need to set up a Datasource to connect to this db (port 3306
from your email) using Tomcat.
I think I'm a bit confused as to where to begin setting up MySQL from a
production stand point. I think I took alot for granted using SQL Server
Enterprise.
Thanks Once again for your help!
-----Original Message-----
From: gareth davis [mailto:gareth@stripped]
Sent: Wednesday, February 12, 2003 11:12 AM
To: David Nelson
Cc: java@stripped
Subject: Re: Control Center on RedHat
You don't need to do much more than start the mysql daemon. But it does
depend a little on what you are trying to achieve. Don't worry to much
about the control center, it's nice but you don't *need* it.
try starting the mysql daemon, and connect to it via the mysql client.
If it doesn't work then you'll have go through the mysql documentation
for the trouble shooting section.
/etc/init.d/mysql start
If you are trying to connect from another host then it is quite likely
that the linux kernal is perventing access to the mysql port (default
3306). Try connecting to the host on port using telnet, if it won't
connect then your going to have to get your hands dirty with ipchains.
as root try
/sbin/ipchains -L -n
it'll list the current rules that kernal is using for IP connections. If
there isn't one that indicates that connections are accepted to port
3306 from the address you are trying from then bingo, that'll be you're
problem. Let me know if you need a hand configuring ipchains to allow
access.
Hope this helps.
Gareth Davis
David Nelson wrote:
>I realize this list is about Java but first I need to get the JDBC
connector
>working. Do I need to use the Control Center to register the MySQL DB for
>access through localhost or internet?
>
>Just for kicks, if this is the case, how do I get to the control Center in
>RedHat 8.0? The RPM installed without a hitch but I cannot find the app.
>
>Thanks for your help!
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/doc/ (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <java-thread5035@stripped>
>To unsubscribe, e-mail
<java-unsubscribe-gareth=bigyellowfish.net@stripped>
>
>
>
>
