New to MYSQL

------=_NextPart_000_0007_01C4F89F.C67B62C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I am running mysql4.0.20d on XP. The installation is under c:\mysql. The =
Connector/J installation is under =
c:\mysql\mysql-connector-java-3.0.14-production. Please help me resolve =
the following problems. Thanks in advance for your assistance.

This is the first time I am attempting to do the following:

1. Run this as a service (I can run this manually, not problem there)
Error message:
Could not start MySQL on local computer
Error 1067: The process terminated unexpectedly

2. Trying to run a small JDBC sample from the web to check the =
connectivity
import java.sql.*;

public class jdbcExample {

public static void main(String args[]) {
Connection con =3D null;

try {
Class.forName("com.mysql.jdbc.Driver");
con =3D =
DriverManager.getConnection("jdbc:mysql://localhost:3306/tes t",
"root", "");

if(!con.isClosed())
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");

} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if(con !=3D null)
con.close();
} catch(SQLException e) {}
}
}
}

Error:
Exception: com.jdbc.mysql.Driver

------=_NextPart_000_0007_01C4F89F.C67B62C0--

Re: New to MYSQL

Hello Arun;

At Wed, 12 Jan 2005 12:10:58 -0800,
Arun Sitaraman wrote:
>
> Hi,
>
> I am running mysql4.0.20d on XP. The installation is under c:\mysql. The Connector/J installation is under c:\mysql\mysql-connector-java-3.0.14-production. Please help me resolve the following problems. Thanks in advance for your assistance.
>
> This is the first time I am attempting to do the following:
>
> 1. Run this as a service (I can run this manually, not problem there)
> Error message:
> Could not start MySQL on local computer
> Error 1067: The process terminated unexpectedly

perhaps i am misunderstanding something here, but it seems that 2. will fail
as a result of 1. failing....how could you get connectivity to something that
isnt working?

> 2. Trying to run a small JDBC sample from the web to check the connectivity
> import java.sql.*;
>
> public class jdbcExample {
>
> public static void main(String args[]) {
> Connection con = null;
>
> try {
> Class.forName("com.mysql.jdbc.Driver");
> con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tes t",
> "root", "");
>
> if(!con.isClosed())
> System.out.println("Successfully connected to " +
> "MySQL server using TCP/IP...");
>
> } catch(Exception e) {
> System.err.println("Exception: " + e.getMessage());
> } finally {
> try {
> if(con != null)
> con.close();
> } catch(SQLException e) {}
> }
> }
> }
>
> Error:
> Exception: com.jdbc.mysql.Driver

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: New to MYSQL

>
> 1. Run this as a service (I can run this manually, not problem there)
> Error message:
> Could not start MySQL on local computer
> Error 1067: The process terminated unexpectedly

This could happen for a number of reasons. Most likely the process can't
find the defaults file. If this service is installed, then do:
Mysqld-nt --remove

Then do this

Mysqld-nt --install --defaults-file= file>

Now edit your my.ini file and make sure the data and base paths point to the
correct locations.

-reggie


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: New to MYSQL

There is quite a bit in the MySQL documentation about start up problems
in Windows. You can also try it out not as a service to see if you get
any error messages. Depending on how far it gets there is also a log
which may have helpful messages. It has also been discussed in this
mailing list. Check the archives. I guess your point 2 is not worth
checking until you resolve 1.

John Bonnett

-----Original Message-----
From: Arun Sitaraman [mailto:arun@efycaci.com]=20
Sent: Thursday, 13 January 2005 6:41 AM
To: win32@lists.mysql.com
Subject: New to MYSQL=20

Hi,

I am running mysql4.0.20d on XP. The installation is under c:\mysql. The
Connector/J installation is under
c:\mysql\mysql-connector-java-3.0.14-production. Please help me resolve
the following problems. Thanks in advance for your assistance.

This is the first time I am attempting to do the following:

1. Run this as a service (I can run this manually, not problem there)
Error message:
Could not start MySQL on local computer
Error 1067: The process terminated unexpectedly

2. Trying to run a small JDBC sample from the web to check the
connectivity
import java.sql.*;

public class jdbcExample {

public static void main(String args[]) {
Connection con =3D null;

try {
Class.forName("com.mysql.jdbc.Driver");
con =3D
DriverManager.getConnection("jdbc:mysql://localhost:3306/tes t",
"root", "");

if(!con.isClosed())
System.out.println("Successfully connected to " +
"MySQL server using TCP/IP...");

} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if(con !=3D null)
con.close();
} catch(SQLException e) {}
}
}
}

Error:
Exception: com.jdbc.mysql.Driver

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org