[mythtvnz] New install setup - recording problem

[Austin Green]

On Sat, 06 Aug 2016 13:15:35 +1200
Paulgir <paulgir at gmail.com> wrote:
> >>> I can't access the database with> mysql -u root -p with that password  
> >>> but I can with> mysql -u mythtv -p
> >> root has a different password than mythtv. You set the root password  
> >> when mysql-server was installed.
> >> You can reset it with sudo dpkg-reconfigure mysql-server-versionnumber

There is also a 'back-door' way in, at least on Debian-derived distros:
	sudo mysql --defaults-file=/etc/mysql/debian.cnf
Will start up MySQL as the system maintenance user.
Then you can do all the password resetting stuff:
	use mysql;
	update user set password = password('beetroot') where user = 'root';
	commit;
	grant all privileges on *.* to 'root'@'localhost' identified by 'beetroot' with grant option;
	flush privileges;
	quit
Then you should be OK to log in as MySQL root, after which you can do anything.
	mysql -u root -p mysql