Comments - impossible to set root user
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
In 10.3, the mysql.user table can be updated directly with something like the following:
1) Start the server
--skip-grant-tables
.2) Connect and run the following SQL:
3) Run
FLUSH PRIVILEGES
4) Exit, and start the server normally
The above will not work from MariaDB 10.4, which introduced the mysql.global_priv table.