This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
In this article
This step-by-step guide will help you get started connecting your project in WSL to a database. Get started with MySQL, PostgreSQL, MongoDB, Redis, Microsoft SQL Server, or SQLite.
Prerequisites
Running Windows 11 or Windows 10,
updated to version 2004
,
Build 19041
or later.
Install a Linux distribution using WSL and create a Linux user name and password
.
Differences between database systems
Some
popular choices
for a database system include:
MySQL
(SQL)
PostgreSQL
(SQL)
Microsoft SQL Server
(SQL)
SQLite
(SQL)
MongoDB
(NoSQL)
Redis
(NoSQL)
MySQL
is an open-source SQL relational database, organizing data into one or more tables in which data types may be related to each other. It is vertically scalable, which means one ultimate machine will do the work for you. It is currently the most widely used of the four database systems.
PostgreSQL
(sometimes referred to as Postgres) is also an open-source SQL relational database with an emphasis on extensibility and standards compliance. It can handle JSON now too, but it is generally better for structured data, vertical scaling, and ACID-compliant needs like eCommerce and financial transactions.
Microsoft SQL Server
includes SQL Server on Windows, SQL Server on Linux, and SQL on Azure. These are also relational database management systems set up on servers with primary function of storing and retrieving data as requested by software applications.
SQLite
is an open-source self-contained, file-based, “serverless” database, known for its portability, reliability, and good performance even in low-memory environments.
MongoDB
is an open-source NoSQL document database designed to work with JSON and store schema-free data. It is horizontally scalable, which means multiple smaller machines will do the work for you. It's good for flexibility and unstructured data, and caching real-time analytics.
Redis
is an open-source NoSQL in-memory data structure store. It uses key-value pairs for storage instead of documents.
Install MySQL
To install MySQL on a Linux distribution running on WSL, just follow the
Installing MySQL on Linux
instructions in the MySQL docs. You may need to first
enable systemd support
in your
wsl.conf
configuration file.
Example using the Ubuntu distribution:
Open your Ubuntu command line and update the packages available:
sudo apt update
Once the packages have updated, install MySQL with:
sudo apt install mysql-server
Confirm installation and get the version number:
mysql --version
Start MySQL Server / check status:
systemctl status mysql
To open the MySQL prompt, enter:
sudo mysql
To see what databases you have available, in the MySQL prompt, enter:
SHOW DATABASES;
To create a new database, enter:
CREATE DATABASE database_name;
To delete a database, enter:
DROP DATABASE database_name;
For more about working with MySQL databases, see the
MySQL docs
.
To work with MySQL databases in VS Code, try the
MySQL extension
.
You may also want to run the included security script. This changes some of the less secure default options for things like remote root logins and sample users. This script also includes steps to change password for MySQL root user. To run the security script:
Start a MySQL server:
sudo service mysql start
Start the security script prompts:
sudo mysql_secure_installation
The first prompt will ask whether you’d like to set up the VALIDATE PASSWORD COMPONENT, which can be used to test the strength of your MySQL password. If you want to set some simple password, you should not set this component.
You will then set/change password for the MySQL root user, decide whether or not to remove anonymous users, decide whether to allow the root user to login both locally and remotely, decide whether to remove the test database, and, lastly, decide whether to reload the privilege tables immediately.
Install PostgreSQL
To install PostgreSQL on WSL (ie. Ubuntu):
Open your WSL terminal (ie. Ubuntu).
Update your Ubuntu packages:
sudo apt update
Once the packages have updated, install PostgreSQL (and the -contrib package which has some helpful utilities) with:
sudo apt install postgresql postgresql-contrib
Confirm installation and get the version number:
psql --version
There are 3 commands you need to know once PostgreSQL is installed:
sudo service postgresql status
for checking the status of your database.
sudo service postgresql start
to start running your database.
sudo service postgresql stop
to stop running your database.
The default admin user,
postgres
, needs a password assigned in order to connect to a database. To set a password:
Enter the command:
sudo passwd postgres
You will get a prompt to enter your new password.
Close and reopen your terminal.
To run PostgreSQL with
psql
shell:
Start your postgres service:
sudo service postgresql start
Connect to the postgres service and open the psql shell:
sudo -u postgres psql
Once you have successfully entered the psql shell, you will see your command line change to look like this:
postgres=#
Alternatively, you can open the psql shell by switching to the postgres user with:
su - postgres
and then entering the command:
psql
.
To exit postgres=# enter:
\q
or use the shortcut key: Ctrl+D
To see what user accounts have been created on your PostgreSQL installation, use from your WSL terminal:
psql --command="\du"
...or just
\du
if you have the psql shell open. This command will display columns: Account User Name, List of Roles Attributes, and Member of role group(s). To exit back to the command line, enter:
q
.
For more about working with PostgreSQL databases, see the
PostgreSQL docs
.
To work with PostgreSQL databases in VS Code, try the
PostgreSQL extension
.
Install MongoDB
To install MongoDB, see the Mongodb docs:
Install MongoDB Community Edition on Linux
Installing MongoDB may require slightly different steps depending on the Linux distribution being used for installation. Also note that MongoDB installation may differ depending on the version # that you are aiming to install. Use the version drop-down list in the top-left corner of the MongoDB documentation to select the version that aligns with your goal. Lastly, you may need to
enable systemd support
in the
wsl.conf
configuration file of the Linux distribution that you are using with WSL. The
systemctl
command is a part of the systemd init system and may not work if your distribution is using systemv.
VS Code supports working with MongoDB databases via the
Azure CosmosDB extension
, you can create, manage and query MongoDB databases from within VS Code. To learn more, visit the VS Code docs:
Working with MongoDB
.
Learn more in the MongoDB docs:
Introduction to using MongoDB
Create users
CRUD: Create, Read, Update, Delete
Reference Docs
Install Microsoft SQL Server
To install SQL Server on a Linux distribution run by WSL:
SQL Server on Linux
. To work with Microsoft SQL Server databases in VS Code, try the
MSSQL extension
.
Install SQLite
To install SQLite on WSL (ie. Ubuntu):
Open your WSL terminal (ie. Ubuntu).
Update your Ubuntu packages:
sudo apt update
Once the packages have updated, install SQLite3 with:
sudo apt install sqlite3
Confirm installation and get the version number:
sqlite3 --version
To create a test database, called "example.db", enter:
sqlite3 example.db
To see a list of your SQLite databases, enter:
.databases
To see the status of your database, enter:
.dbinfo ?DB?
Database will be empty after creation. You can create a new table for your database with
CREATE TABLE empty (kol INTEGER);
.
Now entering the
.dbinfo ?DB?
will show the database you have created.
To exit the SQLite prompt, enter:
.exit
For more information about working with a SQLite database, see the
SQLite docs
.
To work with SQLite databases in VS Code, try the
SQLite extension
.
Install Redis
To install Redis on WSL (ie. Ubuntu):
Open your WSL terminal (ie. Ubuntu).
Update your Ubuntu packages:
sudo apt update
Once the packages have updated, install Redis with:
sudo apt install redis-server
Confirm installation and get the version number:
redis-server --version
To start running your Redis server:
sudo service redis-server start
Check to see if redis is working (redis-cli is the command line interface utility to talk with Redis):
redis-cli ping
this should return a reply of "PONG".
To stop running your Redis server:
sudo service redis-server stop
For more information about working with a Redis database, see the
Redis docs
.
To work with Redis databases in VS Code, try the
Redis extension
.
See services running and set up profile aliases
To see the services that you currently have running on your WSL distribution, enter:
service --status-all
Typing out
sudo service mongodb start
or
sudo service postgres start
and
sudo -u postgrest psql
can get tedious. However, you could consider setting up aliases in your
.profile
file on WSL to make these commands quicker to use and easier to remember.
To set up your own custom alias, or shortcut, for executing these commands:
Open your WSL terminal and enter
cd ~
to be sure you're in the root directory.
Open the
.profile
file, which controls the settings for your terminal, with the terminal text editor, Nano:
sudo nano .profile
At the bottom of the file (don't change the
# set PATH
settings), add the following:
# My Aliases
alias start-pg='sudo service postgresql start'
alias run-pg='sudo -u postgres psql'
This will allow you to enter start-pg to start running the postgresql service and run-pg to open the psql shell. You can change start-pg and run-pg to whatever names you want, just be careful not to overwrite a command that postgres already uses!
Once you've added your new aliases, exit the Nano text editor using Ctrl+X -- select Y (Yes) when prompted to save and Enter (leaving the file name as .profile).
Close and re-open your WSL terminal, then try your new alias commands.
Troubleshooting
Error: directory-sync fdatasync Invalid argument
Ensure that you are running your Linux distribution in WSL 2 mode. For help switching from WSL 1 to WSL 2, see Set your distribution version to WSL 1 or WSL 2.
Additional resources
Setting up your development environment on Windows
