I installed Tomcat 6 and apache XAMPP on MAC OS. XAMPP includes MySQL.
I include TOMCAT and XAMPP.
Then I try to connect to JDBC to MySQL.
public class main {
public static void main(String[] args) {
Connection conn = null;
try
{
String userName = "root";
String password = "";
String url = "jdbc:mysql://localhost/facility";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url, userName, password);
System.out.println ("Database connection established");
}
catch (Exception e)
{
System.out.println ("Cannot connect to database server");
}
finally
{
if (conn != null)
{
try
{
conn.close ();
System.out.println ("Database connection terminated");
}
catch (Exception e) { }
}
}
}
}
Well, it returns to me "Unable to connect to the database server."
source
share