Guest User

Untitled

a guest
Jul 30th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.43 KB | None | 0 0
  1. Can't connect to MySQL on Windows 7 using JDBC, but works via phpmyadmin and other admin tools?
  2. package sqltest;
  3.  
  4.  
  5. import com.mysql.jdbc.Driver;
  6. import java.sql.DriverManager;
  7. import java.util.Properties;
  8.  
  9. public class main {
  10.  
  11. public static void main(String[] args) throws Exception {
  12. String url = "jdbc:mysql://localhost:3306/dbname?user=user&password=****&";
  13.  
  14. Driver driver = (Driver) Class.forName("com.mysql.jdbc.Driver").newInstance();
  15.  
  16. DriverManager.getConnection(url);
  17. }
  18.  
  19. }
  20.  
  21. Server version 5.5.20-log
  22. Protocol version 10
  23. Connection localhost via TCP/IP
  24. TCP port 3306
  25. Uptime: 1 min 37 sec
  26.  
  27. Threads: 1 Questions: 17 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.175
  28.  
  29. 120314 21:37:20 [Note] Plugin 'FEDERATED' is disabled.
  30. 120314 21:37:20 InnoDB: The InnoDB memory heap is disabled
  31. 120314 21:37:20 InnoDB: Mutexes and rw_locks use Windows interlocked functions
  32. 120314 21:37:20 InnoDB: Compressed tables use zlib 1.2.3
  33. 120314 21:37:20 InnoDB: Initializing buffer pool, size = 128.0M
  34. 120314 21:37:20 InnoDB: Completed initialization of buffer pool
  35. 120314 21:37:20 InnoDB: highest supported file format is Barracuda.
  36. 120314 21:37:20 InnoDB: Waiting for the background threads to start
  37. 120314 21:37:21 InnoDB: 1.1.8 started; log sequence number 1619921
  38. 120314 21:37:21 [Note] Event Scheduler: Loaded 0 events
  39. 120314 21:37:21 [Note] wampmysqld: ready for connections.
  40. Version: '5.5.20-log' socket: '' port: 3306 MySQL Community Server (GPL)
  41. 120314 21:38:02 [Note] wampmysqld: Normal shutdown
  42.  
  43. 120314 21:38:02 [Note] Event Scheduler: Purging the queue. 0 events
  44. 120314 21:38:02 InnoDB: Starting shutdown...
  45. 120314 21:38:02 InnoDB: Shutdown completed; log sequence number 1619921
  46. 120314 21:38:02 [Note] wampmysqld: Shutdown complete
  47.  
  48. rem Execute Java with the applicable properties
  49. if not "%JPDA%" == "" goto doJpda
  50. if not "%SECURITY_POLICY_FILE%" == "" goto doSecurity
  51. %_EXECJAVA% %JAVA_OPTS% %CATALINA_OPTS% %DEBUG_OPTS% -Djava.net.preferIPv4Stack=true -Djava.endorsed.dirs="%JAVA_ENDORSED_DIRS%" -classpath "%CLASSPATH%" -Dcatalina.base="%CATALINA_BASE%" -Dcatalina.home="%CATALINA_HOME%" -Djava.io.tmpdir="%CATALINA_TMPDIR%" %MAINCLASS% %CMD_LINE_ARGS% %ACTION%
  52. goto end
  53. :doSecurity
  54. %_EXECJAVA% %JAVA_OPTS% %CATALINA_OPTS% %DEBUG_OPTS% -Djava.net.preferIPv4Stack=true -Djava.endorsed.dirs="%JAVA_ENDORSED_DIRS%" -classpath "%CLASSPATH%" -Djava.security.manager -Djava.security.policy=="%SECURITY_POLICY_FILE%" -Dcatalina.base="%CATALINA_BASE%" -Dcatalina.home="%CATALINA_HOME%" -Djava.io.tmpdir="%CATALINA_TMPDIR%" %MAINCLASS% %CMD_LINE_ARGS% %ACTION%
  55. goto end
  56. :doJpda
  57. if not "%SECURITY_POLICY_FILE%" == "" goto doSecurityJpda
  58. %_EXECJAVA% %JAVA_OPTS% %CATALINA_OPTS% %JPDA_OPTS% %DEBUG_OPTS% -Djava.net.preferIPv4Stack=true -Djava.endorsed.dirs="%JAVA_ENDORSED_DIRS%" -classpath "%CLASSPATH%" -Dcatalina.base="%CATALINA_BASE%" -Dcatalina.home="%CATALINA_HOME%" -Djava.io.tmpdir="%CATALINA_TMPDIR%" %MAINCLASS% %CMD_LINE_ARGS% %ACTION%
  59. goto end
  60. :doSecurityJpda
  61. %_EXECJAVA% %JAVA_OPTS% %CATALINA_OPTS% %JPDA_OPTS% %DEBUG_OPTS% -Djava.net.preferIPv4Stack=true -Djava.endorsed.dirs="%JAVA_ENDORSED_DIRS%" -classpath "%CLASSPATH%" -Djava.security.manager -Djava.security.policy=="%SECURITY_POLICY_FILE%" -Dcatalina.base="%CATALINA_BASE%" -Dcatalina.home="%CATALINA_HOME%" -Djava.io.tmpdir="%CATALINA_TMPDIR%" %MAINCLASS% %CMD_LINE_ARGS% %ACTION%
  62. goto end
  63.  
  64. :end
Add Comment
Please, Sign In to add comment