Connect to a MySQL database in DataGrip.
In order to connect to a MySQL database in DataGrip, you need to follow the steps below:
- Open the DataGrip application.
- On the welcome page, click “Create New Project” or select “File” from the top left corner and choose “New Project”.
- In project settings, click on the “+” button and select “Data Source”.
- Select the “MySQL” database type in the open dialog box.
- Input the database connection information, including the host name (IP address or domain name), port number, database name, username, and password.
- Click the “Test Connection” button to verify whether the connection information is correct and can successfully connect to the database.
- Click the “OK” button to save the data source settings.
- On the left-hand panel of the DataGrip main interface, you can see the connected MySQL database.
- You can click on the database name to expand database objects, such as tables, views, stored procedures, etc.
- You can write and execute SQL queries in the editor.
The steps above outline how to connect to a MySQL database in DataGrip. Depending on the specific circumstances, additional connection information may be required, such as SSL options or SSH tunneling.