[SOLVED] How On Earth Do You Get It Working?

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

Moderator: Forum Moderators

dcrobertson01
Newcomer
Posts: 5
Joined: Mon Aug 31, 2015 10:45 pm
New Zealand

Re: [SOLVED] How On Earth Do You Get It Working?

Post by dcrobertson01 » Sat Oct 05, 2019 2:11 am

Reinstalling Lubuntu after a frustrating morning.

" ... made sure I set the root password."

I cannot seem to set a root password. I don't get prompted while installing MySql or MariaDB, I don't get a mysqld.log to grep for a temporary password, the mysql_secure_database (or whatever it is called) says it has set the root password, but won't let me use it to log in, if I start MySQL in safe mode and disabling the grant tables, I can't log in to change the password. MythTV-setup won't connect to the database.

It is driving me nuts. I thought I'd be done by now. My old server is starting to make noises and I want to change to a new machine, but ... maybe just go buy a commercial PVR and be done with it.

If *I* cannot find the MySQL root password, how does the mythtv set up script create the database????

blm-ubunet
Junior
Posts: 92
Joined: Sun Jun 15, 2014 1:08 am
Cambodia

Re: [SOLVED] How On Earth Do You Get It Working?

Post by blm-ubunet » Sat Oct 05, 2019 3:19 am

Don't need root password.. maybe you do to set GRANTs though, don't recall.

You can find debian-sys-maint user's password & can (re)set the client username & password in /etc/mysql/debian.cnf
then connect as required user.
mysql -hHost -uUsername -p mythconverg

or root user:
sudo mysql<enter>
<sudo_pwd>

or may find your normal user password works.. does here.
mysql -uroot -p<enter>
"user_pwd"

Post Reply