#HOW TO INSTALL SQL ON MAC DRIVER#
#HOW TO INSTALL SQL ON MAC DOWNLOAD#
#HOW TO INSTALL SQL ON MAC WINDOWS#

If you did everything properly, you should have something like this on your screen:Д¬lick OK and the connection will be established! Username: This should be the username that you set up when you installed your data server. Note: usually when you get access to a database, you get this information (IP address, port, database name) from the admin of the database.

Finally provide the name of the database that you want to access (it can be anything that has been created beforeвЂ¦ If you followed my tutorialsВ so far, it will be postgres!).

If you followed my tutorials so far, this is going to be 5432 for you as well!

The next step (green) is the port number.

Type your serverвЂ™s IP address (the format should be something like: 46.101.100.000)

The next part (red) will be the IP address of your server.

The jdbc:postgresql:// is a constant in our case.

#HOW TO INSTALL SQL ON MAC DRIVER#

If you can see it on the вЂњLibrary listвЂќ (shown in the above picture), click OK and your driver will be set! (IвЂ™ve typed in: вЂњMy first postgreSQL connectionвЂќ)Дriver: Select PostgreSQL! You will get an error message. Name: You have to name your connection, which can be anything. It requires a few pieces of information to make the connection: When you run your SQL Workbench application, the first window will be the вЂњConnect window.вЂќ If not, you can still access it from File вЂ“В» Connect Window. Note: if you donвЂ™t have your own data server to practice yet, set one up here: Install Python, R, SQL and bash! Important! Put this file in a folder where it is safe and where you wonвЂ™t accidentally move or remove it. When IвЂ™m writing this article (May, 2017), the right file is: PostgreSQL JDBC 4.2 Driver, 42.1.1

#HOW TO INSTALL SQL ON MAC DOWNLOAD#

Read the instructions and download the appropriate version (in our case, this is going to be the one that is compatible with Java8+). Unfortunately you have to download a postgreSQL plugin too! On Mac: right click on SQLWorkbenchJ вЂ“В» Open.On Windows: right click on SQLWorkbench.exe вЂ“В» Run as administrator.Once you have downloaded your file, unzip it! You donвЂ™t have to install anything, just run the SQL Workbench application. Whether itвЂ™s on the top for you as well or not, please go and find this exact version: Build 124.ДЄnd make sure you are downloading the right version for your operating system: When I write this article, Build 124 is on the top. Here, youвЂ™ll see all the previously released SQL Workbench versions. SQL Workbench works with Java8+, so until you have this package, you wonвЂ™t be able to run it! Java will be useful anyway, so simply download and install it from here: STEP 1: Download and install Java 8+ on your computer!

#HOW TO INSTALL SQL ON MAC WINDOWS#

Today I will show you how you can install it too! The setup process is more or less the same on Mac, Windows and Linux, but IвЂ™ll highlight the slight differences in my article вЂ“ and you can always select the appropriate solutions for yourself. In my previous SQL for data analysis tutorial,В I briefly mentioned that I prefer SQL WorkbenchВ over pgadmin4В for SQL querying.

How to install sql on mac