Manual talk:Running MediaWiki on Windows Subsystem for Linux
Add topic| This page used the Structured Discussions extension to give structured discussions. It has since been converted to wikitext, so the content and history here are only an approximation of what was actually displayed at the time these comments were made. |
ERROR 1064 (42000): You have an error in your SQL syntax;
[edit]The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
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) Rob Kam (talk) 15:36, 31 May 2020 (UTC)
Dependency setup section produces an error
[edit]The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
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: Rob Kam (talk) 17:03, 3 June 2020 (UTC)
- Apparently it's not possible with WSL 1. The May 2020 Update upgrades to WSL 2. Rob Kam (talk) 16:08, 4 June 2020 (UTC)
obsolete links /r/mediawiki/ need to be realigned
[edit]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)
http://localhost/w/ does not work
[edit]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. Olht (talk) 19:09, 12 October 2021 (UTC)
Running services section
[edit]The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.
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? Rob Kam (talk) 15:44, 23 May 2024 (UTC)