-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Todd O'Bryan wrote: | I've managed to get mysql up and running again (I don't know how) but | JDBC won't connect to it. | | Here's my little simple code: | ------------------------------------------------ | import java.sql.*; | import java.io.*; | | public class MySQLTester { | | public static void main(String[] args) throws Exception { | Class.forName("com.mysql.jdbc.Driver"); | System.out.println("Loaded Driver..."); | | DriverManager.setLogWriter(new PrintWriter(System.out)); | | | Connection con = | DriverManager.getConnection("jdbc:mysql://localhost/test","tobryan1", | "aoeuidhtns"); | System.out.println("Got connection..."); | | Statement s = con.createStatement(); | s.executeUpdate("CREATE TABLE students (login char(8), last | VARCHAR(20), first VARCHAR(20), " + | "nickname VARCHAR(20), course CHAR(4), period | INT)"); | } | } | ------------------------ | And here's what happens: | | [iBook:18]> java MySQLTester | Loaded Driver... | DriverManager.getConnection("jdbc:mysql://localhost/test") | trying | driver[className=com.mysql.jdbc.Driver,[EMAIL PROTECTED] | | and it hangs forever. | | ------------------------- | I can connect to mysql using the same user name and password, however.... | | [iBook:20]> mysql -u tobryan1 -p | Enter password: | Welcome to the MySQL monitor. Commands end with ; or \g. | Your MySQL connection id is 9 to server version: 4.0.12-standard | | Type 'help;' or '\h' for help. Type '\c' to clear the buffer. | | mysql> use test; | Database changed | mysql> show tables; | Empty set (0.00 sec) | | mysql> | ------------------------- | I've searched for info on troubleshooting the JDBC connection and | skimmed the O'Reilly book by George Reese, but to no avail. | | Should I just give up, or is there something I can do to figure out | what's going wrong? | | Thanks, | Todd
When you don't specify a hostname (and 'localhost' doesn't count, use '127.0.0.1') to the mysql commandline client, it uses Unix domain sockets to connect to the server.
JDBC has to use TCP/IP, because Java doesn't have support for Unix domain sockets.
What happens if you do:
mysql -h 127.0.0.1 -u tobryan1 -p
What happens if you telnet to 'localhost 3306'...does the server answer, or do you just sit forever?
If neither of these work, than neither will JDBC...do you have a firewall setup on your machine that would block 127.0.0.1? Was mysqld started with '--skip-networking' ???
-Mark
- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
~ __ ___ ___ ____ __ ~ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> ~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java ~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ~ <___/ www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+iwg5tvXNTca6JD8RAuwwAKC86/iQI35O+DYV89O4bAdDnDf8zACgma1w HdDjewEWMRj5/0gYmM9MARo= =ay/F -----END PGP SIGNATURE-----
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]