![]() All the inspections, quick-fixes, and other coding assistance features are also available. Complete support of a database vendor includes such features as enhanced code completion and better retrieval of database objects (introspection). In DataGrip, you can create the following data sources:ĭatabase data sources: connection configurations for the operational databases that contain data.įor different database vendors, DataGrip provides complete support and basic support. Data sources with an active connection to a database are marked with a green dot in the corner of their icons. You can see the list of created data sources in the Database Explorer ( View | Tool Windows | Database Explorer). To access the dialog, in the Database Explorer ( View | Tool Windows | Database Explorer), click the Data Source Properties button ( ) on the toolbar. You can configure your data sources in the Data Sources and Drivers dialog ( Control+Alt+Shift+S). In data source settings, you can also select databases and schemas for introspection and display in Database Explorer, and change the driver for your connection. For example, host, port, database name, driver, SSH and SSL configuration settings, and so on. It stores a list of connection details that are used to establish connection to a database. *.*.*.* link and select 5.1.40.Ĭlick the created MySQL data source entry.Data source is a connection configuration. In the Database Explorer Command 1 ( View | Tool Windows | Database Explorer), click the Data Source Properties icon ( ).Ĭlick the Driver link and select Go to Driver. You can open data source properties by using one of the following options: Cannot connect to MySQL 5.* in the cloud with SSL To delete a password, right-click the Password field and select Set Empty. To view and edit data of a database object, open Data editor and viewer by double-clicking the object. To write and run queries, open the default query console by clicking the data source and pressing F4. ![]() DataGrip will introspect and show them.įor more information about displaying schemas in Database Explorer, refer to the Show all databases or schemas tutorial.įor more information about working with database objects in DataGrip, refer to Database objects. To see more schemas under your new data source node, click the N of M button and select the ones you need. įor more information about Database Explorer, see the corresponding reference topic. ![]() If you also want to work with other schemas, in the Schemas tab, select them for the introspection.įind your new data source in Database Explorer ( Command 1). (Optional) By default, only the default schema is introspected and available to work with. In case of any connection issues, refer to the Cannot connect to a database page. To do that, click the Test Connection link at the bottom of the connection details area. To delete a password, right-click the Password field and select Set Empty.įor the reference information about connection settings (for example, Host, Port, and so on) on the General and other tabs of Data Sources and Drivers dialog ( Control+Alt+Shift+S), see Data source settings.Įnsure that the connection to the database can be established using the provided details. Alternatively, paste the JDBC URL in the URL field. To download JDBC drivers for MySQL 5.1, click the Download link at the bottom of the dialog. Navigate to Data Source and select MySQL.Ĭlick the Driver link and select MySQL for 5.1. ![]() In the Database Explorer ( View | Tool Windows | Database Explorer), click the New icon ( ) in the toolbar. You can do this using one of the following ways:įrom the main menu, navigate to File | New | Data Source and select MySQL. To connect to the database, create a data source that will store your connection details.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |