Page 2 of 2

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

Posted: Sat Oct 05, 2019 2:11 am
by dcrobertson01
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????

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

Posted: Sat Oct 05, 2019 3:19 am
by blm-ubunet
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>

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