Manual talk:Running MediaWiki on Windows Subsystem for Linux

I'm getting ERROR 1064 (42000): etc. following the commands in Running services section. I got around this by using backticks (`) instead of single quotes ('). Please could somebody who understands MySQL better make an edit so that this is more explicit?

You have to find the IP address of the virtual machine powering your Linux distribution with: ip addr | grep eth0 as shown in Accessing network applications with WSL | Microsoft Docs and use this address instead of localhost.

https://gerrit.wikimedia.org/r/mediawiki/core.git
Should use URL based on:  
https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/ when cloning.

https://gerrit.wikimedia.org/r/mediawiki/skins/Vector.git
Should use URL based on: 
https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/skins/ when cloning.

Christian 🇫🇷 FR (talk) 18:29, 18 November 2020 (UTC)

Microsoft Store offered Ubuntu 20.04 LTS, so that's what got installed (on WSL1). Following Setup works until there's an error with mysql-server. Doing sudo apt install mysql-server produces in /var/log/mysql/error.log:

[ERROR] [MY-012585] [InnoDB] Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.

@Brion VIBBER:

Apparently it's not possible with WSL 1. The May 2020 Update upgrades to WSL 2.

mysql Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Doing at the mysql> prompt:

update user set authentication_string=password('my-password-here'), plugin='mysql_native_password' where user='root';

Gives an error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('my-password-here'), plugin='mysql_native_password' where user='root at line 1

So instead I did:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'my-password-here';

Which seems to work ok with:

Query OK, 0 rows affected (0.01 sec)