全家桶 jetbrains

遇到问题

datagrip:

Server returns invalid timezone. Need to set ‘serverTimezone’ property.
解决:
将serverTimezone后面的UTC改成GMT

基本操作

datagrip:
查看数据库:

 show databases;

±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
±-------------------+
3 rows in set (0.00 sec)

创建数据库:

 create database test;

±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
±-------------------+
4 rows in set (0.00 sec)

选择数据库并创建表:

 use test

 create table one (id int,name varchar(20));

插入数据:

insert into one (id,name) values (1,'xiaoming');

设置

1.激活
2.设置/etc/hosts

0.0.0.0 account.jetbrains.com