[mythtv-users] error during upgrade from V30 to V31

[James Abernathy]

>
> jim at mythbuntu:~$ sudo mysql -u root mysql
> [sudo] password for jim:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 1384
> Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
>
> Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> MariaDB [mysql]> CREATE USER 'blah'@'%' IDENTIFIED WITH
> mysql_native_password;
> Query OK, 0 rows affected (0.04 sec)
>
> MariaDB [mysql]> CREATE USER 'blah'@'%' IDENTIFIED WITH
> mysql_native_password;
> ERROR 1396 (HY000): Operation CREATE USER failed for 'blah'@'%'
> MariaDB [mysql]>
>
> Jim A
>
>
I'm not a mysql user so I'm not sure what all these commands are doing so
I'm sorry if about all the questions.
I do not understand why it says in the mysql signon that it's ubuntu 16.04.
I get:

jim at mythbuntu:~$ lsb_release -d
Description: Ubuntu 18.04.4 LTS
...and...
jim at mythbuntu:~$ uname -a
Linux mythbuntu 4.15.0-88202002241620-generic #0+mediatree+hauppauge-Ubuntu
SMP Thu Feb 27 01:05:48 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

also when I do apt-cache policy mariadb* I get a number of packages
installed. it seems mariadb-server-10.0 is installed and
mariadb-server-10-1 is a candidate but is not installed.

However, if I do apt update, all my packages are up to date.

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200325/52aec02f/attachment.htm>