Mysql/Mariadb will not accept mc.sql for new install

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
cfilson
Newcomer
Posts: 4
Joined: Thu May 08, 2014 9:54 pm
Canada

Mysql/Mariadb will not accept mc.sql for new install

Post by cfilson »

I had a hard drive failure and decided it was time to update Mageia from 6 to 7.1 and Mythtv from 0.28 to 30 at the same time.
The new drive was set up and Mariadb 10.3.17 is up and running. I then installed Mythtv 0.30 from the package manager and followed the instructions to load mc.sql to the new server. This is when things go bad.
The attempt to load mc.sql failed with:
ERROR 1819 (HY000) at line 2: Your password does not satisfy the current policy requirements
The mythconverg database was created but line 2 triggers the error.
After lots of searching the only thing I found was a global variable "strict_password_validation" which I have turned OFF with no changes. The error is still produced.
Even after logging into the database as root, line 2 of mc.sql still throws the same error.
I tried loading a backup with mythconverg_restore but the same error is generated.
I sure hope someone has a solution for this as my fingers are getting sore from too much searching and trying.
Post Reply