Hi Everyone, We switched VPS providers. I am restoring a wiki database via a MySQL dump. The import/source was successful, but it did not include the users. The dump only had the wiki database.
The new machine uses: # mysql --version mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)) I am working from https://www.mediawiki.org/wiki/Manual:Installation/Creating_system_accounts. I am trying to grant privileges on our Mediawiki user account. I manually created the account. vm# mysql -u root -p <password> 'my_wiki' and 'mwuser' are correct. They are used in LocalSettings.php. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | my_wiki | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.00 sec) mysql> SELECT user FROM mysql.user; +------------------+ | user | +------------------+ | debian-sys-maint | | mwuser | | mysql.infoschema | | mysql.session | | mysql.sys | | root | +------------------+ 6 rows in set (0.00 sec) Now, following the article: mysql> GRANT ALL PRIVILEGES ON my_wiki.* TO 'mwuser'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION ; 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 'IDENTIFIED BY 'password' WITH GRANT OPTION' at line 1 I've tried removing pieces of the SQL statement, like omitting 'WITH GRANT OPTION'. No joy. Does anyone know what is wrong with the SQL statement? Thanks in advance. _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
