[mythtvnz] New install setup - recording problem

[Paulgir]

On Sat, 06 Aug 2016 15:00:35 +1200, Austin Green  
<austin.green at orcon.net.nz> wrote:

> 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

Thanks.I'll make a note of that for the future.

Cheers