Install MySQL client on WSL Ubuntu.
<pre><code class="lang-bash">sudo apt install mysql-client-core-8.0
</code></pre>
Back yo Windows, run:
<pre><code class="lang-bash">mysql -u root -p
</code></pre>
Enter this command to enable root account for any host:
<pre><code class="lang-bash">&gt; CREATE USER 'root'@'%' IDENTIFIED BY 'root'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
&gt; FLUSH PRIVILEGES;
&gt; exit;
</code></pre>
Next, on Wsl2, run:
<pre><code class="lang-bash">mysql -u root -p -h "$(hostname).local"
</code></pre>
This should works.
If still shows:
<pre><code class="lang-bash">ERROR 2003 (HY000): Can't connect to MySQL server on xxx
</code></pre>
Try install <code>libnss-mdns</code>
<pre><code class="lang-bash">sudo apt install libnss-mdns
</code></pre>
Now you may want to enter the hostname to <code>.env</code> file, just type:
<pre><code class="lang-bash">echo $(hostname).local
</code></pre>
And copy the result to your <code>.env</code> file.

Install MySQL client on WSL Ubuntu.

```bash
sudo apt install mysql-client-core-8.0
```

Back yo Windows, run:

```bash
mysql -u root -p
```

Enter this command to enable root account for any host:

```bash
> CREATE USER 'root'@'%' IDENTIFIED BY 'root'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
> FLUSH PRIVILEGES;
> exit;
```

Next, on Wsl2, run:

```bash
mysql -u root -p -h "$(hostname).local"
```

This should works.

If still shows:

```bash
ERROR 2003 (HY000): Can't connect to MySQL server on xxx
```

Try install `libnss-mdns`

```bash
sudo apt install libnss-mdns
```

Now you may want to enter the hostname to `.env` file, just type:

```bash
echo $(hostname).local
```

And copy the result to your `.env` file.

SIMULAR Lab

SIMULAR Lab

Connect Windows (XAMPP) MySQL from WSL2 Ubuntu

Table of contents

No headings in the article.