Cant connect to my SQL database
java, jdbc, mysql
Solution
There is a difference between name of connection and name of Database,try world, test or sakila from schemas in the picture.
Problem
So I'm having an issue connecting to MySQL with Java. Heres my code: ``` import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBAccess { private String Host; private String User; private String Password; public DBAccess() throws ClassNotFoundException, SQLException{ Class.forName("com.mysql.jdbc.Driver"); Password = "password"; Host = "jdbc:mysql://localhost/worlddb"; User = "root"; @SuppressWarnings("unused") Connection connect = DriverManager.getConnection(Host,User,Password); System.out.println("Connected!"); } public void RetreiveData(){ } public void ChangeData(){ } } ``` The error that I'm getting is Exception in thread "main" ``` com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'worlddb' ``` http://postimg.org/image/593stjvjx/ in mySQL workbench, my connection name is "worlddb" hostname is Liquidus(which is the localhost) - socket is MySQL - Port: 3306 Why is this?