Shulou(Shulou.com)05/31 Report--

How to install and use DataGrip? In response to this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more small partners who want to solve this problem find a simpler and easier way.

Installation of MySQL

mysql-8.0.19-winx64

Add environment variables after decompression

Add mysql path (/bin) to path (environment variable).

For example, my installation path is C:\Users\skywf\mysql-8.0.19-winx64, so I configure the environment variables like the following figure

Step 3: Enter command indicator (cmd) Administrator privileges,

Enter mysqld --initialize-insecure --user=mysql,

Here I first configure no password, followed by a password (because lazy to remember that random password)

Type mysqld -install again,

Service successfully installed. indicates configuration is complete

Start database net start mysql,

Type mysql -u root -p, enter directly without entering password

mysql> appears to indicate that the configuration is complete

Enter alter user() identified by "password";

Here, for the convenience of using datagrip later, we first set up a database called company.

create database company;

After modification, enter exit; or exit (with or without semicolon)

exit the database

Enter net stop mysql to close the database

Don't forget the semicolon above code

Configure DataGrip

What is DataGrip?

DataGrip supports almost all major relational database products such as DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL

Server, Sqllite and Sybase, etc., and provides a simple and easy-to-use interface, developers will not encounter any difficulties. Datagrip 2018

Is a database management tool, support MySQL, Oracle, SQL

Server, Sqllite and other mainstream relational databases, in addition to executing sql, creating tables, creating indexes and exporting data and other common functions, more importantly Datagrip

2018 can also have highlighted prompts on keywords, and the prompts for fields are also very intelligent.

ataGrip is a multi-engine database environment published by JetBrains that supports MySQL and PostgreSQL, Microsoft SQL Server and Oracle, Sybase, DB2, SQLite, and HyperSQL, Apache Derby, and H2. DataGrip supports CSV file import, JSON and XML literal support, regular expression checking, dynamic SQL support, table completion, keyboard layout completion, and more. It is a rare database tool on Mac, Windows and Linux platforms.

Download DataGrip

click to download

Install DataGrip

For convenience's sake, I'll add them all here.

To activate, download genuine activation code via link below

Link: https://pan.baidu.com/s/1RXXdiVVQXDpmPcT1R6ab5A Extract Code: im3q

Note:

Free to modify the hosts file, if modified please delete the URL and activate

(Updated September 28)

(You need to use a computer browser to open the download)

(Do not use WeChat browser)

(Note: If cancelled is displayed after activation, please restart the software.)

Configure DataGrip

Create a new project, I call it test3 here

See the lower right corner there is a call you connect to the database? Click

Enter information and find an error (unless you are not in China, you must report an error)

The Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezon'

modified the time zone

set global time_zone='+8:00';

Here we connect to our own company database

Then we can see our databases.

Just look at the tables.

View port numbers

(Occasionally due to the default port number changed, you need to check the port number yourself)

show global variables like 'port';

The answers to questions about how to install and use DataGrip are shared here. I hope the above content can help you to some extent. If you still have a lot of doubts, you can pay attention to the industry information channel to learn more.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.