Logging in to MySQL
I seems to me I was able to login to a MySQL database some years ago,
but now for the life of me I can't get the simplest code to work.
Here is my SSCCE. I can access the database fine from the command
line with mysql -uroot -psesame
/*
* @(#)SSCCE.java
*
* Summary: Attempt to connect to an MySQL database
*
* Copyright: (c) 2009 Roedy Green, Canadian Mind Products,
http://mindprod.com
*
* Licence: This software may be copied and used freely for any purpose
but military.
* http://mindprod.com/contact/nonmil.html
*
* Requires: JDK 1.6+
*
* Created with: IntelliJ IDEA IDE.
*
* Version History:
* 1.0 2009-22 - initial version.
*/
package com.mindprod.macro;
import static java.lang.System.err;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* Attempt to connect to an MySQL database.
*
* @author Roedy Green, Canadian Mind Products
* @version 1.0 2009-22 - initial version.
* @since 2009
*/
public class SSCCE
{
/**
* Test harness
*
* @param args
*/
public static void main( String[] args )
{
try
{
final Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mindprod?user=root&password=sesame" );
}
catch ( SQLException e )
{
err.println( ">>> " + e.getMessage() + " <<<" );
e.printStackTrace( err );
}
}
}
--
Roedy Green Canadian Mind Products
http://mindprod.com
Nothing is so good as it seems beforehand.
~ George Eliot (born: 1819-11-22 died: 1880-12-22 at age: 61) (Mary Ann Evans)