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 <noloa...@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 > -- Dave Humphrey -- d...@uesp.net Founder/Server Admin of the Unofficial Elder Scrolls Pages -- www.uesp.net blog.viud.net - Building the world's toughest USB drive
_______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
