![]() ![]() Create an SQL lite database and install the drivers(the driver can be installed just with a. ![]() Then you can create a new Data Source, and set the properties to host = localhost, user = my_test_db_user, and password = keyboard_cat. Create 4 text files from the gives question 2. When you create a data source, a database console is created automatically. Grant all privileges on my_test_db to my_test_db_user Query console is an SQL editor attached to a particular data source. Similarly, to create a new user for this data base, create a new sql file "create_my_test_db_user.sql" create user my_test_db_user with encrypted password 'keyboard_cat' ![]() DataGrip has a drop-down menu in the upper-right corner above your file menu, so make sure you have selected " ", since this is the user Data Source that has privileges to create a new database. When you want to execute this code, make sure that you are using the correct "console". Create a Database using DataGrip - YouTube 0:00 / 27:19 Intro Create a Database using DataGrip Tom Nurkkala 1.94K subscribers Subscribe 127 17K views 2 years ago COS 243 - Multi-tier Web App. I like to keep track of all the commands I have run by attaching a new directory (File Menu | Attach Directory) and creating new files with descriptive names, such as "create_my_test_db.sql" and enter the sql to create the database: create database my_test_db DataGrip is a multi-engine database environment that provides efficient schema navigation and query execution. The tricky part of creating a new database, is that you have to do it using a DataGrip "Data Source" where are are connected as a user that has the priviledge to create a database, which is generally the "admin" user that you added when you first installed Postgres which is connected to the main "postgres" database. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |