0

I'm new to SQL (I don't know anything). I tried using DataGrip as it seems like a good tool. However, when I created a new Data Source and made it MySQL, when I tried running it it gave me:

java.net.ConnectException: Connection refused: connect.

When I pressed the Test Connection it gave me an error too.enter image description here

What can I do to fix this?

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Higigig
  • 1,175
  • 1
  • 13
  • 25
  • You don't have MySQL running on port 3306 on localhost, or your firewall doesn't allow you to connect. – Mark Rotteveel Jun 24 '20 at 19:55
  • So what do I change it too? – Higigig Jun 24 '20 at 19:56
  • Do you have MySQL installed and is it running? – Mark Rotteveel Jun 24 '20 at 19:57
  • No, I thought I didn't need to install it as DataGrip auto-complete/syntax highlighting and other tools seem to be working. – Higigig Jun 24 '20 at 19:58
  • Datagrip is an IDE for databases, it doesn't provide the database itself (except for JDBC drivers that provide an embedded database, like HSQLDB, Apache Derby and others). The auto-complete / syntax highlighting is a feature of Datagrip, not of the database server. If you want to use MySQL, you will need to install MySQL. – Mark Rotteveel Jun 24 '20 at 20:00
  • Thanks for that! Just downloaded MySQL, and it's working. – Higigig Jun 24 '20 at 20:15

0 Answers0