After fixing line 2 I get

ERROR 1396 (HY000) at line 3: Operation ALTER USER failed for 'mythtv'@'localhost'

Workaround:
# dif  /hotbu/usr/share/mythtv/initialdb/mc.sql /usr/share/mythtv/initialdb/mc.sql 
2,3c2,3
< CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH mysql_native_password;
< ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'mythtv';
---
> CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED by 'ZZZZZZZZ';
> ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'ZZZZZZZZ';

Where ZZZZZZZZ meets sqa datsbase restrictions. 
see https://bugs.mageia.org/show_bug.cgi?id=19127#c16

Thank you for the report & diagnosis.
I found this (plus a lot saying there were no restrictions!):
---
For MySQL databases, to meet the minimum conditions required for a strong password, the password must contain at least:
    Nine characters
    Two uppercase letters
    Two lowercase letters
    Two numbers
    Two of the following allowed special characters:
      ‘ ~ ! @ # $ % ^ & * ( ) _ - + = { } [ ] / < > , . ; ? ' : | (space)
---

Can this be assigned to you, DavidG, as having done most recent commits for this?

Assignee: bugsquad => geiger.david68210
Summary: mythtv: mc.sql ERROR 1819 (HY000) at line 2: => mythtv: mc.sql ERROR 1819 (HY000) at line 2: /usr/share/mythtv/initialdb/mc.sql needs password correcting

Is this issue reported upstream?

Is this bug fixed with current mythtv--31.0-20210323.1.1.mga8?

(In reply to David GEIGER from comment #4)
> Is this bug fixed with current mythtv--31.0-20210323.1.1.mga8?

No.

Tested just for you today via Mageia-8-netinstall-nonfree-x86_64.iso

Beside the password problem; mariadb-10.5.8-2.mga8 has a create user
syntax change. :(

$ diff mc.sql_install /usr/share/mythtv/initialdb/mc.sql
< CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH mysql_native_password;
< ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'mythtv';
---
> CREATE OR REPLACE USER "mythtv"@"localhost" IDENTIFIED by "ZZZZZZZZ";
> ALTER USER "mythtv"@"localhost" IDENTIFIED BY "ZZZZZZZZ";

Guessing apostrophes can be used instead of double quotes. 

After two days of trying to get my clean Production mythtv install going,
I had no further desire to do another clean install just to check if
single quote would work in place of double quotes.

Hi

Is there any plans on fixing this bug ?

I can't get a fresh install to work.

Best regards
Anders

CC: (none) => anp

If this bug persist please file a new bug upstream at https://github.com/MythTV/mythtv/issues

We stopped supporting Mageia 8 almost 8 months ago 
https://blog.mageia.org/en/2023/12/30/mageia-8-end-of-life/

That means we also stopped fixing Mageia 8 bugs and that this bug report needs to be closed, regardless of whether it was fixed for Mageia 8 or not.

If this particular bug did not get fixed for Mageia 8, then we do regret that.

If this issue is still present in Mageia 9 or cauldron, then please reopen this report, write a comment and adjust the "Version:" field.

If you are not yet a member of one or our teams, then please consider becoming one. https://wiki.mageia.org/en/Contributing
Mageia is a community project, meaning that we, the users, make Mageia together.

The more active contributors we have, the more bug reports will get fixed.
Besides, being active in a team can be very rewarding. It was and is certainly rewarding to me :-D

Resolution: (none) => OLD
Status: NEW => RESOLVED