Valid ALTER USER statement throws validation error "unrecognized alter operation"

[pcgeek86]

Describe the bug

When writing an ALTER USER statement in phpMyAdmin, a validation error is thrown, even though the query executes successfully.

To Reproduce

Steps to reproduce the behavior:

Put the following query into the phpMyAdmin SQL query editor.

ALTER USER trevor REQUIRE NONE;

Expected behavior

Query should not show any validation errors in the phpMyAdmin SQL editor.

Screenshots

Server configuration

• Operating system: Windows 10 w/ Docker Desktop
• Web server: Apache
• Database version: MySQL 8.0.26
• PHP version:
• phpMyAdmin version: 5.1.1

Client configuration

• Browser: Firefox 91
• Operating system: Windows 10

[iifawzi]

In order for to fix this issue, I think we would need to create a USER_OPTIONS similar to

sql-parser/src/Components/AlterOperation.php

Line 30 in b18edd6

public static $DB_OPTIONS = [

to be used here:

sql-parser/src/Statements/AlterStatement.php

Lines 112 to 121 in b18edd6

	$options = [];
	if ($this->options->has('DATABASE')) {
	$options = AlterOperation::$DB_OPTIONS;
	} elseif ($this->options->has('TABLE')) {
	$options = AlterOperation::$TABLE_OPTIONS;
	} elseif ($this->options->has('VIEW')) {
	$options = AlterOperation::$VIEW_OPTIONS;
	}
	$this->altered[] = AlterOperation::parse($parser, $list, $options);

otherwise; this will always be the error

sql-parser/src/Components/AlterOperation.php

Lines 311 to 313 in b18edd6

	if ($ret->options->isEmpty()) {
	$parser->error('Unrecognized alter operation.', $list->tokens[$list->idx]);
	}

I don't really know what's the full list of user options, if you could help me @williamdes I might be able to work on a fix.

[williamdes]

@iifawzi you figured out before I finished writing my message here ^^

I was about to give you more details about options but here are the links:

• https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
• https://mariadb.com/kb/en/alter-user/