Re: 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 );
            }
        }
    }