That command looks fine and works for me so not sure what the exact problem might be. A few suggestions to consider:
- You have a ' or other special character in 'password' that needs to be escaped. - You are using an old version of MySQL with a different command format. - Your mysql root account doesn't have permission (probably not, I think you would get a different error message). - Try retyping the command (don't copy and paste) from the simplest/shortest command possible and see where you start getting errors.
On Tue, Mar 30, 2021 at 9:09 AM Jeffrey Walton noloader@gmail.com wrote:
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