MySQL Forums
Forum List  »  Newbie

What statement replaces IDENTIFIED BY PASSWORD 'hash_string'?
Posted by: Jeffrey Walton
Date: March 30, 2021 08:57AM

Hi Everyone,

We are migrating a Mediawiki database from CentOS with antique software to Ubuntu 20 with MySQL 8. We are working through the Mediawiki manual on [Creating System Users](https://www.mediawiki.org/wiki/Manual:Installation/Creating_system_accounts).

The manual says to issue the following command, which is failing:

<pre>GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION ;</pre>

It appears MySQL 8 removed <tt>IDENTIFIED BY 'password'</tt> (see [MySQL 8.0 Release Notes](https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html). But the release notes don't provide the replacement statement. It only says:

<pre>IDENTIFIED WITH auth_plugin AS 'hash_string'</pre>

No one here is a MySQL expert. We don't know what auth_plugin should be.

What do we replace the removed statement with?

Options: ReplyQuote


Subject
Written By
Posted
What statement replaces IDENTIFIED BY PASSWORD 'hash_string'?
March 30, 2021 08:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.