Ubuntu install mysql-connector-java for java to connect MySQL database 1. Download mysql-connector-java from https://dev.mysql.com/downloads/connector/j/ 2. Unzip mysql-connector-java-*.tar.gz 3. Copy mysql-connector-java-*-bin.jar to %JAVA_HOME%/jre/lib/ext/ 4. Run the following test case:
Connection conn = null
String url =
"jdbc:mysql://localhost/cookbook"
String userName =
"userName"
String password =
"password"
try
{
Class
.forName(
"com.mysql.jdbc.Driver")
.newInstance()
conn = DriverManager
.getConnection(url, userName, password)
System
.out.println(
"Connected")
}
catch (Exception e)
{
System
.err.println(
"Cannot connect to server")
System
.exit(
1)
}
if (conn != null)
{
try
{
conn
.close()
System
.out.println(
"Disconnected")
}
catch (Exception e)
{ }
}
