-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday, 2017-11-30 at 20:37 +0100, Per Jessen wrote:
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 17:37 +0100, Per Jessen wrote:
El 2017-11-30 a las 17:37 +0100, Per Jessen escribió:
Date: Thu, 30 Nov 2017 17:37:25 +0100 From: Per Jessen <per@computer.org> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
Carlos E. R. wrote:
On Thursday, 2017-11-30 at 16:16 -0000, Dave Howorth wrote:
El 2017-11-30 a las 16:16 -0000, Dave Howorth escribió:
Date: Thu, 30 Nov 2017 16:16:07 +0000 From: Dave Howorth <dave@howorth.org.uk> To: opensuse@opensuse.org Subject: Re: [opensuse] How does one setup mythtv?
On Thu, 30 Nov 2017 16:39:13 +0100 (CET) "Carlos E. R." <robin.listas@telefonica.net> wrote:
I figured out that I had to open the program "mysql" as root
Note that mysql root is not the same as linux root. mysql users are completely separate from linux users. So put the username on the command line as Per suggests.
The database is already created. I would have to remove it somehow and start again.
DROP DATABASE mythconverg.
And then, what do I do exactly?
Then you rerun the script you mentioned earlier - mc.sql I think it was.
mariadb is not configured at all. To run the above sql commands, which I think are wrong, I need a password, which I do not know.
When you install mysql or mariadb, the first thing to do is to set the mysql root password. mysql usually reminds you about that. When you run "mysql -u root -p" that is the password you need. You can always set it again using the mysqladmin utility.
Then I also need: «This guide assumes you have already installed MythTV, MySQL, created the MySQL user id and set up your backend to automatically start.»
I need to create that "mysql user id", whichever it is. And I also need the tzinfo thing, it also asks for a password.
The default mythtv database user is "mythtv", the password too. It is created by the script mentioned above. To run the tzinfo thing to load the timezone tables, you need the mysql root user password.
Ok, done all that, see the other post. - -- Cheers, Carlos E. R. (from openSUSE 42.2 x86_64 "Malachite" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlogeLIACgkQtTMYHG2NR9XlSwCfU4opsMsuZgPGTzn19/OjBQt8 L7wAnRaVq+4sG26eVplCozJVdOaVs8On =ceUN -----END PGP SIGNATURE-----