My SQL status:
mysql> status
--------------
c:/wamp/bin/mysql/mysql5.1.36/bin/mysql.exe Ver 14.14 Distrib 5.1.36, for Win32
(ia32)
Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.36-community-log MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 1 min 37 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 15 Flush tables: 1 Open tabl
es: 8 Queries per second avg: 0.41
--------------
Is it because my TCS port is 3306 and url parameter in DriverManager is http://127.0.0.1:8080? What could be the problem?
Prapia prap wrote:Is it because my TCS port is 3306 and url parameter in DriverManager is http://127.0.0.1:8080?
Well, yeah. If your database server is listening at port 3306, and you want to connect to the database server, then you'll want to connect to it on port 3306. Not port 8080.
As your web server is already running on port 8080 and you are trying to connect to the database on same port it is giving you AccessControlException.Correcting connection string should solve your purpose.