How to use MySQL in WSL (Windows Subsystem for Linux)?

Question

How to use mysql in wsl without installing any separate MySQL client for Windows.

Using the [MySQL Command-Line Tool](https://dev.mysql.com/doc/refman/5.7/en/mysql.html) from the WSL itself. — wchiquito, Nov 28 '17 at 05:36

score 2 · Accepted Answer · edited Jun 13 '21 at 21:48

2

Inside your bash command line:

sudo apt-get update
sudo apt-get install mysql-server
mysql_secure_installation

edited Jun 13 '21 at 21:48

Ryan

answered Jan 31 '18 at 09:35

juanzapatac

score 1 · Answer 2 · answered Dec 27 '20 at 14:19

1

Here is how I have accessed MySQL installed in Windows 10 through WSL:

1. Create a user with remote access

CREATE USER 'newuser'@'%' IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%';
FLUSH PRIVILEGES;

2. Update mysql.ini

bind-address=0.0.0.0
# skip-external-locking

3. Test connection using local IP

>mysql -h192.xxx.xx.xx -P 3306 -unewuser -p

answered Dec 27 '20 at 14:19

kashaziz

See related articles: https://serverfault.com/q/257513/119666 and https://stackoverflow.com/q/54377052/470749 – Ryan Jun 13 '21 at 20:03

2 Answers2